oracle 七种获取执行计划方式

1 explain plan for select .....

2 set autotrace traceonly explain

3 select * from table(dbms_xplan.display_cursor('sql_id'));

select * from table(dbms_xplan.display_awr('sql_id'));

--- (dbms_xplan.display_cursor/dbms_xplan.display_awr)

4 awrsqrpt.sql

SQL> @?/rdbms/admin/awrsqrpt.sql

5 statistics_level=all;

6 v$sql_plan_statistics_all

7 10046/10053 trace跟踪

转自一个朋友的比较详细

7种方式获取执行计划

https://blog.itpub.net/31442014/viewspace-2678260/

ITPub博客

oracle 7种方式获取执行计划