Search tips
  • 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