db file parallel write
- From: Sai Selvaganesan <ssaisundar@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Mar 2004 11:36:44 -0800 (PST)
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
Other related posts:
