sql执行计划工具第6种awrsqrpt.sql怎么总出错
答案:1 悬赏:60
解决时间 2021-02-04 03:12
- 提问者网友：傲气稳全场
- 2021-02-03 03:51
sql执行计划工具第6种awrsqrpt.sql怎么总出错
最佳答案
- 二级知识专家网友：你好陌生人
- 2021-02-03 04:04
I) 使用Explain Plan,查询PLAN_TABLE;
EXPLAIN PLAN
SET STATEMENT_ID='QUERY1'
FOR
SELECt *
FROM a
WHERe aa=1;
SELECt operation, options, object_name, object_type, ID, parent_id
FROM plan_table
WHERe STATEMENT_ID = 'QUERY1'
ORDER BY ID;
II)SQLPLUS中的SET TRACE 即可看到Execution Plan Statistics
SET AUTOTRACE ON;
EXPLAIN PLAN
SET STATEMENT_ID='QUERY1'
FOR
SELECt *
FROM a
WHERe aa=1;
SELECt operation, options, object_name, object_type, ID, parent_id
FROM plan_table
WHERe STATEMENT_ID = 'QUERY1'
ORDER BY ID;
II)SQLPLUS中的SET TRACE 即可看到Execution Plan Statistics
SET AUTOTRACE ON;
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯