How to enable verify async I/O is enabled on Oracle Enterprise Linux 5.4
942063Jun 7 2012 — edited Jun 9 2012We are working on optimizing our Oracle Database 11g R2 environment. We plan to enable Asynchronous I/O within the database but need to first enable or verify Asynchronous I/O (AIO) is enabled at the OS level. We are running Oracle Enterprise Linux 5.4 64-bit. I have read a lot of documentation and came across several methods of checking if AIO is in use after it is enabled on the database but cannot find anything specific to verify if it is actually turned on without it in use. Is there a configuration file I can check to see if this is enabled. Is it possible it is enabled by default and all we need to do is turn it on at the database level to take advantage of it.
If it helps, we plan on setting the following parameters on the database instance once I confirm AIO is enabled at the OS level.
filesystemio_options = SETALL
disk_asynch_io = TRUE
db_writer_processes = 1
Thanks in advance for any responses.