Explain Plan - show using dbms_xplan |
-- show latest plan for sql_id set lines 200 SELECT * FROM table ( DBMS_XPLAN.DISPLAY_CURSOR('2nkctmfyd5bzk')); select * from table(dbms_xplan.display_cursor('&m_sql_id_1',null)); -- show plan from awr history for sql_id set lines 200 SELECT * FROM table(DBMS_XPLAN.DISPLAY_AWR('2nkctmfyd5bzk')); select sql_id, id, plan_hash_value, time,timestamp from dba_hist_sql_plan where sql_id='2nkctmfyd5bzk'; |