Newsgroups: comp.databases.oracle From: lparsons@world.std.com (Lee E Parsons) Subject: Re: Naive view of Oracle on RAID Subsystem? Message-ID: Organization: The World Public Access UNIX, Brookline, MA References: <3dpv5m$15l@jeeves.niehs.nih.gov> <3drubg$bs3@budapest.ozonline.com.au> <3dt7ub$mup@moon.earthlink.net> Date: Thu, 29 Dec 1994 21:28:36 GMT Lines: 19 >Would it still be prudent to pay a LOT of attention to table contention, >or does this problem get reduced due to the RAID5 data striping >enough to where it's not much of a problem? The boss must be reading this thread because he came in today and asked the same question. Our experience has been that moving the online and offline redo logs off the raid disk has a measureable impact (7-5% in our tests), but that worrying about anything else was pointless. In the right situation I'm sure you might find that it would be a worthy exercise, but I'm not going to worry about it hear untill we start to have serious I/O problems and I'm out of ideas. -- Regards, Lee E. Parsons Systems Oracle DBA lparsons@world.std.com