Re: Checkpoint duration

Chuck <chuckh_at_softhome.net> wrote in message news:<Xns93D0B2E8EDFDDchuckhsofthomenet_at_130.133.1.4>...
> Statspack will tell you how many checkpoints you completed between two
> snapshots. Apart, from logging checkpoints to the alert log, is there a way
> to find out how long your checkpoints are taking?

If your checkpoint often lasts long (> 5 seconds), you may look at the time_waited and average_wait columns of v$system_event where event = 'checkpoint completed'. If checkpoint always finishes quickly, I can't think of any alternative.

Yong Huang Received on Fri Aug 08 2003 - 00:28:54 CDT