Home » RDBMS Server » Performance Tuning » redo log contetnion
redo log contetnion [message #65236] Thu, 24 June 2004 13:58 Go to next message
Messages: 87
Registered: August 2002
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
Re: redo log contetnion [message #65245 is a reply to message #65236] Sat, 03 July 2004 09:03 Go to previous message
Satheesh Babu.S
Messages: 35
Registered: July 2004
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
Previous Topic: Urgent tunning
Next Topic: Estimating DB Size of Prodution Database
Goto Forum:

Current Time: Wed Feb 21 19:56:20 CST 2024