OCM 12c Preparation - Perform real application testing

This is another topic that you should avoid at all costs using any approach different from Oracle Enterprise Manager. It will save you a lot of time!

Real Application Testing = Database Replay + SQL Performance Analyzer

Performance Analyser is specially good when we are doing an Upgrade in our Oracle Version, so you can check the times of the queries before/after the change. For 12c OCM, probably we will face some database change scenario, like:

• Parameter Change
• Optimizer Statistics

Practice here creating and moving across instances a SQL Tuning Set and checking the performance changes after a very intensive parameter modification, as optimizer_mode set to ‘RULE’.

Path to Documentation:

Oracle Database SQL Tuning Guide -> 19 Managing SQL Tuning Sets
Database Testing Guide -> 1.1 SQL Performance Analyzer

+2