db file parallel write

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Wed, 3 Mar 2004 11:36:44 -0800 (PST)
Message-ID: <20040303193644.87229.qmail@web80407.mail.yahoo.com>

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 - 13:33:52 CST