Thanks Shawn, Might also be interesting to see that same study with Oracle 10.2.0.4.
Gerard -----Original Message----- From: Linux on 390 Port [mailto:[email protected]] On Behalf Of Shawn Wells Sent: Tuesday, July 07, 2009 9:39 AM To: [email protected] Subject: Oracle 10g R2 on RHEL 4.5 on System z Performance This paper - Describes the setup of an environment using the Oracle 10g R2 database on RHEL 4.5 on IBM System z - Compares the performance of importing data into the database on the new IBM System z10 and legacy IBM System z9 This project emerged from a customer considering to migrate his core workload on System z9 or a System z10. - Currently, they are running some banking application workload on several distributed servers. He plans to migrate the core workloads to Linux (Red Hat) on System z. The application performance had to be measured between System z9 versus System z10. The scenario is a data import from a DS8000 storage server into an Oracle 10g R2 database running Red Hat under z/VM 5.3 on a System z - The size of the environment in terms of CPUs, memory, and disks, was defined according to customer needs. This test was 100% performed by IBM. In summary, they found that a System z10 sustained 250 MB/sec on data imports -- not bad. The paper is available at: TechDocs: http://www.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101507 DeveloperWorks: http://www.ibm.com/developerworks/linux/linux390/perf/tuning_pap_databas e_Oracle.html PDF is also attached. -- Shawn D. Wells<[email protected]> Global System z Platform Manager Cell: (+1) 443-534-0130 (GMT -5) ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
