Path: news.easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: ashok_jayaraman@yahoo.com (Jayaraman Ashok)
Newsgroups: comp.databases.oracle.server
Subject: Checkpoint - v$datafile_header
Date: 8 Aug 2002 05:20:17 -0700
Organization: http://groups.google.com/
Lines: 14
Message-ID: <7ca2852.0208080420.28b0817b@posting.google.com>
NNTP-Posting-Host: 203.247.159.54
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028809217 20255 127.0.0.1 (8 Aug 2002 12:20:17 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 12:20:17 GMT
Xref: easynews comp.databases.oracle.server:157256
X-Received-Date: Thu, 08 Aug 2002 05:17:23 MST (news.easynews.com)

Hi
To find out how frequent the checkpoints occur, i queried the
v$datafile_header for the checkpoint_time. It tallied with the last
log switch time. But after the next log switch had occurred , the
v$datafile_header still shows only the last value. Even after 25
minutes of the log switch, the view has not been refreshed.When is it
updated? Also what is the checkpoint_count column and what does it
signify? IS it the number of changes that has occurred on each
datafile or is it something else? The value is different for different
datafiles and is the maximum on system datafile. Please share your
views and knowledge.

Cheers,
Ashok