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!

Reduce Archived Log Generation

Arun Natarajan-OCFeb 10 2013 — edited Feb 10 2013

Hi Friends,

Hi Friends,

we are using 11g R2 Database on windows. The Database size is 100GB.

The size of the database grows about 1(or)2 Gb per day but the Archived logs generation is around 80 GB every day.

How can I reduce the size of archived Logs generation which is highly contrast against my database growth.

Is there any best practices (or) it is based on the Application code?

The Data Mining on Archived log shows Delete,Insert and Update.

Please let me know any suggestions.

Regards,
DB

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2013

Added on Feb 10 2013

#general-database-discussions

4 comments

2,531 views