how to find out checkpoint occurrence?
Is there a way to find out the checkpoint occurrence other than the LOG_CHECKPOINTS_TO_ALERT = TRUE?
I have set LOG_CHECKPOINTS_TO_ALERT = TRUE and have set LOG_CHECKPOINT_INTERVAL to a nonzero value or set LOG_CHECKPOINT_TIMEOUT to a nonzero value. Now i want to find out that the checkpoint has occurred at the correct time or after the correct interval, is there any sql script or something which could tell me this.... other then goin to my alert file and checkin it out?
Hope Iím making sense