Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Errors HPUK 11.31

Mikey De
Occasional Advisor

Oracle Errors HPUK 11.31

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
4 REPLIES
Rita C Workman
Honored Contributor

Re: Oracle Errors HPUK 11.31

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
Occasional Advisor

Re: Oracle Errors HPUK 11.31

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
Honored Contributor

Re: Oracle Errors HPUK 11.31

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

HTH

Duncan
Mikey De
Occasional Advisor

Re: Oracle Errors HPUK 11.31

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