Home » RDBMS Server » Performance Tuning » how to figure out checkpoint running slow
how to figure out checkpoint running slow [message #133903] Mon, 22 August 2005 12:42 Go to next message
Messages: 97
Registered: June 2005
Dear All,

Is there a way to figure out that your dBWR is taking too long to flush dirty buffers to the datafiles. I read some where not sure that checkpointing occurs in every 3 seconds or earlier if there is a switch in logfile.How to figure out when the checkpoint occured reference to data files. I believe datafile header only keeps the most current checkpoint number. And finally, if the buffer cache size (db_cache_size in 9i) is too high, is there a chance that checkpointing will be running slow even for the same number of dml transactions as compared to a smaller size buf.cache.

Re: how to figure out checkpoint running slow [message #134347 is a reply to message #133903] Wed, 24 August 2005 07:43 Go to previous message
Messages: 74
Registered: March 2005
The LOG_CHECKPOINTS_TO_ALERT init.ora parameter, when set to a value of TRUE,
allows you to log checkpoint start and stop times in the alert log. This is
very helpful in determining if checkpoints are occurring at the optimal
frequency and gives a chronological view of checkpoints and other database
activities occurring in the background.
Previous Topic: Partitioning of tables need sugession
Next Topic: Query Performance
Goto Forum:

Current Time: Tue Dec 06 20:41:13 CST 2022