Re: Log File Placement

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Fri, 11 Feb 2000 09:18:41 -0500
Message-ID: <8815ns$pk8$1@bob.news.rcn.net>

Since redo logs are only written sequentially by background LGWR process the best place for them is raw slices (partitions) on dedicated disks. All redo log files could be allocated on same disk but different redo log members should reside on different drives (Oracle redo log mirroring) so minimal total of disks is 2.

Eugene.

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 - 08:18:41 CST