View Single Post

   
  #3 (permalink)  
Old 01-05-2008, 03:08 AM
Kenneth
 
Posts: n/a
Default Re: direct IO with Oracle

I've read this doc. before, but have you using the CIO feature? Does it do
as good as in the doc?

"Andreas Schulze" <b79xan@gmx.de> ¦b¶l¥ó news:2p46heFg6tpmU1@uni-berlin.de
¤¤¼¶¼g...
> "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