| redo log contetnion [message #65236] |
Thu, 24 June 2004 13:58  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
then i had a redo log contention i increased the log _buffer parameter 5 % but it still there .how to detect the large volume of transaction in a db.how to tunne this redo log contention is it the effect of aud$ its now have 1.3 gb.Any way to detect the peak time for a db in a day
without statspack how to detect the peak time
with regards
ramya
|
|
|
|
| Re: redo log contetnion [message #65245 is a reply to message #65236] |
Sat, 03 July 2004 09:03  |
Satheesh Babu.S
Messages: 35
Registered: July 2004
|
Member |
|
|
Hi,
How are you deducing it is a redo log contention. Is it redo allocation latch or redo copy latch. What is the size of log_buffer. 3-5mb of log buffer will be sufficient. there is no need to increase beyond this.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
