Zabair,
Increasing the l_c_i would help.
I see you have l_c_t set to 0,
sowhy 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
Zabair,
You are indeed working from facts, but your
conclusion that a checkpoint every minute is "clearly putting considerable load
on LGWR" is a deductive leap which is probably unwarranted.
I do not have access to an Oracle8 v8.0.6 RDBMS or
documentation, but I recall that the
I recall a bug introduced (?) in 8.0.5. If you set log_checkpoints_to_alert,
the process consumed a large amount of cpu. I remember changing it to false
after our test group found performance problems.
How often are you performing log switches during peak usage?
Is the CKPT process running?
Frequent log switches in peak times I think are normal.
More data is changing thenyou 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
Hi Daniel
Log switches are happening every 20-25mins during peak times and yes the ckpt process is started automatically.
ZabairWith Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
