作者：丹丹2502857623 | 来源：互联网 | 2014-07-08 01:11
查看oracle执行计划(命令实现)看下面小练习,告诉你如何用oracle命令查看执行计划.www.2cto.com1.想要查看执法计划的SQL语句:Sql代码explainplanforselectt.*,t.rowidfromA5twheret.l...SyntaxHighl
查看oracle执行计划(命令实现)
看下面小练习,告诉你如何用oracle命令查看执行计划.
www.2cto.com
1.想要查看执法计划的SQL语句:
Sql代码
explain plan for select t.*, t.rowid from A5 t where t.l = &＃39;101214&＃39; and t.k like &＃39;%8号&＃39; order by i ;
2.查看此SQL语句的执行计划:
Sql代码
select * from table(dbms_xplan.display);
执行结果如下:
执行结果代码
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1156097717
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 12 | 1524 | 71 (3)| 00:00:01 |
| 1 | SORT ORDER BY | | 12 | 1524 | 71 (3)| 00:00:01 |
|* 2 | TABLE ACCESS FULL| A5 | 12 | 1524 | 70 (2)| 00:00:01 |
----------------------------------------------------------------------------
Note
-----
- &＃39;PLAN_TABLE&＃39; is old version
www.2cto.com
12 rows selected
&＃39;PLAN_TABLE&＃39; is old version : 这句话告诉我们,PLAN_TABLE的版本太旧,需要重新生成.
3.重新生成PLAN_TABLE表:
Sql代码
-- 删除表
drop table PLAN_TABLE;
-- 新建表
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlxplan.sql;
4.查看执行计划:
Sql代码
select * from table(dbms_xplan.display);
结果如下:
www.2cto.com
其他代码
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1156097717
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 12 | 1524 | 71 (3)| 00:00:01 |
| 1 | SORT ORDER BY | | 12 | 1524 | 71 (3)| 00:00:01 |
|* 2 | TABLE ACCESS FULL| A5 | 12 | 1524 | 70 (2)| 00:00:01 |
---------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("T"."L"=&＃39;101214&＃39; AND "T"."K" LIKE &＃39;%8号&＃39;)
14 rows selected
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有