Oracle’s Real Application Testing package consisting of Database Replay and the powerful SQL Performance Analyzer (SPA) gives you great possibilities to predict database performance before you’ll upgrade – with very low testing effort.
Just in case you are using RAT or plan to use it in the near future please make sure you’ve applied the following MLRs (Merge Label Request, a merge of several single patches) to your Oracle installation:
- 18.104.22.168 Database Replay : MLR 8712466 (if either capture or replay side is on 22.214.171.124)
- 126.96.36.199 SPA : MLR 8756594 (both for 11g SPA system OR if source/destination is on 188.8.131.52 and remote test execution is being used)
If you are just working with either DB Replay or SPA you’ll need only the fix for the specific feature.
For more information on Real Application Testing see the OTN page.