SQL Performance Analyzer and Database Replay are available for pre 11g Releases
By AVargas-Oracle on Jun 07, 2008
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
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 18.104.22.168 to 22.214.171.124
- 126.96.36.199.0 + one off
- 10.2.0.3.0 + one off patch 6974999