Monitor redo log size, read redo log
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?