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ç YILMAZhttp://tonguc.yilmaz.googlepages.com/