Re: SQL Performance Analyzer like software for 9iR2
Date: Mon, 05 May 2008 07:19:17 -0700
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