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!

log switch must occur every 15 to 30 minutes: good practice or myth?

705249Apr 13 2010 — edited Sep 23 2010

I often heard that it is recommended to size redo log files in a way that Oracle performs a log switch every 15 to 30 minutes.

I would like to know if it is true or if it is a myth ?
I would like to know the best way for sizing redo log files ?
What happen exactly in the database when a log switch occurs ?

Please help me to clarify these concepts.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2010

Added on Apr 13 2010

#general-database-discussions, #log

25 comments

16,961 views