Re: db file parallel write
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 07:38:40 -0700
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
