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!

Redo generation and DML

John_75Mar 16 2012 — edited Mar 18 2012

RDBMS Version: 10.2, 11.1 , 11.2
OS : Solaris 10

Is there any way we could estimate the amount of redo generated for 1GB worth of INSERTs? I am not looking for redo or arch redo logs generated in a day.

We have some batch jobs running from 1:00 AM to 7:00 AM . Our apps team said that we'll have 6gb worth of Data inserted every hour during this period. So, I need to know how frequently I need to schedule archive log backup during this time. I don't want to be woken up at night due to DB outage because of ARCH dest full ;)

Current size of Archive log Disk group : 50 GB
Size of Redo log : 100 mb

This post has been answered by Nikolay Savvinov on Mar 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2012

Added on Mar 16 2012

#general-database-discussions

25 comments

1,323 views