AWR report not getting generated hourly
663680Dec 29 2010 — edited Dec 29 2010Hi
We have an Oracle EE 11.2.0.1, on which i see that the AWR reports are being generated randomly not every hour , would anyone know if i am missing any config
My renetention interval specified
SQL> select SNAP_INTERVAL,RETENTION from DBA_HIST_WR_CONTROL;
SNAP_INTERVAL RETENTION
--------------------------------------------------------------------------- ---------------------------------------------------------------------------
+00000 01:00:00.0 +00007 00:00:00.0
Snapshot got from the awr report
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
EXX001 EXX 30941 27 Dec 2010 01:10 1
30942 27 Dec 2010 04:22 1
30943 27 Dec 2010 05:00 1
30944 27 Dec 2010 06:00 1
30945 27 Dec 2010 07:00 1
30946 27 Dec 2010 08:01 1
30947 28 Dec 2010 01:08 1
30948 28 Dec 2010 06:25 1
30949 28 Dec 2010 07:00 1
30950 28 Dec 2010 08:00 1
30951 28 Dec 2010 09:00 1
30952 28 Dec 2010 10:00 1
30954 29 Dec 2010 08:28 1
30955 29 Dec 2010 09:00 1
30956 29 Dec 2010 10:00 1
30957 29 Dec 2010 11:00 1
30958 29 Dec 2010 12:00 1
thank you
Jonu