Re: AIO enabled for aix OR for Oracle???

From: Sigrid Ehrenreich <Sigrid.Ehrenreich_at_carus-it.com>
Date: Tue, 18 Feb 2003 13:42:19 +0100
Message-ID: <3E522A2B.60004@carus-it.com>

You have to enable AIO on AIX for Oracle. The recommendation is: min servers= number of disks, max servers= 10 times min servers. But I haven't seen any performance impact resulting from the configured number of AIO servers, but I am running only a small database < 10Gb.

The memory usage of the dbw process: If you are referring to the SIZE column of the 'ps aux' output: It shows all the memory, including shared memory. So all dbw processes will show the same SIZE, but most of it will be shared memory.

Yours Sigrid

Péter Alpári schrieb:
> Hi,
>
> We have Oracle 8.1.7 on AIX 4.3.3. Which setup guarantees better
> performance: AIO enabled for aix OR for Oracle??? Is it possible that
> each dbwriter slave process has large memory usage?
>
> Thanks
Received on Tue Feb 18 2003 - 06:42:19 CST