2014-09-17 13:23:48 +02:00

5 lines
249 B
SQL

prompt Display Execution plan in advanced format for sqlid &1
--select * from table(dbms_xplan.display_cursor('&1',null,'ADVANCED +ALLSTATS LAST +PEEKED_BINDS'));
select * from table(dbms_xplan.display_cursor('&1',null,'ADVANCED +ALLSTATS LAST'));