Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Chapter 14 Using Veritas NetBackup for database backup ........... 295
About using Veritas NetBackup for backup and restore ..................... 295
Using Veritas NetBackup to backup and restore Quick I/O files ........... 295
About using Veritas NetBackup to backup and restore Oracle Disk
Manager files ...................................................................... 297
Chapter 15 Tuning for performance ................................................... 299
Additional documentation ............................................................ 299
About tuning VxVM ................................................................... 299
About obtaining volume I/O statistics ...................................... 300
About tuning VxFS ..................................................................... 301
How monitoring free space works ............................................ 301
How tuning VxFS I/O parameters works ................................... 303
About tunable VxFS I/O parameters ......................................... 303
About obtaining file I/O statistics using the Quick I/O
interface ....................................................................... 308
About I/O statistics data ........................................................ 308
Obtaining file I/O statistics using Veritas extension for Oracle
Disk Manager ................................................................ 310
About I/O statistics ............................................................... 311
About tuning Oracle databases ...................................................... 312
Sequential table scans ........................................................... 312
Asynchronous I/O ................................................................ 312
Tuning buffer cache .............................................................. 313
Setting Oracle block reads during sequential scans ..................... 313
Setting slave parameters ....................................................... 314
Configuring memory allocation ............................................... 314
About tuning HP-UX ................................................................... 314
max_thread_proc ................................................................. 315
asyncdsk, asyncdsk_included, and max_async_ports ................... 315
eqmemsize .......................................................................... 315
nproc ................................................................................. 315
maxuproc ........................................................................... 315
semmni .............................................................................. 315
semmns .............................................................................. 316
Appendix A Veritas Storage Foundation for Oracle Command
Line Interface ............................................................... 317
Overview of commands ............................................................... 317
About the command line interface ................................................. 320
Updating the repository using dbed_update .............................. 321
Contents14