-
Log Switch Problem
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
-
Hi,
Is that occured suddenly or normal to your database?
-
Hi,
Have u tried querying dba_waiters for any blocking session?
-
10 Megs is too low. Make them 100M
Lowering the buffer has nothing to deal wit that
The question does that happend lately is quite reasonable. If so, try to find what is generating so much of redo. But in general 10M is too low on OLTP systems
-
You should increase the size of the redo logs, but you should also add additional redo logs, so that the logs wrap around less often.
-
-
gmurughan what do you mean?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|