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.