From oracle-l-bounce@freelists.org Wed Mar 3 16:06:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23M6k909631 for ; Wed, 3 Mar 2004 16:06:46 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23M6io09624 for ; Wed, 3 Mar 2004 16:06:44 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34D8C395292; Wed, 3 Mar 2004 17:06:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 17:05:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from usscmail7.hds.com (usscmail7.hds.com [63.74.235.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA8B7395219 for ; Wed, 3 Mar 2004 17:05:34 -0500 (EST) Received: from mail.hds.com (usscmail9 [10.1.6.230]) by usscmail7.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i23M9Vx20900 for ; Wed, 3 Mar 2004 14:09:31 -0800 (PST) Received: from usscceb02.hds.com (usscclb02.hds.com [10.1.6.227]) by mail.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i23M97o19007 for ; Wed, 3 Mar 2004 14:09:07 -0800 (PST) Received: by usscceb02.hds.com with Internet Mail Service (5.5.2653.19) id ; Wed, 3 Mar 2004 14:09:16 -0800 Message-ID: <35CFD500D7BDCE43B9030BBA5979DC181D938F@ussccem13.hds.com> From: John Kanagaraj To: "'oracle-l@freelists.org'" Subject: RE: db file parallel write Date: Wed, 3 Mar 2004 14:11:32 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain X-archive-position: 254 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Sai, Dennis makes excellent points as usual. As well, I would have your NetApp admin (and the vendor) look at your snapshot frequency, as this may affect your performance. Creating snapshots that are closer together may help in such write intensive scenarios. John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-----Original Message----- >From: oracle-l-bounce@freelists.org >[mailto:oracle-l-bounce@freelists.org] On Behalf Of DENNIS WILLIAMS >Sent: Wednesday, March 03, 2004 12:34 PM >To: 'oracle-l@freelists.org' >Subject: RE: db file parallel write > > >Sai > I recall others on the list mentioning something similar >with Netapp. >Something inherent in the Netapp design. I would google >oracle-l netapp and >read the old threads. > The other possibility is that you may be saturating the network >connection with a lot of small requests. I would recommend >that you tap your >network engineer and have them look at what the wire is experiencing. > My experience with Netapp has been positive overally but >that you must be >careful not to overload the wire. > > > >Dennis Williams >DBA >Lifetouch, Inc. >dwilliams@lifetouch.com > >-----Original Message----- >From: oracle-l-bounce@freelists.org >[mailto:oracle-l-bounce@freelists.org]On >Behalf Of Sai >Selvaganesan >Sent: Wednesday, March 03, 2004 1:37 PM >To: oracle-l@freelists.org >Subject: db file parallel write > > >hi > >we are running oracle 9.2.0.4 on red hat and netapp as the storage. >everything has been going on alright until a week back i/os >have become very >slow. > >we can see dbwr taking a very longtime to do a db file >parallel write and >all loadings (this is a dw system) is taking longer. the i/o >on the filer >shows 90% to 95% usage and hits 100% sometimes. this filer is >shared between >three other home grown applications but none of them has put in any new >code. the slowness is showing up on all applications but this >dw system is >bound by some SLAs hence bad performance is easily noticeable. > >we have a tech ticket opened with the vendor but no response >yet. has anyone >in this list faced this kind of issues? no sql has changed and >this storage >setup has been working fine for more than 6 months now. > >thanks >sai > > > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@freelists.org >put 'unsubscribe' in the subject line. >-- >Archives are at http://www.freelists.org/archives/oracle-l/ >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------