For the most part, you don’t need to make changes to your Oracle configuration in order to realize immediate performance benefits on a Everpure FlashArray. However, if you have an extremely heavy OLTP workload, there are a few tweaks you can make that help you squeeze the most I/O out of your system. In our testing, we found that the following settings increased performance by about 5%.
filesystemio_options = SETALL- Enabled both direct I/O and asynchronous I/O where possible.
log_buffer = {at least 15MB} - Values over 100MB are not uncommon.
On Linux, Automatic Storage Management uses asynchronous Input-Output by default. Asynchronous Input-Output is not supported for database files stored on Network File Systems.
If the file system files are managed through ODM library interface or Direct NFS Client, asynchronous Input-Output is enabled by default. There is no need to set FILESYSTEMIO_OPTIONS to enable asynchronous Input-Output in these environments.|