9i:
explain plan fo [select statement]
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());
10g:
ALTER SESSION SET statistics_level=ALL;
select * from table(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST COST'));
9i:
explain plan fo [select statement]
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());
10g:
ALTER SESSION SET statistics_level=ALL;
select * from table(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST COST'));