Re: SQL Performance Analyzer like software for 9iR2

From: H.TonguÁ YILMAZ <>
Date: Sun, 8 Jun 2008 10:41:59 +0300
Message-ID: <>

Thank you Bob and all who shared opinions, finally I saw the paper is now published and wanted to share with the group.

Note:560977.1 - Real Application Testing Now Available for Earlier Releases

2008/5/3 Bob Carlin <>:

> 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.
> H.TonguÁ YILMAZ wrote:
>> Hi all,
>> 11g's SQL Performance Analyzer(DBMS_SQLPA - )
>> is announced to capture the load of a <> database
>> and report the differences after applying this load onto a 11g database. We
>> need a similar software during our 9.2 to 10.2 migration so I want to have
>> your comments on below two topics;
>> 1- is there any software you used before and may suggest for this need?
>> 2- to get bind values on 9i is there any dictionary view like
>> V$SQL_BIND_CAPTURE of 10g or all we can do is Event 10046 Level 4 tracing at
>> instance level?
>> Thank you.
>> --
>> Best Regards,
>> H.TonguÁ YILMAZ

Best Regards,

Received on Sun Jun 08 2008 - 02:41:59 CDT

Original text of this message