snapshot not getting generate every hour skipping inbetween
Hi ,
In my Oracle database , the snapshot is not getting generate every hour eventhough by default the setting is for an hour and retention 7.
SQL> select snap_interval
, retention
from dba_hist_wr_control;
SNAP_INTERVAL RETENTION
------------------------------ ------------------------------
+00000 01:00:00.0 +00007 00:00:00.0
SQL> select snap_id
, snap_level
, to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin
from dba_hist_snapshot
order by 1;
SNAP_ID SNAP_LEVEL BEGIN
---------- ---------- -----------------
3362 1 01/05/12 01:00:58
3367 2 02/05/12 04:28:53
3368 1 02/05/12 14:26:11
3369 1 03/05/12 04:35:44
3370 1 03/05/12 04:46:55
Database Version : 11g (11.1.0.7.0). We have another database with same version,same application, in that database, its running fine for every hour. Settings are same.
Please help me to fix this problem. My Database processes are really slow and i have to check the Performance related data in AWR Report. So if snapshot generates every hour,it will be very help ful for me.
Thanks and Regards,
C.DEEBAN