VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Enabling and Disabling Cached Quick I/O for Individual Files Prerelease 8 September 2005, 8:54am
120 VERITAS Storage Foundation for Oracle Administrator’s Guide
▼ To enable Cached Quick I/O for an individual file
Use the qioadmin command to set the cache advisory to
ON as follows:
$ /opt/VRTS/bin/qioadmin -S filename=ON /mount_point
Example
Running qiostat shows the cache hit ratio for the file /db01/system.dbf reaches a level
that would benefit from caching. To enable Cached Quick I/O for the file /db01/system.dbf,
set the cache advisory to
ON:
$ /opt/VRTS/bin/qioadmin -S system.dbf=ON /db01
Making Individual File Settings for Cached Quick I/O Persistent
You can make the enable or disable individual file settings for Cached Quick I/O persistent across
reboots and mounts by adding cache advisory entries in the /etc/vx/qioadmin file.
Cache advisories set using the qioadmin command are stored as extended attributes of the file in
the inode. These settings persist across file system remounts and system reboots, but these
attributes are not backed up by the usual backup methods, so they cannot be restored. Therefore,
always be sure to reset cache advisories after each file restore. This is not necessary if you maintain
the cache advisories for Quick I/O files in the /etc/vx/qioadmin file.
▼ To enable or disable individual file settings for Cached Quick I/O automatically after a reboot
or mount
Add cache advisory entries in the /etc/vx/qioadmin file as follows:
device=/dev/vx/dsk/diskgroup/volume
filename,OFF
filename,OFF
filename,OFF
filename,ON
Example
To make the Cached Quick I/O settings for individual files in the /db01 file system persistent, edit
the /etc/vx/qioadmin file similar to the following:
#
# List of files to cache in /db01 file system
#
device=/dev/vx/dsk/PRODdg/db01
cust.dbf,OFF
system.dbf,OFF