Home » Server Options » RAC & Failsafe » Performance problem (Oracle on Itanium 11.31 , 2 node RAC)
Performance problem [message #466525] Tue, 20 July 2010 00:55 Go to next message
Messages: 96
Registered: October 2006
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.

Re: Performance problem [message #466553 is a reply to message #466525] Tue, 20 July 2010 02:11 Go to previous message
John Watson
Messages: 8807
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: Sat Apr 01 22:36:24 CDT 2023