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'));