In this post I'm reviewing Real Application Testing Database Reply and SQL Performance Analyzer step by step.
The initial understanding of the implementation process demand some work, but the results are excellent and worth the effort, we get valuable information to asses how our systems will behave after change, something much needed for production environments.
The document I'm attaching to this post cover the functional tests I did of both Database Replay and SQL Performance Analyzer, I'm still working on the following stages of evaluating a production load on a different platform.
The test steps can be followed on this document Real Application Testing on 10g and they are the following:
Clone production database on test server, start it up
Create 11g database on test server on Windows
Download patch 6998002 for Windows 32 bit
Download patch 6903335 for Windows 32 bit
Download patch 7044721 for 188.8.131.52 on windows
Download patch 6974999 for 10.2.0.3 on Linux
Download RAT scripts and docs from OTN
Install patch 6998002 on Windows 10g clone database
Install patch 6903335 on Windows 10g clone database
Install patch 7044721 on Windows 11g test database
Install patch 6974999 on Linux 10g test database
Configure and execute functional RAT tests on Windows
Install 11g on Linux
Create 11g Database on Linux
Migrate clone of production Database from windows to Linux
Configure and execute functional RAT tests on Linux
Install patch 6903335 on production database
Capture load on production Database
Replay production load on Linux