Re: Checkpoint duration - oracle 10g

From: Yong Huang <>
Date: Mon, 20 Apr 2009 13:54:25 -0700 (PDT)
Message-ID: <>

> I need to find out how long it takes for the database to flush the dirty
> buffers to the disk, is there a way I can find the total number of
> buffers that are written to the disk during the checkpoint operation,
> and how long does it take for the database to write it to the disk
> (checkpoint duration) ?

There're a couple of statistics about checkpoint buffers written so you can check v$sysstat to get that number. I don't think there's a way to find how long a checkpoint takes unless you watch your clock while you do checkpoint. But there're many types of checkpoint. For log switch checkpoint, you may get two timestamps in alert.log if you alter system set log_checkpoints_to_alert = true and watch the lines "Beginning log switch checkpoint up to RBA" and "Completed checkpoint up to RBA". Even that is not guaranteed; you may still get only one timestamp so you don't know the duration.

Yong Huang       

Received on Mon Apr 20 2009 - 15:54:25 CDT

Original text of this message