Async IO does not appear to be in use by Oracle on VxFS (Doc ID 756275.1)

Last updated on DECEMBER 25, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2016***



Symptoms

Asynchronous I/O is enabled on the machine and in the database with disk_asynch_io = true and filesystemio_options = asynch but Oracle does not seem to be doing async IO when monitoring from the operating system.

Changes

Veritas ODM driver is being used, which is the default way to setup VxFS with Oracle.

You see some lines like below in alert.log that indicate ODM is being used:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms