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

Improving database

performance with Veritas

Cached Quick I/O

This chapter includes the following topics:

■ Tasks for setting up Cached Quick I/O

■ Enabling Cached Quick I/O on a file system

■ Determining candidates for Cached Quick I/O

■ Enabling and disabling Cached Quick I/O for individual files

Tasks for setting up Cached Quick I/O

To set up and use Cached Quick I/O, you should do the following in the order in

which they are listed:

■ Enable Cached Quick I/O on the underlying file systems used for your database.

■ Exercise the system in your production environment to generate file I/O

statistics.

■ Collect the file I/O statistics while the files are in use.

■ Analyze the file I/O statistics to determine which files benefit from Cached

Quick I/O.

■ Disable Cached Quick I/O on files that do not benefit from caching.

Chapter