>This mainly seems to depend on the insert/update/delete volume of your
>database.
>I usually start with 4 files of 5M each (and mirrored by Oracle, so each
>group 2 members, if at all possible [needs to be on a different disk,
>otherwise it will only delay]) and that very often seems to be sufficient.
I read somewhere (although I can't remember where) that in a OLTP
environment, it is suggested that the redo logs be of sufficient size so
that they fill up and switch every 30 minutes (on average).
Received on Tue Jun 15 1999 - 21:35:35 CDT
