Hi,
on 11g R2 ,
I saw today that there is no snapshot when running AWR report.
How can I know if it has been disabled and when ? It seems to me that a script should have been run for that. Do you know that ?
Here are our parameters :
SQL> select * from DBA_HIST_WR_CONTROL;
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- ------------------------- ------------------------- ----------
xxxx +00000 01:00:00.0 ; +00008 00:00:00.0 ; DEFAULT
SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS
NAME TYPE VALUE
------------------------------------ ----------- -----------------
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> show parameter statistics
NAME TYPE VALUE
------------------------------------ ----------- ---------------
optimizer_use_pending_statistics boolean FALSE
statistics_level string TYPICAL
timed_os_statistics integer 0
timed_statistics boolean TRUE
Thank you.