Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!nntp-relay.ihug.net!ihug.co.nz!nntp.cs.ubc.ca!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: yong321@yahoo.com (Yong Huang) Newsgroups: comp.databases.oracle.server Subject: Re: Checkpoint duration Date: 7 Aug 2003 22:28:54 -0700 Organization: http://groups.google.com/ Lines: 11 Message-ID: References: NNTP-Posting-Host: 64.63.207.11 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060320534 13151 127.0.0.1 (8 Aug 2003 05:28:54 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2003 05:28:54 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240068 Chuck wrote in message news:... > 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