SQL Performance (MOSC)

MOSC Banner

unable to get execution plan of a sql

edited Jun 22, 2016 4:48PM in SQL Performance (MOSC) 8 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center