Home » RDBMS Server » Server Administration » Redo Log (Oracle 10g RAC, Windows 2003EE)
Redo Log [message #316389] Thu, 24 April 2008 22:36 Go to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member


Our database having a problem relating to LGWR.

Monitoring (Spotlight on windows) displays "average time to sync a Redo Log Entry alarm activated when the time taken to write redo log entries during a commit exceeds a threshold".

We thinking it is relating to Redo Log buffer size and writing process.

Redo Lug buffer size is 30MB and Redo files are 200MB each.
Database is Oracle10g RAC 64 bit. And, we allocated dedicated disk to REDO LOG files at the EMC storage.

please advice me on redo sizing and this alarm how to fix?
please share with me experience.

thanks

Re: Redo Log [message #316456 is a reply to message #316389] Fri, 25 April 2008 03:15 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
How many logswitches do you have per hour?
Re: Redo Log [message #317011 is a reply to message #316389] Tue, 29 April 2008 03:08 Go to previous messageGo to next message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member

1. "Redo Lug buffer size is 30MB"

Redo log buffer or log_buffer size of 30MB is excessive. This should probably no larger than 1MB as there is no real benefit of having a larger value.
-> Default Maximum is 512 KB or 128 KB * CPU_COUNT, whichever is greater.
Or else you could be causing yourself issue when writing the buffer to your online redo e.g. log file sync issues.

2. "And, we allocated dedicated disk to REDO LOG files at the EMC storage." are you using raid 1? raid 5 is no good for online redo logs when there is reasonable system activity.

Changing these will will probably help your log file sync issues
Re: Redo Log [message #318147 is a reply to message #317011] Mon, 05 May 2008 22:37 Go to previous message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member



Thanks for reply.


1.
I have changed it to 14MB. problem is still same.

And, tried to reduce to 10MB, but doest not changed. I don't know why it is not changed.


2.
RED0_LOG files are locating in dedicated disk (RAID1).

Are there need to apply any patch or update for Oracle and Windows?
Previous Topic: Decreasing Tablespace size
Next Topic: USER_CONSTRAINTS Vs USER_INDEXS
Goto Forum:
  


Current Time: Thu Dec 08 04:25:46 CST 2016

Total time taken to generate the page: 0.05248 seconds