Monitoring the "Checkpoint not complete" event
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 26 Oct 2009 12:29:23 +0100
Message-ID: <4AE58813.5050905_at_gmail.com>
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).
Date: Mon, 26 Oct 2009 12:29:23 +0100
Message-ID: <4AE58813.5050905_at_gmail.com>
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-lReceived on Mon Oct 26 2009 - 06:29:23 CDT