Issue in pulling the execution plan from awrsqrpt report.
906790Sep 12 2012 — edited Sep 12 2012Hi All,
In my production database , recently we faced some performance issue in daily job and i like to pull the old execution plan of that particular job from awrsqrpt.sql report but i got below error.
Interesting information is i can able to generate the addm reports & awr reports between the same SNAP id's Why not AWRSQRPT report ???.
Version : Oracle 11gR2
Error :
+++++++++
Specify the SQL Id
~~~~~~~~~~~~~~~~~~
Enter value for sql_id: b9shw6uakgbdt
SQL ID specified: b9shw6uakgbdt
declare
*
ERROR at line 1:
ORA-20025: SQL ID b9shw6uakgbdt does not exist for this database/instance
ORA-06512: at line 22
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Old history of SQL id :
++++++++++++++++++++
SQL> select distinct SNAP_ID,SESSION_ID,SESSION_SERIAL#,USER_ID, SQL_EXEC_START from dba_hist_active_sess_history where sql_id='b9shw6uakgbdt' order by SQL_EXEC_START;
SNAP_ID SESSION_ID SESSION_SERIAL# USER_ID SQL_EXEC_
---------- ---------- --------------- ---------- ---------
13095 1026 23869 86 29-AUG-12
13096 1026 23869 86 29-AUG-12
13118 582 14603 95 30-AUG-12
13119 582 14603 95 30-AUG-12
13139 708 51763 95 30-AUG-12
13140 708 51763 95 30-AUG-12
13142 900 2897 86 31-AUG-12
13143 900 2897 86 31-AUG-12
13215 1285 62559 86 03-SEP-12
13216 1285 62559 86 03-SEP-12
13238 1283 9057 86 04-SEP-12
13239 1283 9057 86 04-SEP-12
Thanks