http://netvouz.com/MondoTofu/tag/predict?feed=rss MondoTofu's bookmarks tagged "predict" 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