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 <[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 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
