Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

About I/O statistics
The output of the qiostat command is the primary source of information to use
in deciding whether to enable or disable Cached Quick I/O on specific files.
Statistics are printed in two lines per object.
The second line of information is defined as follows:
■ CREAD is the number of reads from the VxFS cache (or total number of reads
to Quick I/O files with cache advisory on)
■ PREAD is the number of reads going to the disk for Quick I/O files with the cache
advisory on
■ HIT RATIO is displayed as a percentage and is the number of CREADS minus
the number of PREADS times 100 divided by the total number of CREADS. The
formula looks like this:
(CREADs - PREADs) * 100/ CREADs
The qiostat -l command output looks similar to the following:
OPERATIONS FILE BLOCKS AVG TIME(ms)
CACHE_STATISTICS
FILE NAME READ WRITE READ WRITE READ WRITE
CREAD PREAD HIT RATIO
/db01/cust.dbf 17128 9634 68509 38536 24.8 0.4
17124 15728 8.2
/db01/system.dbf 6 1 21 4 10.0 0.0
6 6 0.0
/db01/stk.dbf 62552 38498 250213 153992 21.9 0.4
62567 49060 21.6
OPERATIONS FILE BLOCKS AVG TIME(ms)
CACHE_STATISTICS
FILE NAME READ WRITE READ WRITE READ WRITE
CREAD PREAD HIT RATIO
OPERATIONS FILE BLOCKS AVG TIME(ms)
CACHE_STATISTICS
FILE NAME READ WRITE READ WRITE READ WRITE
CREAD PREAD HIT RATIO
109Using Veritas Cached Quick I/O
Determining candidates for Cached Quick I/O