Re: SQL Performance Analyzer like software for 9iR2

From: Roman Podshivalov <roman.podshivalov_at_gmail.com>
Date: Mon, 5 May 2008 11:48:06 -0400
Message-ID: <55f303590805050848o2367f37bp81590973c75c6769@mail.gmail.com>


Hi,

You can try to use HammerOra free tool to parse 10046 trace files from 9i and re-play them against 10g migrated instance.

http://hammerora.sourceforge.net/about.htm

--romas

On 4/23/08, H.TonguÁ YILMAZ <tonguc.yilmaz_at_gmail.com> 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 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/

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 05 2008 - 10:48:06 CDT

Original text of this message