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.

  • See the qioadmin (1) manual page.