Explain plan


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