Enabling and disabling Cached Quick I/O for individual files
After using qiostat or other analysis tools to determine the appropriate files for Cached Quick I/O, you need to disable Cached Quick I/O for those individual files that do not benefit from caching using the qioadmin command.
Prerequisites
Enable Cached Quick I/O for the file system before enabling or disabling Cached Quick I/O at the individual file level.
Usage notes
You can enable or disable Cached Quick I/O for individual files while the database is online.
You should monitor files regularly using qiostat to ensure that a file's cache-hit ratio has not changed enough to reconsider enabling or disabling Cached Quick I/O for the file.
Enabling or disabling Cached Quick I/O for an individual file is also referred to as setting the cache advisory on or off.