| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Checkpoints
Frequent log switches in peak times I think are normal. More data is
changing then....you would expect to see more frequency every minute or so
is not really that bad on a busy system...if you see a trend of these
becoming more frequent over longer periods of time I would be concerned and
plan to make a change...
But you have some room to change the checkpoint_interval....make it bit bigger up to 16mb then maybe 20....
I don't think you should completly fill up a log...doesn't seem right...
-----Original Message-----
Sent: Thursday, February 27, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L
The following parameters are set in the init.ora:-
NAME VALUE ------------------------------ --------------- log_checkpoint_interval 25600 log_checkpoint_timeout 0 log_checkpoints_to_alert TRUE
This means that a checkpoint will happen every 12Mb of redo being filled, os block size is 512. The size of the redo logs are 50Mb, as a solution, I recommend setting the log_checkpoint_interval to at least 50Mb to reduce the occurrences of these checkpoints.
What am noticing in the alert log is that a checkpoint is happening every minute at peak times, this is clearly putting considerable overhead on the lgwr.
Oracle 8.0.6.3.0 on Solaris 5.8
Anyone got any thoughts on the above or experienced checkpoints going mad on 8.0.6.
TIA
<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html> With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: Brad.Odland_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 27 2003 - 08:03:53 CST
 |
 |