Re: AIO and CIO with Oracle

aixdude_at_yahoo.com
Date: 07/26/05 

Date: 26 Jul 2005 07:10:25 -0700

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/redbooks.nsf/RedbookAbstracts/sg245511.html?Open

IBM white paper on AIO/CIO/DIO

http://www-1.ibm.com/servers/aix/whitepapers/db_perf_aix.pdf

Relevant Pages

  • AIO and CIO with Oracle
    ... Before to use CIO on oracle FS, I configured AIO to start at boot ... Since I discovered CIO, I configured it on 2 FS (/oradata1 and ... AIO consumes kernel processes. ...
    (comp.unix.aix)
  • Re: Oracle 8.1 on AIX 5.3
    ... On the question of whether to wait for the patch: ... I believe increasing those numbers are for bypassing the Oracle bug, ... There is a notorious bug in Oracle 8 - 9 that requires that the AIO request ... if you have 4 CPUs with 300 AIOs per CPU ...
    (AIX-L)
  • Re: Oracle 8.1 on AIX 5.3
    ... check errpt output and confirm no endemic HW/SW-based failures are apparent ... Oracle 8.1 on AIX 5.3 ... There is a notorious bug in Oracle 8 - 9 that requires that the AIO request ...
    (AIX-L)
  • Re: Oracle 8.1 on AIX 5.3
    ... and then up your AIO "maxreqs" value. ... Oracle 8.1 on AIX 5.3 ... Oracle 8.1 on AIX 5.3 ...
    (AIX-L)
  • Re: Oracle 8.1 on AIX 5.3
    ... And increasing the maxserver and max requests values will have a positive ... Is it safe to change the maxservers and minservers values with aioo command ... We might apply the oracle patch rather than increasing any of those numbers. ... There is a notorious bug in Oracle 8 - 9 that requires that the AIO request ...
    (AIX-L)