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

Accessing regular VxFS files as Quick I/O files ................................... 91
Converting Oracle files to Quick I/O files .......................................... 92
About sparse files ......................................................................... 98
Handling Oracle temporary tablespaces and Quick I/O ........................ 99
Displaying Quick I/O status and file attributes ................................. 101
Extending a Quick I/O file ............................................................ 102
Using Oracle's AUTOEXTEND with Quick I/O files ............................ 104
Recreating Quick I/O files after restoring a database ......................... 105
Disabling Quick I/O ..................................................................... 107
Chapter 8 Improving database performance with Veritas
Cached Quick I/O ........................................................ 109
Tasks for setting up Cached Quick I/O ............................................ 109
Enabling Cached Quick I/O on a file system ..................................... 110
Enabling and disabling the qio_cache_enable flag ....................... 110
Making Cached Quick I/O settings persistent across reboots and
mounts ......................................................................... 111
Using vxtunefs to obtain tuning information ............................. 112
Determining candidates for Cached Quick I/O .................................. 113
Collecting I/O statistics ......................................................... 114
About I/O statistics ............................................................... 115
Effects of read-aheads on I/O statistics ..................................... 116
Other tools for analysis ......................................................... 117
Enabling and disabling Cached Quick I/O for individual files .............. 117
Setting cache advisories for individual files ............................... 117
Making individual file settings for Cached Quick I/O
persistent ..................................................................... 118
Determining individual file settings for Cached Quick I/O using
qioadmin ...................................................................... 119
Section 3 Making point-in-time copies ............................... 121
Chapter 9 About point-in-time copies .............................................. 123
Database snapshot and backup options ........................................... 123
Database FlashSnap for cloning .............................................. 123
Database Storage Checkpoints for recovery ............................... 124
About Veritas Database FlashSnap ................................................ 125
Database FlashSnap requirements ........................................... 126
Solving typical database problems with Database
FlashSnap ..................................................................... 126
How Veritas Database FlashSnap works .......................................... 126
Contents10