Hi You can truss database writer, if AIO is enabled you should see something like kaio(AIONOTIFY, -2226439408) kaio(AIOWAIT, 0xFFFFFFFF7FFFDFA0) On 12/27/06, blr_dba <deepak_blr@xxxxxxxxxxx> wrote:
Dear Gurus, Am having huge amount of waits on "direct path write event". This event has 98% 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 mounted UFS 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 -- //www.freelists.org/webpage/oracle-l