AWR not capturing sql_id anymore

From: Stojan Veselinovski <>
Date: Fri, 8 Feb 2013 11:10:26 +1100
Message-ID: <>

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 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';



  • last time captured SQL> select begin_interval_time from dba_hist_snapshot where snap_id = 1178;


06-FEB-13 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';



  • lots of execs, why aren't these going into dba_hist_sqlstat SQL> select child_number, executions from v$sql where sql_id = '5c53m84fjcz5p';

------------ ----------

           0         36
           1    2455529

Anyone got any ideas? Is this a bug?


-- Received on Fri Feb 08 2013 - 01:10:26 CET

Original text of this message