Simple sqlplus to display 12c adaptive explain plan with autotrace on statistics – adaptive query optimization

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’))
 

Leave a Comment

Scroll to Top