Home » RDBMS Server » Server Administration » Restarting AWR snapshots after errors. (
Restarting AWR snapshots after errors. [message #585147] Wed, 22 May 2013 08:21
Michel Cadot
Messages: 62235
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;
---------- ----------------- ----------------- ----------
  84779912 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT

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


[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: Tue Dec 01 09:33:52 CST 2015

Total time taken to generate the page: 0.10710 seconds