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@xxxxxxxxx>: > 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/