VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 4, Using VERITAS Cached Quick I/O
Prerelease 8 September 2005, 8:54am Enabling and Disabling Cached Quick I/O for Individual Files
119
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 for more information.
Setting Cache Advisories for Individual Files
▼ To disable Cached Quick I/O for an individual file
Use the qioadmin command to set the cache advisory to
OFF as follows:
$ /opt/VRTS/bin/qioadmin -S filename=OFF /mount_point
Example
To disable Cached Quick I/O for the file /db01/system.dbf, set the cache advisory to
OFF:
$ /opt/VRTS/bin/qioadmin -S system.dbf=OFF /db01