Re: Log File Placement

You have to sacrifice something with 6 or less disk spindles. Our drives on one server are mirrored, so I placed all redologs on the same drive, taking the chance that I might delete one by mistake one day. I also placed rollback segments on that same drive since we have 3 Gb read/write disk caching and since rollback segs aren't much good without the redo. This allowed me to take full advantage of the remaining disks for some excellent performance.

Every system is different. So you have a very large number of options to weigh.

"C Thompsen" <cmt729NOSPAM_at_nethere.com> wrote in message news:sa713fp29gt98_at_corp.supernews.com...
> Hello,
> I realize for optimal performance the redo logs should reside on
> dedicated devices with no other activity. But I can't see using 4-6 disks
(3
> groups of 2 members) for a 100Meg file on each. Do shops do this? Or where
> else is a good place where the logs can go?
>
> TIA
> Charles
>
>
Received on Fri Feb 11 2000 - 01:26:52 CST