View Single Post

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

> "Andreas Schulze" <b79xan@gmx.de> 在郵件 news:2p46heFg6tpmU1@uni-berlin.de
> 中撰寫...
> > "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
> >


>"Kenneth" <audigy@audigy.com.hk.hk> schrieb im Newsbeitrag

news:412f7438$1_3@rain.i-cable.com...
> I've read this doc. before, but have you using the CIO feature? Does it do
> as good as in the doc?
>

Just DB2 here at the current project and my hands on Oracle experiences end
with 8.1.7. Hence I cannot tell. Sorry.


Reply With Quote