Re: SQL Performance Analyzer like software for 9iR2

  • From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
  • To: tonguc.yilmaz@xxxxxxxxx
  • Date: Wed, 23 Apr 2008 22:08:49 -0700


Note that V$SQL_BIND_CAPTURE does not capture all bind variables, but
only 'samples' are retained. In other words, this is a hit-or-miss
that you would capture an interesting bind variable.

OTOH, you can always use a tool such as Load runner to perform
repeatable load testing across the whole stack. IMHO, RAT places a SQL
load on the Db alone.

> 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?

John Kanagaraj <><
DB Soft Inc (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **

Other related posts: