Home » RDBMS Server » Server Administration » Restarting AWR snapshots after errors. (11.2.0.3)
Restarting AWR snapshots after errors. [message #585147] Wed, 22 May 2013 08:21
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We encountered some errors during AWR snapshots last night.
After 3 snapshots in error, AWR no more snapshot.
Reading MMON trace files and searching in MOS we found the origin of the error (time-out on "control file sequential read" event) and apply the fix (gather statistics on fixed tables).
Then we create a manual snapshot -> It's OK.

Now, the problem, after this succeeded manual snapshot no automatic one appears.
Does anyone know how to restart the automatic snapshot or where to search?

SQL> select * from DBA_HIST_WR_CONTROL;
      DBID SNAP_INTERVAL     RETENTION         TOPNSQL
---------- ----------------- ----------------- ----------
  84779912 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT

SQL> select value from v$parameter where name='job_queue_processes';
VALUE
-------------------
10

Regards
Michel

[Updated on: Wed, 22 May 2013 09:04]

Report message to a moderator

Previous Topic: DBMS_HM ERROR
Next Topic: About Oracle ReDo log groups
Goto Forum:
  


Current Time: Fri Aug 01 09:54:30 CDT 2014

Total time taken to generate the page: 0.05925 seconds