unable to get execution plan of a sql
Recently i encountered a situation in which i was trying to monitor a sql...the sql ran and the elapsed time was 71 sec but i wasnt able to catch it in V$SQL....but was able to see in v$active_session_history.I was surprised..i wanted to dig more...later that day i wanted to check the execution plan of the sql from AWR..but was unable to retrieve.
SYS:PCD00312>select * from table(dbms_xplan.display_awr('1vrytkhd58f2w', '885281777', NULL, 'ALL'));
no rows selected
but when i queried DBA_HIST_ACTIVE_SESS_HISTORY i was still able to see the plan hash value and other details: