Oracle Real Application Testing (RAT): A Complete Step-by-Step Guide
Oracle Real Application Testing (RAT) is the authoritative tool for validating changes to an Oracle database before production deployment. It enables you to replay a real production workload against a test system and measure the performance impact of changes such as database upgrades, parameter changes, hardware migrations, or schema modifications. This article walks through both RAT components — Database Replay and SQL Performance Analyzer (SPA) — with step-by-step procedures. RAT Component Overview Component What It Tests Best For Database Replay Entire production workload (concurrent sessions, timing, interactions) Database upgrades, hardware changes, OS upgrades SQL Performance Analyzer (SPA) Individual SQL statements from AWR SQL Tuning Set Optimizer changes, parameter tuning, index changes Both require the Oracle Real Application Testing licence option in addition to Enterprise Edition. ...