Re: RAW vs JFS with Oracle 8.0.5 and AIX

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 16 Mar 1999 17:16:50 -0000
Message-ID: <921604743.18518.1.nnrp-07.9e984b29@news.demon.co.uk>

Can't tell you about AIX specifically, but on HP-UX 10.20 I have found JFS performance to be pretty close to raw performance if the direct I/O option is installed.

The only special handling you might want to consider is if using the Parallel Query Option, where you might want to set up your temporary tablespace as several smaller files rather than a single large file to avoid inode contention between concurrent processes.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Yuri Ludevig wrote in message <36EE8215.750561CF_at_prodigy.net>...
>We're running Oracle 8.0.5 in AIX environment. Did anybody out there run
>any tests comparing Oracle performance running on raw devices vs jfs?
>I can't get any definite answer from Oracle.
>Any info will be appreciated.
Received on Tue Mar 16 1999 - 11:16:50 CST