RE: Checkpoints

[Deshpande, Kirti]

Zabair,

 Increasing the l_c_i would help.

 

 I see you have l_c_t set to 0, so why not set l_c_i to 0 as well?  So that the checkpoint will only occur at log switches.

 

- Kirti

-----Original Message-----
From: Zabair Ahmed [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Checkpoints

 

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

 

 

---

With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs