Re: multiplexing online redo logs

In article <3defeeb5_1_at_mk-nntp-1.news.uk.worldonline.com>, "Paul says...
>

snip

>I like to switch logs about every twenty minutes or so. What does the group
>think? (Obviously during heavy batch processing this will become much more
>frequent).
>
>Comments and/or advice welcomed.
>
>Regards,
>Paul
>

It depends.

Sorry I couldn't resist! I've seen sites go the whole gamut from log switching every couple of minutes to not wanting to at all. It really does depend on a number of things:

1. Preferred duration of recovery.
2. Volume of data changes
3. Disk space availability (particularly if archiving is turned on)

Multiple other issues as well. FWIW, YMMV and other strange newsgroupo acronyms. :)

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Dec 05 2002 - 23:11:08 CST