Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High redo log space wait time

626923Jul 14 2008 — edited Jul 15 2008
Hello,

Our DB is having very high redo log space wait time :

redo log space requests 867527
redo log space wait time 67752674

LOG_BUFFER is 14 MB and having 6 redo logs groups and the size of redo log file is 500MB for each log file.

Also, the amount of redo generated per hour :

START_DATE START NUM_LOGS MBYTES DBNAME
---------- ----- ---------- ---------- ---------
2008-07-03 10:00 2 1000 TKL
2008-07-03 11:00 4 2000 TKL
2008-07-03 12:00 3 1500 TKL

Does increasing the size of LOG_BUFFER will help to reduce the redo log space wait ?

Thanks in advance ,

Regards,
Aman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Jul 14 2008
#general-database-discussions
13 comments
2,230 views