Improving the performance of single instance Oracle on file systems, January 2008

16
Appendix A – SMS bundles containing ODM
Oracle Disk Manager is included in the Oracle and Oracle Premium bundles of HP SG SMS.
SG SMS vA.01.00 is supported on HP-UX 11i v2 and contains the Veritas 4.1 products. Table 3 lists
the specific products that contain ODM.
Table 3 SG SMS A.01.00 bundles containing ODM
Bundles with ODM, including SG A.11.17
T2773BA HP Serviceguard Storage Management for Oracle – SGSMO
T2774BA HP Serviceguard Storage Management for Oracle Premium – SGSMOP
T2776BA HP Serviceguard Cluster File for Oracle – SGCFSO
T2777BA HP Serviceguard Cluster File for RAC – SGCFSRAC
Bundles with ODM, including SG A.11.17 for Mission-Critical Operating Environments
T2794BA MCOE + HP Serviceguard Storage Management for Oracle Premium
T2796BA MCOE + HP Serviceguard Cluster File for Oracle
T2797BA MCOE + HP Serviceguard Cluster File for RAC
Bundles with ODM, without Serviceguard, for Enterprise Operating Environments
T2792BA
EOE + Storage Management for Oracle Premium
Bundles with ODM, without Serviceguard, for Foundation Operating Environments
T2789BA FOE + HP Storage Management for Oracle
T2790BA FOE + HP Storage Management for Oracle Premium
To find specific product numbers for later releases of SG SMS containing ODM, refer to the Release
Notes at http://docs.hp.com
ÆHigh AvailabilityÆHP Serviceguard Storage Management
Suite
ÆRelease Notes.
Appendix B – Experimental setup and test method
Oracle Database was installed on the SUT and a 1,000-warehouse database was created with a
footprint of about 220 GB. After creating the database, it was backed up to an archive location so it
could easily be restored (using the HP-UX utility, /usr/bin/dd, between tests).
HP StorageWorks Command View EVA was used to create Virtual Raid devices that could be added
together across the two EVA 3000s to create two working areas for the tests. Logical volume striping
(64 KB stripe size) was used across 32 LUNs for the Oracle data files and a further 32 LUNs were
used for online redo log files. Then, each I/O subsystem configuration was created (for example,
using VxVM commands or LVM commands).
The asynchronous disk device driver was installed by default in the operating environment, but the
device file minor number was changed to set it from 0x0 to 0x101 using the following command:
$ mknod /dev/async c 101 0x101