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

9
In addition, Online JFS and VxVM version 4.1 were used in both benchmarks, and all servers were
running 11iv2 HP-UX 11.23.0609 MCOE with hardware enablement patches for 11i v2 September
2006.
Results: Single-Instance Oracle 9.2.0.7
The following results were obtained.
Experiment 1: Raw Volumes on VxVM 4.1
The TPM numbers for a workload of 20 - 140 clients is shown in Figure 2, along with CPU usage.
For 80 clients or more, the measured TPM leveled out at about 47,000, and %idle time fell to about
1%.
This gradual leveling shows that the system is CPU bound, with adequate storage and network
bandwidth because virtually all user CPU cycles are being converted to throughput. System CPU
usage leveled off at about 16%.
Figure 2 Oracle 9.2.0.7 – TPM versus workload with CPU utilization for raw volumes on VxVM 4.1