| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: I/O Performance/bottlenecks on EMC Symmetrix
!! 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.
>**********************************************************************
-- 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).Received on Fri Sep 14 2001 - 11:40:15 CDT
 |
 |