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


Click here to go back to the Main OCM 12c Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

1 comment

    • Nhonvlq on July 24, 2017 at 04:36
    • Reply

    Hi Dodrigo Jorge
    I think this topic also include Consolidated Database Replay.

    Thanks and best regards,

Leave a Reply

Your email address will not be published.