RE: I/O Performance/bottlenecks on EMC Symmetrix
!! Please do not post Off Topic to this List !! We use EMC Symmetrics. When I got here, the folks who set things up initially where under the impression that you will never have to worry about placement/io with a Symm. Wrong! I underwent a painstaking process of relaying out the disks according to conventions DBA normally use taking into consideration index/data/volume of read/write to physical disks. Since you are presented with logical volumes, we use sym commands on each of our hosts connected to the symm to give us a graphical layout of all the logical volumes on the physical disks. EMC has a tool to do this called Resource View. EMC also has a tool called workload analyzer to analyze activity on each fa / disk, etc. And there is also a utility called Symm Optimizer to detect hot spots and optionally, replace that data to a different physical disk. You should find out if you have any of these tools available to you. HTH Michele Armstrong -Original Message- Sent: Thursday, September 13, 2001 7:55 AM 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 -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstrong, Michele INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: ORA-00600 on Production DB - Need advice
I've experienced strange problems as your describing when the Oracle install directory is 100% full. Have you checked filesystems by doing df -k? Michele -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:12 PM To: Multiple recipients of list ORACLE-L Got a phone number? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Ruth Gramolini" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ate.vt.us> cc: Sent by: Subject: Re: ORA-00600 on Production DB - Need advice [EMAIL PROTECTED] 08/06/2001 02:23 PM Please respond to ORACLE-L Try calling on your tar. That is what they have told me to do. Just waiting doesn't help! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 06, 2001 1:58 PM > > Mondays, gotta love em, they make Fridays worth the wait. I've got a > production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an > ora-600 when users try to log in. I've created a TAR (3 hours ago), but > haven't gotten any response. Here's the error: > > ERROR: > ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], > [], > [], [], [], [ > > Metalink has a couple of messages stating that this is an OS problem > related to the ulimit size, availability of virtual memory, and the ability > to create a pga. Suggested remedy is to increase the ulimit. My SA has > dismissed this as a cause. I've knocked all the users off, but still can't > log in. When I run ulimit I get the following: > qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit > 4194303 > > Any suggestions? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstrong, Michele 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).