Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Checkpoint - v$datafile_header
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
Received on Thu Aug 08 2002 - 07:20:17 CDT