File system asynchronus options" enabled

[Former Member]

hello experts

i want to check whether "asynchronus options" enabled for /oracle ?

how i can?

regards

sachin

[Former Member · Accepted solution]

Hi,

check Note 694810 - Oracle 9.2.0.x and AIX Asynchronus IO parameter

regards,

kaushal

[Former Member · Accepted solution]

hello kaushal

my parameters are

FILESYSTEMIO_OPTIONS setall

DISK_ASYNCH_IO TRUE

TAPE_ASYNCH_IO TRUE

as per this note 694810 , i want to make FILESYSTEMIO_OPTIONS = ASYNCH.

by sqlplus? what will be command?

[Former Member · Accepted solution]

Hi,

No need to change the parameter in your case

FILESYSTEMIO_OPTIONS -> setall

which allows oracle to utilize asynchronus as well as direct I/O when present.

so leave it as it is.

if you want to change then use

alter system set filesystemio_options = '<value>';

regards,

kaushal

[Former Member · Accepted solution]

Thanks

i can alter this parameter in live system ?

regards

sachin

[Former Member · Accepted solution]

Hi,

I already told you No need to change the parameter in your case.

if you still want to change then you can change according to my previous answers.

regards,

kaushal

[stefan_koehler · Accepted solution]

Hello,

>I already told you No need to change the parameter in your case.

It depends.. just check my blog about that topic:

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan

Thanks for Update.

i understand that when parameter FILESYSTEMIO_OPTIONS has value setall

it's allows oracle to utilize asynchronus as well as direct I/O when present. (Note 694810)

regards,

kaushal

[stefan_koehler · Accepted solution]

Hi Kaushal,

>i understand that when parameter FILESYSTEMIO_OPTIONS has value setall

>it's allows oracle to utilize asynchronus as well as direct I/O when present. (Note 694810)

It also depends on the type of the filesystem under AIX (JFS or JFS2).

Check this link: http://www.rampant-books.com/t_oracle_direct_i_o.htm

Specification of the value SETALL for this parameter ensures that:

>§ Datafiles on a JFS file system are accessed using direct I/O

>§ Datafiles on a JFS2 file system are accessed using concurrent I/O

You can check this with "lsof +fg "... in our environment the files are accessed with cio on JFS2.

The reason why you should mount the filesystem with the CIO option are the external backup utilities (for example TDP for MySAP).

Regards

Stefan

[Former Member · Accepted solution]

Hi,

Thanks again for clarification

regards,

kaushal