VERITAS File SystemÖ 3.5 (HP OnlineJFS/JFS3.5) AdministratorÆs Guide (December 2002)

Chapter 8

Quick I/O for Databases

Quick I/O Statistics

Quick I/O provides the qiostat utility to collect database I/O statistics generated over a period of time.

qiostat reports statistics such as the number of read and write operations, the number of blocks read or

written, and the average time spent on read and write operations during an interval. See the qiostat (1)

manual page for more information.

Quick I/O Summary

To increase database performance on a VxFS file system using Quick I/O:

Step 1. Make sure that the VERITAS Editions product is installed:

# swinstall | grep VRTSdbed

Step 2. Make sure that the VERITAS Quick I/O package is licensed:

# vxlicrep | VXFDD

Step 3. Create a regular VxFS file and preallocate it to required size, or use the qiomkfile command. The

size of this preallocation depends on the size requirement of the database server.

Step 4. Create and access the database using the file name

xxx

::cdev:vxfs:.

For information on how to configure VxFS and set up file devices for use with new and existing Oracle

databases, see the VERITAS Editions product documentation.