X

Alejandro Vargas' Blog

  • June 7, 2008

SQL Performance Analyzer and Database Replay are available for pre 11g Releases

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

Change Control is one of the most important aspects of managing a production database environment, the back port of this functionality is a major breakthrough, that will make easier to migrate 9i production environments to 10g and 11g.

SQL Performance Analyzer
permits to identify SQL

performance issues caused by system changes, the performance analyzer assess the impact of that changes and provide a report that highlight any  differences between the before and after situations.

Database Replay permits to

perform comprehensive change control testing, using workloads taken from production environments. Problems can

be identified and solved on the test stage before implementing the changes on

production.

Whole details of the process can be obtained from Metalink Note: 560977.1

This functionality for 11g has been ported to

Oracle Server - Enterprise Edition - Versions 9.0.1.0  to  11.1.0.6

  • 9.2.0.8.0 + one off

    patch 6973309.
  • 10.2.0.3.0 + one off patch 6974999

Join the discussion

Comments ( 2 )
  • Tonguc Sunday, June 8, 2008
    Hi Alejandro, recently this was one of the best news for me really :)
    Did you have the chance to try this feature?
  • Doug Burns Sunday, June 8, 2008
    Alejandro,
    Does this require an additional RAT license on the workload capture instances, even though they can't be used for replay?
    Cheers,
    Doug
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.