Home » Server Options » RAC & Failsafe » Performance problem (Oracle 10.2.0.3 on Itanium 11.31 , 2 node RAC)
Performance problem [message #466525] Tue, 20 July 2010 00:55 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Dear all,

We are having 2-node RAC & we are getting checkpoint not complete errors in alert log of both instances.
We have increased redo log groups from 8 to 16, each having 1 GB size, even though problem not solved.
fast_start_mttr_target is set to 3600.
Our batch timings have increased by 2 hrs .
Kindly help.

Thanks
Re: Performance problem [message #466553 is a reply to message #466525] Tue, 20 July 2010 02:11 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Those checkpoint incomplete messages are to do with the frequency of log switches, so I would create new groups, of size (a guess) 4G and drop the old ones. Adding more groups wouldn't help.
[edit: forgot to spell-check]

[Updated on: Tue, 20 July 2010 02:12]

Report message to a moderator

Previous Topic: Oracle RAC 10g and NAS Failover
Next Topic: Can any one help me "What is Cache Fusion"
Goto Forum:
  


Current Time: Thu Mar 28 10:23:00 CDT 2024