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

online transaction processing 25, 78
options
largefiles and nolargefiles 35
Oracle
autoextend feature 96
media recovery 175
recovery 174
Recovery Manager (RMAN) 375
Oracle configuration environment
saving 314
Oracle datafile header size 80
Oracle Disk Manager 119
benefits 120
converting Quick I/O files 128
disabling 131
migrating files to 128
preparing existing databases for use with 127
restoring files using NetBackup 285, 376
setting up 125
Oracle Enterprise Manager 148
Oracle Managed Files 122
working with Oracle Disk Manager 123
Oracle tempfiles
recreating 274
overview
of Quick I/O 32
P
parallel data transfer
using striping for 24
PARALLEL_MAX_SERVERS 300
PARALLEL_MIN_SERVERS 300
parameters
default 291
tunable 291
tuning 291
parity 25
performance
obtaining statistics for volumes 288
RAID-5 25
tuning
for databases 300
performance data
using 297
performance tuning
list of guides 287
persistence
for Cached Quick I/O settings 112
persistent FastResync 28
persistent snapshot 35
planning space for Storage Checkpoints 206
PREADs 110
preallocating space for Quick I/O files 78, 81
Q
qio_cache_enable flag
disabling 105
enabling 105
qio_cache_enable tunable parameter 294
qio_convertdbfiles command 84, 88, 307
qio_getdbfiles command 84, 87, 307
qio_recreate command 307, 360
qioadmin command 111
qiomkfile command 94–96, 377
options for creating files
symbolic links 80
qiostat
output of 109
qiostat command 108, 296–297
Quick I/O
accessing regular VxFS files as 83
benefits 76
converting files to 88
converting files to Oracle Disk Manager 128
determining file fragmentation before
converting 86
determining status 93
disabling 98
enabling 78
extending files 94
extending files with autoextend 96
extracting file list for conversion 87
improving database performance with 76
list file for conversion 87
naming convention for files 78
overview 32
performance improvements 103
performance tuning for 302
preallocating space for files 78, 81
recreating files 360
requirements 77
showing resolution to a raw device 93
using relative and absolute pathnames 83
quotas 36
R
RAID 23
Index398