oracle 7种方式获取执行计划

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