RE: How to organize oracle directories in Unix ?

2001-09-10 Thread Kimberly Smith
As long as your mount points are not sharing disks from the same volume group you are correct. However, its expensive to write to RAID 5 which is why you will usually see raid 0+1 instead. -Original Message- Sent: Sunday, September 09, 2001 7:55 AM To: Multiple recipients of list ORACLE

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Steven Lembark
-- Don Granaman <[EMAIL PROTECTED]> > It isn't mount points that matter for I/O contention, it is spindles and > channels - the physical disk layout. If this is one set of disks used in > one large RAID-5 setup, then creating multiple mount points for logical > volumes created on top of it wil

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Joe Testa
Steven, i'm with you on the "nothing works concept", since i'm a consultant, i end end up throwing my hands in the air(after tuning all that i can from the db side, sql, etc) and leaving it up to the "disk nazis". They do as they please with no input and and can sometimes be the killer of perfor

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Steven Lembark
-- Joe Testa <[EMAIL PROTECTED]> > It all depends on the underlying striping of the physical disks. I'm > unfortunately constrained by raid 5 also, so my hands are tied when it > comes to disk contention fixes, so i leave it to the unix SA to deal > with it, i just end up with one huge logical

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Don Granaman
It isn't mount points that matter for I/O contention, it is spindles and channels - the physical disk layout. If this is one set of disks used in one large RAID-5 setup, then creating multiple mount points for logical volumes created on top of it will do nothing to reduce I/O contention. To bala

RE: How to organize oracle directories in Unix ?

2001-09-09 Thread Steven Lembark
-- "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> > Correct me if I am wrong. I thought though I use Raid 5 but with different > mount points, I will not have contention problems > For example > One mount point for data files > Another mount point for index files. Makes sense. Also hel

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Joe Testa
have contention problems > For example > One mount point for data files > Another mount point for index files. > > Please advise. Thanks. > > Regds, > New Bee > -Original Message- > From: Joe Testa > To: Multiple recipients of list ORACLE-L > Sent: 09/09/

RE: How to organize oracle directories in Unix ?

2001-09-09 Thread CHAN Chor Ling Catherine (CSC)
Hi Joe, What's your configuration ? Raid 1 ? How do U organize the oracle directories ? Correct me if I am wrong. I thought though I use Raid 5 but with different mount points, I will not have contention problems For example One mount point for data files Another mount point for index files.

RE: How to organize oracle directories in Unix ?

2001-09-09 Thread Walthour, Jon (GEAE, Compaq)
CHAN: If I'm wrong, please correct me, but if you're talking about where to put things for performance reasons and you're using a RAID 5 configuration, then it doesn't make any difference. With a RAID 5 configuration, as I remember, is striped with parity and all the disks are seen as one big vol

Re: How to organize oracle directories in Unix ?

2001-09-09 Thread Joe Testa
if u dont know the underlying striping and someone else built the filesystes, then the point is moot, you might as well have one logical disk, since you cant reallt guarantee where something is going to end up anyways. with all of the raid5 stuff(that evryone likes so much anymore), we as DBAs do