- SQL Performance Analyzer Active Report
SQL Performance Analyzer (SPA), a key feature of the Real Application Testing option introduced in Oracle Database 11g, can predict and quantify SQL performance improvements and regressions caused by system changes such as upgrading a database, adding new indexes, changing database parameters, collecting optimizer statistics, etc. SQL Performance Analyzer provides a granular view of the impact of changes on SQL execution plans and execution statistics by running the SQL statements on a production or test system in isolation before and after a change. SPA compares the SQL execution result, before and after the change, and generates a report outlining the net benefit on the SQL workload due the change as well as the set of regressed SQL statements. For regres
in Oracle > DB 11g with 11g analyzer application database oracle performance predict real sql testing
- Testing Amazon RDS for Oracle
Plotting Latency and IOPS for OLTP I/O Pattern | AWS Database Blog Kevin Clossen SLOB
in AWS with aws database io iops latency slob testing
- DUPLICATE database with RMAN
duplicate database, which is a copy of the source database (or a subset of the source database) with a unique DBID. Because a duplicate database has a unique DBID, it is independent of the source database and can be registered in the same recovery catalog. Typically, duplicate databases are used for testing.
in Oracle > Recovery with database databases dbid duplicate recovery rman testing
testing from all users