有关Oracle的执行计划说明,参考我的Blog:
https://www.cndba.cn/Dave/article/1541
一.查看当前session的SID
https://www.cndba.cn/Dave/article/1541
SYS@anqing1(rac1)> SELECT USERENV('SID') FROM DUAL;
USERENV('SID')
137
SYS@anqing1(rac1)> SELECT SID FROM V$MYSTAT WHERE ROWNUM =1;
SID
----------
137
https://www.cndba.cn/Dave/article/1541
二.查看缓存中的Explain Plan
https://www.cndba.cn/Dave/article/1541
1)根据SID,从v$sql中找到相应SQL的HASH_VALUE和ADDRESS
/* Formatted on 2011/6/20 17:38:20 (QP5 v5.163.1008.3004) */
SELECTa.sql_text,a.address,a.hash_value
FROMv$sqla,v$session b
WHEREa.hash_value=b.sql_hash_valueANDb.sid=&sid;
2)根据hash_value和address的值,从v$sql_plan中找到真实的执行计划
https://www.cndba.cn/Dave/article/1541
/* Formatted on 2011/6/20 17:39:22 (QP5 v5.163.1008.3004) */
SETLINE200;https://www.cndba.cn/Dave/article/1541
COL oper FORMAT a100;
SELECTLPAD(oper,LENGTH(oper)+LEVEL*2,' ')oper,cost
FROM(SELECTobject_name ||':'|| operation ||' '|| optionsASoper,
cost,
id,
parent_id
FROMv$sql_plan
WHEREhash_value='&hash_value'ANDaddress='&address')
STARTWITHid=0
CONNECTBYPRIORid=parent_id;
如:
https://www.cndba.cn/Dave/article/1541
https://www.cndba.cn/Dave/article/1541
整理自网络
-------------------------------------------------------------------------------------------------------
Blog:http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1群:62697716(满);DBA2群:62697977(满)DBA3群:62697850(满)
DBA超级群:63306533(满);DBA4群:83829929DBA5群:142216823
DBA6群:158654907聊天 群:40132017聊天2群:69087192https://www.cndba.cn/Dave/article/1541
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
版权声明:本文为博主原创文章,未经博主允许不得转载。