VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Index 533
Prerelease 8 September 2005, 8:56am
Oracle datafile header size 70
Oracle Disk Manager 105
benefits 106
converting Quick I/O files 115
disabling 118
migrating files to 115
preparing existing databases for use with 114
restoring files using NetBackup 249, 485
setting up 112
working with OMF 109
Oracle Enterprise Manager 133
Oracle Managed Files 109
working with Oracle Disk Manager 109
Oracle tempfiles
recreating 234
overview
of Quick I/O 18
P
parallel data transfer, using striping for 9
parallel Storage Rollback 348, 351, 353, 355,
357
PARALLEL_MAX_SERVERS 399
PARALLEL_MIN_SERVERS 399
parameters
default 391
tunable 392
tuning 391
parity 10
performance
obtaining statistics for volumes 388
RAID-5 10
setting buffer size for Storage Rollback 359
setting number of Rollback threads 358
tuning, for databases 399
performance data
using 396
performance tuning, for databases 402
performance tuning, list of guides 387
persistence
for Cached Quick I/O settings 103
persistent FastResync 13
persistent snapshot 22
planning space for Storage Checkpoints 168
PREADs 101
preallocating space for Quick I/O files 68, 72
preallocation 521
PRODUCTNAME
accessibility
assistive technology support 509
keyboard navigation 502
keyboard shortcuts 504
PRODUCTVERSION
accessibility
dialog boxes 502
Q
qio_cache_enable flag
disabling 96
enabling 95
qio_cache_enable tunable parameter 394
qio_convertdbfiles command 76, 78, 408, 479
qio_getdbfiles command 76, 78, 408, 478
qio_recreate command 409, 472, 481
qioadmin command 102
qiomkfile command 70, 86, 87, 88, 486
options for creating files
symbolic links 70
qiostat command 99, 396, 397
qiostat, output of 100
QoSS. See quality of storage service
quality of storage service 21
Quick I/O
accessing regular VxFS files as 74
benefits 66
converting files to 78
converting files to Oracle Disk Manager 115
converting VxFS files to 478, 479
determining file fragmentation before
converting 77
determining status 84
disabling 90
enabling 68
extending files 86
extending files with autoextend 88
extracting file list for conversion 78
improving database performance with 66
list file for conversion 78
naming convention for files 68
overview 18
performance improvements 93
performance tuning for 402
preallocating space for files 68, 72
recreating files 472, 481
requirements 67
showing resolution to a raw device 85
using relative and absolute pathnames 74
quotas 23