查看执行计划3种方式

--1 生成并查看plan
SELECT * FROM PLAN_TABLE;
DELETE FROM plan_table;
EXPLAIN PLAN FOR SELECT * FROM game_draw WHERE draw_id = 33;
select * FROM TABLE(dbms_xplan.display);
--2 from libary cache v$sql_plan  >=10g
SELECT * FROM TABLE(dbms_xplan.display_cursor(v$session.SQL_ID)); 
--3 from awr dba_hist_?? >=10g
SELECT * FROM TABLE(dbms_xplan.display_awr(v$session.SQL_ID));