Skip to Main Content

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!

Monitor redo log size, read redo log

mohitanchliaMar 29 2009 — edited Mar 30 2009
Oracle 10g:

Is there a way to monitor how big the redo log files are? We are seeing performance impact even when log switching occurs (with incremental checkpoints). So I was wondering if:

1. There is any way to monitor how big in size the redo log is before the switch occurs?
2. Also, how to see why we have performance impact? Should I be looking inside the redo logs? Our applicaiton is complicated so difficult to tell just by looking at the app. I thought if there is any way to look inside the redo log. But then I don't know what to look for?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2009
Added on Mar 29 2009
5 comments
1,354 views