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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
>Sent: Wednesday, March 03, 2004 12:34 PM
>To: 'oracle-l_at_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_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
>
>
>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_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
>-----------------------------------------------------------------
>
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 - 16:06:47 CST