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

10
Experiment 2: Online JFS on VxVM volumes with ODM enabled
The next configuration measured the TPM on Online JFS with ODM enabled, to find the relative
performance of the ODM-enabled file system versus raw volumes on VxVM 4.1.
Figure 3 Oracle 9.2.0.7 – Comparing Online JFS and ODM on VxVM 4.1 versus raw VxVM volumes
The results show a nearly 8% degradation in performance relative to raw volumes on VxVM v4.1 for
workloads of 80 or more clients.
Experiment 3: Comparison of Online JFS without ODM enabled
Using the same configuration as in Experiment 2 except with ODM disabled (replaced with the stub
library), there is a significant drop in performance, as shown in Figure 4.
Without ODM, %idle is very high and measurements above 80 clients were not performed because
no significant change in TPM numbers was observed above 20 clients. The percentage idle levels off
at 78% and the system is I/O bound.