9 Replies Latest reply: Jan 17, 2014 1:51 PM by Jeff Smith Sqldev Pm-Oracle RSS

    problem using dbms_xplan.display_cursor in SQL Developer 4

    user11985271

      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.