AWR not capturing sql_id anymore
From: Stojan Veselinovski <stojan.veselinovski_at_gmail.com>
Date: Fri, 8 Feb 2013 11:10:26 +1100
Message-ID: <CALn1tDtYjm4BjOaSc2Cj-Zo=rVjYuZmYcu2NQeGAvV-yMquSNA_at_mail.gmail.com>
Hi all,
06-FEB-13 02.00.37.141 PM
Date: Fri, 8 Feb 2013 11:10:26 +1100
Message-ID: <CALn1tDtYjm4BjOaSc2Cj-Zo=rVjYuZmYcu2NQeGAvV-yMquSNA_at_mail.gmail.com>
Hi all,
I'm having an issue with a particular sql_id I monitor. It's a pl/sql procedure which is used in pl/sql notification of AQ. Database is EE 10.2.0.5 on Solaris 5.10.
For some reason this particular sql_id is not being captured by AWR anymore and I can't see it in dba_hist_sqlstat from 06/02. Here's the relevant info.
- max snap id of last time captured SQL> select max(snap_id) from dba_hist_sqlstat where sql_id = '5c53m84fjcz5p';
MAX(SNAP_ID)
1178
- last time captured SQL> select begin_interval_time from dba_hist_snapshot where snap_id = 1178;
BEGIN_INTERVAL_TIME
06-FEB-13 02.00.37.141 PM
- it is currently being called many times and in active session history SQL> select count(*) from v$active_session_history where sql_id = '5c53m84fjcz5p';
COUNT(*)
40262
- lots of execs, why aren't these going into dba_hist_sqlstat SQL> select child_number, executions from v$sql where sql_id = '5c53m84fjcz5p';
CHILD_NUMBER EXECUTIONS
------------ ----------
0 36 1 2455529
Anyone got any ideas? Is this a bug?
Regards,
Stojan.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 08 2013 - 01:10:26 CET