RE: db file parallel write

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 3 Mar 2004 14:34:06 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B000EA@EXCHMN3>

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_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sai Selvaganesan
Sent: Wednesday, March 03, 2004 1:37 PM
To: oracle-l_at_freelists.org
Subject: db file parallel write

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_at_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


-----------------------------------------------------------------

Received on Wed Mar 03 2004 - 14:33:08 CST