9 Replies Latest reply on Jan 17, 2014 7:51 PM by thatJeffSmith-Oracle

    problem using dbms_xplan.display_cursor in SQL Developer 4


      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?