AWR not capturing sql_id anymore

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

• 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