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:
1. Clone production database on test server, start it up
2. Create 11g database on test server on Windows
3. Download patch 6998002 for Windows 32 bit
4. Download patch 6903335 for Windows 32 bit
5. Download patch 7044721 for 11.0.6.1 on windows
6. Download patch 6974999 for 10.2.0.3 on Linux
7. Download RAT scripts and docs from OTN
8. Install patch 6998002 on Windows 10g clone database
9. Install patch 6903335 on Windows 10g clone database
10. Install patch 7044721 on Windows 11g test database
11. Install patch 6974999 on Linux 10g test database
12. Configure and execute functional RAT tests on Windows
13. Install 11g on Linux
14. Create 11g Database on Linux
15. Migrate clone of production Database from windows to Linux
16. Configure and execute functional RAT tests on Linux
17. Install patch 6903335 on production database
18. Capture load on production Database
19. Replay production load on Linux
