Real Application Testing Database Replay、SPA的价格和介绍

Real Application Testing = SPA + Database Replay

SPA和 Database Replay的区别：

Database Replay好比是给鸭梨山大的锤子：

SPA: SQL focused and unit testing SQL component
Database Replay: Workload focused, comprehensive testing of database stack

Database Replay
Load testing solution for performance and scalability testing
“Capture” entire workload (queries, DML, DDL, PL/SQL, etc.) in production, including concurrency
“Replay” entire workload in test with exact production characteristics including concurrency
Ideal for system upgrades, configuration changes (SI to RAC), storage changes, etc.

SPA还比是好用的起钉锤：

SQL Performance Analyzer
Solution for identifying performance regressions/improvements resulting from execution plan changes
“Capture” SQL queries from production, including executions plans & stats
“Test-Execute” SQL queries serially “before” and “after” changes
Compare “before” and “after” SQL execution plans and performance stats
Ideal for changes impacting query plans such as db upgrades, optimizer statistics refresh, new index creation, etc.

Real Application Testing RAT作为DBEE(企业版)数据库的选项来销售， 单独使用SPA或Database Replay均要求购买完整的RAT使用许可证。

RAT的具体价格为$11,500/cpu ($230/NUP Named User Plus)，无论是产品还是测试数据库。

注意当从9iR2或10gR1升级到10gR2时，SPA要求使用在9iR2或10gR1的产品数据库上使用SQL TRACE功能以便捕获SQL语句。仅在此场景中，RAT license仅对测试系统有效而非产品系统。

SQL Performance Analyzer
Capture on 9i, 10.1, 10.2 database releases
Test changes in 10.2 & above
Database Replay
Capture on 9i, 10.2 database releases
Test changes in 11.1 & above