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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Online Redo Log groups

498633Sep 14 2006 — edited Sep 14 2006
Dear All,

How to check the health of redo log file, we have 200 MB undo tablespace in our production server is it enough for huge transactions. Can I check how much time my redo log file data have been overwritten?

Further in which situation we will add Online Redo Log Groups and which situation we will add Log Members.

My rollback segment is using System tablespace is it recommended?

What is recommendation about 1 redo log group is redo log member or 1 redo log group is multiple redo log members.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 12 2006
Added on Sep 14 2006
#general-database-discussions
6 comments
452 views