例说一个ORACLE执行计划的查看

此例是不借助第三方工具，进行SQL执行计划的查看:

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as irsadmin SQL> explain plan for select * from loan_contract; Explained SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan hash value: 1730730778 -------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time -------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 283 | 2 (0)| 00:00:0 | 1 | TABLE ACCESS FULL| LOAN_CONTRACT | 1 | 283 | 2 (0)| 00:00:0 -------------------------------------------------------------------------------- 8 rows selected SQL>

总结：
1、SQL> explain plan for select ;        --先进行解释
2、SQL> select * from table(dbms_xplan.display);　   --再查看解释的结果
3、还有一种方法，在pl/sql里F5。