Common SQL for Oracle---(3) Check execution Plan

---Check execution Plan----

[Email protected]

Select Plan_table_output from table (Dbms_xplan.display_awr (' &sql_id ', Null,null, ' Advanced +peeked_binds '));

---all [email protected]

SELECT A.instance_number,

A.SNAP_ID,

A.SQL_ID,

A.plan_hash_value,

To_char (B.begin_interval_time, ' yyyy/mm/dd hh24:mi:ss ')

From Dba_hist_sqlstat A, Dba_hist_snapshot B

WHERE sql_id = ' 3ug1bja99mtkv '

and a.snap_id = b.snap_id

---all Sql_plan [email protected]

SELECT a.instance_number inst,a.optimizer_mode opt_mode,a.optimizer_cost opt_cost,a.module,a.sql_id,

A.plan_hash_value,to_char ((b.begin_interval_time), ' Yyyy/mm/dd HH24:MI:SS ') begin_time

From Dba_hist_sqlstat A, Dba_hist_snapshot B

WHERE sql_id=lower (' D8RJBDATC87PF ')

and a.snap_id=b.snap_id

and A.instance_number=b.instance_number

ORDER by B.begin_interval_time DESC

This article from "on the Road" blog, declined reprint!

Common SQL for Oracle---(3) Check execution Plan