Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 6192 invoked from network); 4 Dec 2007 14:09:33 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 4 Dec 2007 14:09:33 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 344EA7D16FC; Tue, 4 Dec 2007 15:09:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22319-09; Tue, 4 Dec 2007 15:09:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A58F7D167E; Tue, 4 Dec 2007 15:09:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 Dec 2007 14:22:37 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA2317D0BF5 for ; Tue, 4 Dec 2007 14:22:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14877-02 for ; Tue, 4 Dec 2007 14:22:36 -0500 (EST) Received: from ext-nj2ut-12.online-age.net (ext-nj2ut-12.online-age.net [64.14.54.245]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B907C7D0A21 for ; Tue, 4 Dec 2007 14:22:36 -0500 (EST) Received: from int-nj2ut-2.online-age.net (int-nj2ut-2.online-age.net [3.159.237.71]) by ext-nj2ut-12.online-age.net (8.13.6/8.13.6/20051114-SVVS-TLS-DNSBL) with ESMTP id lB4JMaoC020793 for ; Tue, 4 Dec 2007 14:22:36 -0500 Received: from cinmlef10.e2k.ad.ge.com (int-nj2ut-2.online-age.net [3.159.237.71]) by int-nj2ut-2.online-age.net (8.13.6/8.13.6/20050510-SVVS) with ESMTP id lB4JMXmS027474 for ; Tue, 4 Dec 2007 14:22:36 -0500 Received: from CINMLVEM22.e2k.ad.ge.com ([3.159.215.61]) by cinmlef10.e2k.ad.ge.com with Microsoft SMTPSVC(6.0.3790.2499); Tue, 4 Dec 2007 14:22:32 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Performance issue - Not sure if its disk or some thing - How can I narrow down this Date: Tue, 4 Dec 2007 14:22:30 -0500 Message-ID: <8C560BA35837F142989ED1AC19AB00C8076F645E@CINMLVEM22.e2k.ad.ge.com> In-Reply-To: <49d668000712041037y1b02096gbdf93a2bf1ab50f6@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Performance issue - Not sure if its disk or some thing - How can I narrow down this References: <61292a9d0712040913p169e8ecbv8d648840269b7dd9@mail.gmail.com> <49d668000712041037y1b02096gbdf93a2bf1ab50f6@mail.gmail.com> From: "Guerrero, Citlali (GE, Corporate, consultant)" To: , Cc: X-OriginalArrivalTime: 04 Dec 2007 19:22:32.0837 (UTC) FILETIME=[04D40350:01C836AB] X-archive-position: 3698 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: citlali.guerrero@ge.com Precedence: normal Reply-to: citlali.guerrero@ge.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Hi All, I'll like to unsuscribe from this list, I try it before but it didn't work, any one can tell me how can I do it? thanks in advanced -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Alexander Fatkulin Sent: Martes, 04 de Diciembre de 2007 12:38 p.m. To: bnsarma@gmail.com Cc: oracle-l@freelists.org Subject: Re: Performance issue - Not sure if its disk or some thing - How can I narrow down this trace your quires using 10046 level trace with waits and see how much time you do really spend on I/O > > Should I go behind Tuning the Queries or Storage, spreading datafiles > across multiple disks. > > Apprecaite your thoughts > > > > > > > -- > Regards & Thanks > BN -- Alex Fatkulin, The Pythian Group, http://www.pythian.com/blogs/author/alexf -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l