View Single Post

   
  #2 (permalink)  
Old 01-05-2008, 03:07 AM
Andreas Schulze
 
Posts: n/a
Default Re: direct IO with Oracle

"Kenneth" <audigy@audigy.com.hk.hk> schrieb im Newsbeitrag
news:412b1ec5$1_2@rain.i-cable.com...
> I have a 500GB Oracle 9i run on AIX5.2, the memory utilization is about
> 100%. After I enable the dio option for the oracle filesystem, the memory
> utilization drops to 40% only and the disk throughput increase from

1MB/sec
> to 24MB/sec. Is there any tuning in AIX or Oracle to improve the memory
> utilization and reduce the disk activities?
>


Hallo Kenneth,

maybe this IBM whitepaper can help:
http://www-1.ibm.com/servers/aix/whi...b_perf_aix.pdf

Regards,
Andreas


Reply With Quote