Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Determining candidates for Cached Quick I/O .................................. 107
Collecting I/O statistics ......................................................... 108
About I/O statistics ............................................................... 109
Effects of read-aheads on I/O statistics ..................................... 110
Other tools for analysis ......................................................... 111
Enabling and disabling Cached Quick I/O for individual files .............. 111
Setting cache advisories for individual files ............................... 111
Making individual file settings for Cached Quick I/O
persistent ..................................................................... 112
Determining individual file settings for Cached Quick I/O using
qioadmin ...................................................................... 113
Chapter 6 Using Veritas Concurrent I/O .......................................... 115
About Concurrent I/O .................................................................. 115
How Concurrent I/O works ..................................................... 116
Oracle's filesystemio_options parameter ................................... 116
Enabling and disabling Concurrent I/O ........................................... 116
Enabling Concurrent I/O ........................................................ 117
Disabling Concurrent I/O ....................................................... 118
Chapter 7 Using Veritas Extension for Oracle Disk
Manager ......................................................................... 119
About Oracle Disk Manager .......................................................... 119
How Oracle Disk Manager improves database performance .......... 120
About Oracle Disk Manager and Oracle Managed Files ...................... 122
How Oracle Disk Manager works with Oracle Managed Files ......... 123
Setting up Veritas Extension for Oracle Disk Manager ....................... 125
Linking the Veritas extension for Oracle Disk Manager library
into Oracle home ............................................................ 126
How to prepare existing database storage for Oracle Disk Manager
......................................................................................... 128
Converting Quick I/O files to Oracle Disk Manager files ..................... 129
Verifying that Oracle Disk Manager is configured ............................ 129
Disabling the Oracle Disk Manager feature ...................................... 131
Chapter 8 Using Storage Mapping .................................................... 133
About Storage Mapping .............................................................. 133
Verifying Veritas Storage Mapping setup ....................................... 134
Using vxstorage_stats ................................................................. 135
Displaying Storage Mapping information .................................. 136
Displaying I/O statistics information ....................................... 137
Contents10