set autotrace traceonly statistics
set autotrace traceonly explain
explain plan for select * from user_table;
select plan_table_output from table(dbms_xplan.display('plan_table', null, 'serial'));
A bunch of useful DB scripts
set autotrace traceonly statistics
set autotrace traceonly explain
explain plan for select * from user_table;
select plan_table_output from table(dbms_xplan.display('plan_table', null, 'serial'));