Oracle Perfomance Benchmark on VMware (2.3)

OraBench Performance ReportOracle Performance on VMwareApril 2009Manfred DrozdContents1 Oracle Database Platform2 Benchmark Suite OraBench3 T100 – PL/SQL (cpu)4 T200 – Data Write (sequential)5 T300 – Data Insert (conventional, bulk)6 T400 – Data Scan (sequential)7 T500 – Data Aggregate (create b-tree/bitmap index)8 T600 – Data Select (random)9 T700 – Data Update (random)10 Conclusion©In&Out AG 2009 Oracle Performance on VMware 2Oracle Database Platform Real Server Storage- IBM blade HS21 - IBM DS 4700- 2 x Xeon 5130 dual core - 16 spindles, 15k rpm-2 .0 G Hz -4 G bit/sec F C- 4 Gbyte RAM- Suse Linux 10 EE 64-bit Oracle- 10.2.0.4 EE 64-bit Virtual Server- ESX 3.5 upgrade 2 Database configuration- 8 Kbyte block size- 2 Gbyte SGA- 1 Gbyte PGA©In&Out AG 2009 Oracle Performance on VMware 3Benchmark Suite OraBench (1) Release 6.4 Complete set of performance tests- all basic database ops - Synthetic Benchmark not only TPC-C like tx- small database size, 64 Gbyte - independent of application - benchmark table profile (OLTP, DWH)28 Gbyte, 128 million rows - parallel degree from 1 up to platform saturation Useful for measures limitations of all - platform performance certification platform resources -c om parison o f -CPUo platforms - Memoryocomponents-I/Oo configurations©In&Out AG 2009 Oracle Performance on VMware 4Benchmark Suite OraBench (2) Performance metrics- cpu speed & throughput- ...