| Log Switches [message #213523] |
Thu, 11 January 2007 02:06  |
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  |
aciolac
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 |
michael_bialik
Messages: 621
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.
HTH.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
