Oracle Errors HPUK 11.31

[Mikey De]

Running Oracle Databases 10.2.0.5 with
disk_asynch_io TRUE
filesystemio_options asynch

I am gettng errors in the oracle trace files as follows

WARNING:Could not increase the asynch I/O limit to 32 for SQL direct I/O. It is set to 0

Can the system suppirt async io and anyone comes across this problem before

oracle metalink has reported the problem in 11g rel 1 but not in 10.2.0.5

Any help would be appreciated
Thanks
mike

[Rita C Workman]

A quiet day so I did some research. Not sure, but maybe this thread will be helpful.

http://ericwijaya.wordpress.com/2009/11/06/warningcould-not-set-the-asynch-io-limit-to-64-for-sql-direct-io-it-is-set-to-0/

Rgrds,
Rota

[Mikey De]

rota

thanks for your reply , I did find that thread.

I did also find out that oracle for HP still uses async io regardless of the value of the init setting

disk_asynch_io=FALSE and filesystemio_options=none).

So i might as well turn off the settings

Thanks for your help
Mike

[Duncan Edmonstone]

You don't make it clear whether your data is in datafiles in filesystems or on raw/ASM partitions?

The point is that regardless of what you set these parameters to, if the data is on a filesystem on HP-UX, then there is no async IO happening anyway.

If you have access you should look at Oracle support document 139272.1

HTH

Duncan

[Mikey De]

duncan

sorry , i should have mentioned that , after having a word with out system administrator I found out that

Async I/O is only available for raw volumes and weâ re using the VxFS file systems with the concurrent I/O (CIO) option

so i have changed the following parameters in oracle

filesystemio_options string SETALL

disk_asynch_io boolean FALSE

This has resolved the problem

Thanks for your help

Mike