Can you get to the max throughput outside Oracle - for
example, a straight read or write test. If you can,
then it would reasonable to assume that your db could
possibly get some more io throughput squeezed out of
it.
If the read or write test cannot get up to the claimed
max, then maybe its time to ask for an explanation
from the raid vendor.
hth
connor
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> tday6 - Thanks for replying. No, the RAID seems to
> perform fine. I can
> perform certain Oracle operations (usually DBA
> activities) and kick the RAID
> I/O really high (considerably below the vendor
> specs). In normal usage the
> I/O is far below this level.
> Statspack analysis shows disk waits to be our
> greatest wait. Does
> this mean that I have a superbly tuned system and
> there is nothing more to
> do? If I can get an amen to that then I can leave
> happy for the weekend.
> Part of what concerned me was that none of the
> Oracle tuning books I have
> mentions vendor specs for RAID I/O at all.
>
> Thanks for your ideas.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Friday, December 07, 2001 12:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I'm not sure that I understand the question. Is it:
>
> A. Under max load the RAID does not perform up to
> its specs?
>
> or
>
> B. Oracle does not stress the RAID enough for it to
> reach its max
> performance.
>
> If A, then have the RAID vendor fix whatever the
> problem is.
>
> If B, then good for you. You have a well designed
> system.
>
>
>
>
>
> DENNIS
>
> WILLIAMS To:
> Multiple recipients of list
> ORACLE-L
> <DWILLIAMS
> <ORACLE-L_at_fatcity.com>
>
> @LIFETOUCH.CO cc:
>
> M> Subject:
> RAID system max
> throughput
> Sent by: root
>
>
>
>
>
> 12/07/2001
>
> 11:40 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Whenever I discuss disk waits with my system
> administrator, I always get
> the
> reply that "the RAID system isn't anywhere near its
> rated throughput".
> Maybe
> I'm wrong, but I don't see any of the tuning books
> mentioning that as a
> relevant performance characteristic. However, I've
> never been able to move
> the discussion beyond this point. Can anyone
> straighten me out on this
> point
> or point me to a resource that might be applicable.
>
> Our system is Oracle 8.1.6, Compaq Tru64. We use
> hardware RAID-5 with a
> battery-backed RAM cache, and have about 3 RAID sets
> (plus some extra disks
> for redo logs, etc.), and performance is fine, but
> I'm always looking as to
> how we can improve Oracle performance. The
> application is our corporate ERP
> system.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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_at_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).
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: tday6_at_csc.com
>
> 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_at_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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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_at_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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Nokia 5510 looks weird sounds great.
Go to
http://uk.promotions.yahoo.com/nokia/ discover and win it!
The competition ends 16 th of December 2001.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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_at_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).
Received on Fri Dec 07 2001 - 16:26:14 CST
