Re: db file parallel write

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 19 Aug 2004 07:38:40 -0700
Message-Id: <1092926320.1219.140.camel@poirot>

Well, I'm not a NetApp expert, but I do know that writes are done to new blocks if possible.

When space is at a premium the NetApp must go looking for space that can be cleaned up and reused, and spends its time WAFLing about in the inode tables determining where it can write.

There are some folks here that are more NetApp conversant than I, and may chime in here on how to detect and correct this situation.

Jared

On Wed, 2004-03-03 at 11:36, Sai Selvaganesan wrote:
> 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 Thu Aug 19 2004 - 09:41:15 CDT