AWR not capturing sql_id anymore

From: Stojan Veselinovski <stojan.veselinovski@xxxxxxxxx>
To: "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 8 Feb 2013 11:10:26 +1100

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.
--
//www.freelists.org/webpage/oracle-l

AWR not capturing sql_id anymore

Other related posts: