| Restarting AWR snapshots after errors. [message #585147] |
Wed, 22 May 2013 08:21 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
