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

5   statistics_level=all;

6 v$sql_plan_statistics_all

7 10046/10053 trace跟踪

转自一个朋友的比较详细

7种方式获取执行计划

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