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';