From teci@the-testas.net Sun, 09 Sep 2001 09:13:19 -0700 From: Joe Testa Date: Sun, 09 Sep 2001 09:13:19 -0700 Subject: Re: How to organize oracle directories in Unix ? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 performance on the db. joe Steven Lembark wrote: > > -- Joe Testa > > > 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 filesystem and throw the > > datafiles wherever. > > There is no reason that RAID5 has to cause you pain if the stripe > size makes sense for your O/S (e.g., RAID stripe == disk I/O page). > > Remember also that there are three layers to it: disks, RAID and > LVM. Your RAID system probably exports each RAID group as a single > physical volume (PV). You can specify which PV's each logical volume > (LV) is assigned to -- if beer doesn't work try a cattle prod. This > gives you the ability to manage contention pretty well. > > Main problem I've seen is that EMC and friends sell 150GB drives, > which get grouped into PV's at the raid level. This leaves you > with a single "device" and no ability to plan the I/O at all (and, > unfortunately neither booze nor prod's have worked with any managlement > I've tried them on). > > Even with striped LV's you can manage the I/O by choosing the LV > stripe size sanely and perhaps striping across multiple devices. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: teci@the-testas.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).