确认数据库中已经存在表PLAN_TABLE,否则需要执行utlxplan.sql
然后用以下命令查询最近一个执行计划
Plan hash value: 4118430342
-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 26 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| BOM | 1 | 26 | 3 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | BOM_PK_ID | 1 | | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("ID"=100102111)
读取执行计划的顺序通常是从内到外,从下到上。
点击(此处)折叠或打开
- explain plan
- set statement_id = 'BOM1' for
- select id
- from bom
- where id = 100101111;
点击(此处)折叠或打开
- Select *
- from table (dbms_xplan.display);
Plan hash value: 4118430342
-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 26 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| BOM | 1 | 26 | 3 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | BOM_PK_ID | 1 | | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("ID"=100102111)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22621861/viewspace-1280397/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22621861/viewspace-1280397/