Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

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
For 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 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.
Improving database performance with Veritas Cached Quick I/O
Enabling and disabling Cached Quick I/O for individual files
118