Objectives

Edit online

The Oracle's import and export utilities transfer data and structures stored in an Oracle database between multiple systems - independent of platform or product versions.

This paper 1
  • Describes the setup of an environment using the Oracle 10g R2 database on Linux® on IBM System z®
  • Compares the performance of importing data into the database on the new IBM System z10® and on IBM System z9®.
This project emerged from a customer considering to migrate his core workload on a System z9 or a System z10.
  • Currently, he is running some banking application workload on several distributed servers. He plans to migrate the core workload 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 Linux 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 the customer needs.
1 This paper is intended to provide information regarding performance of environments using the Oracle import utility and the Oracle database. It discusses findings based on configurations that were created and tested under laboratory conditions. These findings may not be realized in all customer environments, and implementation in such environments may require additional steps, configurations, and performance analysis. The information herein is provided “AS IS“ with no warranties, express or implied. This information does not constitute a specification or form part of the warranty for any IBM® products.