| how to figure out checkpoint running slow [message #133903] |
Mon, 22 August 2005 12:42  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
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.
thanks.
|
|
|
|
| Re: how to figure out checkpoint running slow [message #134347 is a reply to message #133903] |
Wed, 24 August 2005 07:43  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
