SQL>EXPLAIN PLAN FOR <sql statement>;

SQL>SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY(‘PLAN_TABLE’));

或者:

SQL>  select * from table(dbms_xplan.display);

[wp_ad_camp_1]

参考:http://blog.csdn.net/tianlesoftware/article/details/5827245