http://netvouz.com/MondoTofu/tag/testing?feed=rss MondoTofu's bookmarks tagged "testing" on Netvouz http://www.oracle.com/technetwork/database/manageability/sqlpa-094776.html 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 Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:36:49 GMT https://aws.amazon.com/blogs/database/testing-amazon-rds-for-oracle-plotting-latency-and-iops-for-oltp-io-pattern/ Plotting Latency and IOPS for OLTP I/O Pattern | AWS Database Blog Kevin Clossen SLOB AWS MondoTofu Thu, 19 Apr 2018 20:07:40 GMT http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126 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. Oracle > Recovery MondoTofu Sun, 30 Nov 2014 03:51:26 GMT