9 Replies Latest reply: Jan 17, 2014 11:51 AM by Jeff Smith SQLDev PM RSS

problem using dbms_xplan.display_cursor in SQL Developer 4

user11985271 Newbie
Currently Being Moderated

In SQL Developer 3 I am able to successfully do the following:

 

alter session set statistics_level = all;

select ....

select * from table (dbms_xplan.display_cursor(null,null,'ALLSTATS LAST ALIAS'));

 

This shows the trace of the SQL I ran. However in Developer 4, the same statements always show a trace of

select child_number from v$sql   where sql_id = :1     order by child_number

 

Is there a configuration option that corrects this?

 

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points