Veritas Storage Foundation for Oracle 5.0 Graphical User Interface Guide, HP-UX 11i v3, First Edition, May 2008

See the “Tuning for Performance” chapter of the Veritas Storage Foundation for
Oracle Administrator's Guide.
For more about disk groups and disk group procedures, see the Veritas Enterprise
Administrator Guide.
For more about disk groups and disk group procedures, see the Volume Manager
Web GUI Online Help.
About selecting a volume layout
Veritas Volume Manager offers a variety of layouts that allow you to configure
your database to meet performance and availability requirements. The proper
selection of volume layouts provides optimal performance for the database
workload.
An important factor in database performance is the tablespace placement on the
disks.
Disk I/O is one of the most important determining factors of your database's
performance. Having a balanced I/O load usually means optimal performance.
Designing a disk layout for the database objects to achieve balanced I/O is a crucial
step in configuring a database.
When deciding where to place tablespaces, it is often difficult to anticipate future
usage patterns. VxVM provides flexibility in configuring storage for the initial
database set up and for continual database performance improvement as needs
change. VxVM can split volumes across multiple drives to provide a finer level of
granularity in data placement. By using striped volumes, I/O can be balanced
across multiple disk drives. For most databases, ensuring that different containers
or tablespaces, depending on which database you are using, are distributed across
the available disks may be sufficient.
Striping also helps sequential table scan performance. When a table is striped
across multiple devices, a high transfer bandwidth can be achieved by setting the
Oracle parameter DB_FILE_MULTIBLOCK_READ_COUNT to a multiple of full stripe
size divided by DB_BLOCK_SIZE.
See “Tuning for Performance” in the Veritas Storage Foundation for Oracle
Administrator's Guide.
How to choose appropriate stripe unit sizes
When creating a striped volume, you need to decide the number of columns to
form a striped volume and the stripe unit size. You also need to decide how to
stripe the volume. You may stripe a volume across multiple disk drives on the
Managing your database
About selecting a volume layout
42