MythColor的专栏

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