ORA-06502 using "advisor" ("conseils SQL" in french): sorry but I only have a french version and I am not sure with my translations: I try to know the TOP SQL request in elapsed time: I can display the execution plan, but not have an advise to reduce the time. I tryied to modify NLS parameters but it don't work and have ORA-06502 error.
If you are not using the latest production version of SQL Developer (3.1.07.42), possibly you are hitting this bug: Bug 9461849 - SQLDEV2.1: HIT ORA-06502 IN TOP SQL BY WAITS FOR SOME SQL CLAUSES
This was reported in a Chinese language environment, Reports -> ... -> Database Administration -> Top SQL, but has been fixed for 3.1.
SQL Developer Team