set autotrace on statistics;
set linesize 150 pagesize 1000;
explain plan for
select distinct object_name from dba_objects;
select * from table (dbms_xplan.display(format=>’adaptive’))
set autotrace on statistics;
set linesize 150 pagesize 1000;
explain plan for
select distinct object_name from dba_objects;
select * from table (dbms_xplan.display(format=>’adaptive’))