Re: AIO on ASM

sagyvolkov_at_gmail.com wrote:
> Ho, may bad a typo... :)
> Oracle wrote on a TAR i open that "This is a decision you need to make
> on your own depending on how your environment is performing. If the
> Operating System supports AIO, then ASM w
> ill support it as well. It's your decision whether or not you want to
> enable th
> is in your environment for the disks being used by ASM specifically. "
>

The answer to your TAR is definitely true. The only exception I know is 10gR1 on linux where you need to explicitly relink against libaio... and that's your case.

After relinking the binaries your instance (which is based on ASM) is going to use AIO in spite of whatever you set in filesystemio_options (simply because you are using a device like "raw" and DISK_ASYNCH_IO is set to true by default).

Still filesystemio_options shows that the server and shadow processes are using different syscalls.

As long as I don't sort the difference out and based on a IBM document I suggest you to set filesystemio_options=asynch or filesystemio_options=setall (in your RDBMS instance).

I hope I'm not confusing you...

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe