Tonguç. 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 - 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? -- John Kanagaraj <>< DB Soft Inc http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (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 ** -- //www.freelists.org/webpage/oracle-l