Re: Asynchronous I/O and AIX and jfs = perf ?

From: Jose Pina Coelho <bofh_at_mail.teleweb.pt>
Date: Fri, 10 Dec 1999 01:08:57 +0000
Message-ID: <385052A9.8C9B562F@mail.teleweb.pt>

Emmanuel Cortes wrote:
> To increase performance of oracle database 7.3.x.x, is it better to use
> Asynchronous I/O on AIX 4.3.x whith jfs file systems or not ?
Raw LV's.

> I read in a redbook (Database Performance on AIX in DB2 UDB ans Oracle
> Environnements "SG24-551-00") it's a good thing.
>
> But oracle tell if you don't use raw device is not good idea.
JFS will add *two* redirections to each DB access.

> Where is the truth ?

Go the LVM way (unless it's a toy database).

--
Doing AIX support was the most monty-pythonesque activity available at the time. Received on Thu Dec 09 1999 - 19:08:57 CST