oracle-执行计划

1.SET AUTOTRANCE，不实际执行，执行计划不一定准确
2.explain plan for SQL，不实际执行，执行计划不一定准确
3.10046或SQL Trace，实际执行，借助tkprof
4.V$SQL_PLAN，数据库中实际执行的SQL
5.PL/SQL/SQL developer

--- 1 explain for +SQL
explain plan for select * from  DEPT30_TEMP  ; 

--- 2
select plan_table_output from table(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));

--- 3