Monitoring the "Checkpoint not complete" event

Hi all,
I'm trying to figure out how to implement an automated monitoring regarding the above mentioned "event". When it happens the instance hang may become a problem and *I believe* that monitoring the single occurrence of the "Checkpoint not complete" message in the alert log is not sufficient (the time between that message
and the following thread advance is quite important as well).

So what's the logic/how exactly you monitor the "Checkpoint not complete" event?


Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l


Other related posts: