direct path write wait

From: "blr_dba" <deepak_blr@xxxxxxxxxxx>
To: "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 27 Dec 2006 20:46:53 +0530

Dear Gurus,

Am having huge amount of waits on "direct path write event". This event has98% of the total wait time. Now we want to tune it.


We are using Solaris 9 and Oracle 9.2.0.7.

After examining the system we found that logging is enabled on the mountedUFS file systems.


Need your expert advice on the following...

How to know whether the UFS is enabled for asynchronous IO or direct IO?
Which one is better for DWH environments? Pros and cons of each.
Is filesystem cache is involved in both of the above methods?


Please suggest the best solution for my environment.

Looking forward to your ever valuable feedback.

Deepak

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: direct path write wait
From: LS Cheng

Re: direct path write wait
From: Paul Drake

Day light saving time change-ReOpening
From: GovindanK

References:
- RE: AIX pinned memory
  - From: Adrian

direct path write wait

Other related posts: