Home » RDBMS Server » Performance Tuning » Log Switches
Log Switches [message #213523] Thu, 11 January 2007 02:06 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear all,
i am facing log switches every minute
redo log space request 100452

I have 20Mb log_buffer and 5 Redo log file groups of 10MB each
I am facing now facing performance degradatrion ,
Although it is very vast query (Perfomane Degradation ),Nobody can answer this in one or two sentences
But my question is ,will it provide performance enhancement if i increase the size of redo log file size and reduce the size of redo log_buffer

Can anybody help me in this regard

thanx in advance
Re: Log Switches [message #213526 is a reply to message #213523] Thu, 11 January 2007 02:21 Go to previous messageGo to next message
Messages: 242
Registered: February 2006
Senior Member
I want to say You, that You have a HUGE redo log buffer. Practically there very rare cases, when are necessary redo log buffer more that 1MB. Try at first to set your redo log to the 0.5 MB and restart database.
Re: Log Switches [message #213582 is a reply to message #213523] Thu, 11 January 2007 06:05 Go to previous message
Messages: 611
Registered: July 2006
Senior Member
IMHO it's very hard to get a severe performance degradation due to log switches.
Try tuning your process/query.

In my opinion there are 2 ways to reduce the number of log switches:
1. Increase LOG size
2. Decrease the number of application DML operations and their UNDO volume.

Previous Topic: Query running slow in Forms
Next Topic: Query performing good in 9i but very very slow in 10g
Goto Forum:

Current Time: Sun Oct 23 01:41:58 CDT 2016

Total time taken to generate the page: 0.07794 seconds