Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

Collecting I/O statistics ......................................................... 108
About I/O statistics ............................................................... 108
Effects of read-aheads on I/O statistics ..................................... 110
Other tools for analysis ......................................................... 110
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
.......................................................................................... 127
Converting Quick I/O files to Oracle Disk Manager files ..................... 128
Verifying that Oracle Disk Manager is configured ............................ 128
Disabling the Oracle Disk Manager feature ...................................... 130
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
Using dbed_analyzer .................................................................. 141
Contents10