Quote:
Originally Posted by
Maddy123
Oracle -- 11.2.0.2.0
currently filesystemio_options parameter is set to SETALL in the DB.
According to your document it is likely your DB is affected by the problem (though i am not sure, i don't understand Oracle version counting not well enough for that). Note, though, that there seems to be a fix for the Oracle software available. IMHO it would be better to apply the necessary updates (patches, fixes or what that is called in Oracle) than to disable async I/O.
In general you need asynchronous I/O to speed up disk operations which is why Oracle (and other DBs) actually demand this option to be switched on. Switching it off may solve the problem at hand but i expect it to negatively impact performance overall. (Therefore it might be better to patch Oracle than to work around the problem at OS level.)
Further, even if you decide against patching Oracle you would better switch it off in Oracle. Asynchronous I/O is a service the OS offers. You (the application) can use it but it doesn't
have to do so! Your provided paper goes on to suggest to set "DISK_ASYNCH_IO = false", which is an
Oracle setting, not a OS setting. Therefore:
Quote:
Originally Posted by
Maddy123
One of user's DBA has suggested to either to disable async IO or apply a patch as per attached document.
Yes - I'd prefer the
apply-a-patch route as stated above, but if this is - for whatever reason - not possible the DBA will simply have to switch it off themselves.
I hope this helps.
bakunin