Wilfrid Allembrand wrote:
> Greetings,
>
> One of my system is p570, 4 procs, 16 GB RAM with Oracle 9iR2
> installed.
> AIX 5.2, ML 6
> Before to use CIO on oracle FS, I configured AIO to start at boot
> (minservers=20 ; maxservers per cpu=100).
>
> Since I discovered CIO, I configured it on 2 FS (/oradata1 and
> /oradata2) and changed the oracle parameter filesystemio_options from
> asynch to setall
>
> >From what I understand : if you configure setall on cio-fs, oracle uses
> cio (and only in this case).
>
> AIO consumes kernel processes.
> So my questions are : is AIO still needed to be configured ? Does CIO
> need AIO to be present or not ? Can I change the "STATE to be
> configured at system restart" from AVAILABLE to DEFINED (smitty chaio)
> ?
>
> Thank you in advance,
> Wilfrid

yes you want to use AIO with Oracle

good database tuning guide

http://publib-b.boulder.ibm.com/redb...5511.html?Open

IBM white paper on AIO/CIO/DIO

http://www-1.ibm.com/servers/aix/whi...b_perf_aix.pdf