Re: I/O Performance/bottlenecks on EMC Symmetrix

!! Please do not post Off Topic to this List !!

Absolutely! Every loop must have an exit!

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 14, 2001 12:45 PM

> !! Please do not post Off Topic to this List !!
>
> corollary to rule 2
>
> after a certain point, just stop. It ain't worth it anymore.
>
>
> >From: Christopher Spence <cspence_at_FuelSpot.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: I/O Performance/bottlenecks on EMC Symmetrix
> >Date: Fri, 14 Sep 2001 05:45:20 -0800
> >
> >Rules of tuning databases.
> >
> >1. There is always a bottleneck.
> >2. Once you solve the bottle neck, refer to rule number 1.
> >
> >"Do not criticize someone until you walked a mile in their shoes, that way
> >when you criticize them, you are a mile a way and have their shoes."
> >Christopher R. Spence
> >Oracle DBA
> >Phone: (978) 322-5744
> >Fax: (707) 885-2275
> >Fuelspot
> >73 Princeton Street
> >North, Chelmsford 01863
> >
> >-----Original Message-----
> >Sent: Thursday, September 13, 2001 10:01 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >At one site I worked using Oracle Financials we were having serious
> >performance problems at what seemed to us random intervals. Spent months
> >looking at the database after the Unix boys had said that there was no way
> >we could have I/O problems with the throughput capabililities of EMC and
> >the
> >Symetrix set up we had.
> >Eventually turned out that 3 systems were sharing the same disks and the
> >disks had not been striped. Therefore other system were causing us
> >performance problems.
> >If you have an EMC support contract which I think you must have you, the
> >SA's get all the free GUI tools that allow them to look at channels and
> >logical/physical layout. Ask them about.
> >John
> >-----Original Message-----
> >Sent: 13 September 01 12:55
> >To: Multiple recipients of list ORACLE-L
> >
> >!! Please do not post Off Topic to this List !!
> >Hi All,
> >
> >Does anybody here on the list have experience with EMC/symmetrix storage
> >units.?
> >We have our databases on this machine and I have a feeling the the I/O
> >performance is not very good. I can not proof it since I do not have any
> >experience/data/access to that machine. We do however have a very
> >cooperative UNIX group but they also lack experience with performance on
> >this machine.
> >Who can give me pointers about I/O throughput that can be reached,
> >configuration pittfalls etc..
> >Example:
> >RS6000 8CPU's and 4Gb memory with storage on EMC/symmetrix. Job takes about
> >2 hours to complete.
> >F50 1 CPU 1Gb memory (TEST machine) local disks. same job takes 0.5 hours
> >to complete.
> >
> >Jack
> >=====================================================================
> >De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> >uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> >vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> >derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> >Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> >volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> >voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> >verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> >worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
> >Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> >vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
> >en het origineel en eventuele kopieën te verwijderen en te vernietigen.
> >Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> >voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> >algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> >=====================================================================
> >The information contained in this communication is confidential and is
> >intended solely for the use of the individual or entity to whom it is
> >addressed. You should not copy, disclose or distribute this communication
> >without the authority of Ernst & Young. Ernst & Young is neither liable for
> >the proper and complete transmission of the information contained in this
> >communication nor for any delay in its receipt. Ernst & Young does not
> >guarantee that the integrity of this communication has been maintained nor
> >that the communication is free of viruses, interceptions or interference.
> >If you are not the intended recipient of this communication please return
> >the communication to the sender and delete and destroy all copies.
> >In carrying out its engagements, Ernst & Young applies general terms and
> >conditions, which contain a clause that limits its liability. A copy of
> >these terms and conditions is available on request free of charge.
> >=====================================================================
> >
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ><http://www.orafaq.com>
> >--
> >Author:
> > INET: nlzanen1_at_EY.NL
> >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).
> >
> >
> >**********************************************************************
> >This email and any attachments may be confidential and the subject of
> >legal professional privilege. Any disclosure, use, storage or copying
> >of this email without the consent of the sender is strictly prohibited.
> >Please notify the sender immediately if you are not the intended
> >recipient and then delete the email from your inbox and do not
> >disclose the contents to another person, use, copy or store the
> >information in any medium.
> >**********************************************************************
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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: Don Granaman
  INET: granaman_at_home.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).