Run Oracle OLTP workloads in HP-UX vPars and Integrity VM v6.1.5

• All storage is presented to the guest using whole LUNs from EVA

– 12 LUNs used for holding Oracle data files

– 8 LUNs used for holding Oracle redo logs

• Dual 8 GB Fibre Channel NPIV capable HBA

Software configuration

• HP-UX 11i v3 September 2012 Data Center OE

• HP Integrity VM v6.1.5 guest kit

• No additional patches were installed, as HP-UX 11i v3 September 2012 Data Center OE has all

performance-related fixes

• HP OnlineJFS 5.0.1

• kctune parameters

– The /opt/tuneserver/bin/tuneserver –o command (part of the Tune-N-Tools product) loads an optimized set of

kernel tunable values for Oracle workloads

– Oracle requires you to set kernel tunables to specific values as follows:

• ncsize>=35840

• ninode>=34816

• maxfiles_lim>=63488

• shmseg>=512

Network configuration

• All virtual NICs are created using AVIO and DIO for respective testing

• Oracle requires you to add the following NDD parameters to the /etc/rc.config.d/nddconf file:

– tcp_smallest_anon_port=9000

– udp_smallest_anon_port=9000

– tcp_largest_anon_port=65500

– udp_largest_anon_port=65500

• Dual 10GBE vNICs (AVIO or DIO)

File system configuration

Each of the Oracle file systems is created using OnlineJFS 5.0.1 and disk layout version 7. Each file system resides in a

separate LVM 2.2 volume group. The file systems were created using LVM Distributed Extent Allocation and 1 MB

extents.

• /Oracle/oradata

– Contains the active Oracle database files

– Comprised of 12 AVIO LUNs in HP 4400 EVA disk group 1

– Created with 1 KB block size (bsize = 1024)

– Mounted with the cio mount option, enabling concurrent I/O

• /Oracle/redo

– Contains the Oracle redo log files

– Comprised of 8 AVIO LUNs in 4400 EVA disk group 2

– Created with a 1 KB block size (bsize = 1024)

– Mounted with the cio mount option, enabling concurrent I/O

Oracle configuration

In general, application software must be configured on a VM just as it would be on a physical Integrity system. Oracle is

configured as follows:

• Oracle 11g R2 Enterprise Edition (patch level 11.2.0.2.0)