Re: SQL Performance Analyzer like software for 9iR2

From: H.TonguÁ YILMAZ <tonguc.yilmaz_at_gmail.com>
Date: Sun, 8 Jun 2008 10:41:59 +0300
Message-ID: <f8e9eb670806080041m2b26d3afm27485b32dbabb9d1@mail.gmail.com>


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 https://metalink.oracle.com/metalink/plsql/docs/spa_9i_doc.pdf

2008/5/3 Bob Carlin <smeghead.rimmer_at_gmail.com>:

> 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 - http://tinyurl.com/6xdhvd )
>> is announced to capture the load of a 10.2.0.4 <http://10.2.0.4> 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
>>
>> http://tonguc.yilmaz.googlepages.com/
>>
>

-- 
Best Regards,
H.TonguÁ YILMAZ

http://tonguc.yilmaz.googlepages.com/

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jun 08 2008 - 02:41:59 CDT

Original text of this message