Re: SQL Performance Analyzer like software for 9iR2

From: Bob Carlin <>
Date: Mon, 05 May 2008 07:19:17 -0700
Message-ID: <>

There is (or will be shortly) a White Paper available showing exactly this. It relies on two things:

   i. A Remote test-execute feature of SQLPA.    ii. The ability to define the baseline 9i workload from SQL Trace files.

Essentially you use an 11g database simply to run SQLPA. You capture your workload from 9i by enabling SQL Trace and then "import" the trace files in SQLPA and create a tuning set from them. You can then rerun the workload against your 10g database using the remote test-execute.

Received on Mon May 05 2008 - 09:19:17 CDT

Original text of this message