Re: VXFS an create datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 13 May 2005 19:39:58 +0200
Message-ID: <pfp981hn2ee6f3rome0ttkpookrar9rsjp@4ax.com>

On 13 May 2005 02:58:05 -0700, ylecornec_at_hotmail.com wrote:

>discovered_direct_io seems to have a very strange behavior...has
>someone already noticed this behaviour, and understand what happens?

Standard Vxfs doesn't support async IO. If you have async_io enabled in the database, Oracle will issue KAIO calls. They will fail and Oracle will automatically fall back into issuing an ordinary pwrite. This is the behavior you are observing.
You need to find a bunch of $$ and buy Veritas Database Edition to resolve this, or disable async io.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri May 13 2005 - 12:39:58 CDT