Performing Through Changes

Nanda, Arup “Perform Through Changes” Oracle Magazine Mar/Apr 2008:n.pag, Retrieved 02/26/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-mar/o28sqlperf-101752.html Performing Through Changes TECHNOLOGY: Testing Performing Through Changes By Arup Nanda Measure the impact of changes on SQL workload with SQL performance analyzer. Here is a not-so-uncommon scenario: a query is running slowly. Upon investigation, you determine the reason to be a [...]

Baselines And Better Plans

Nanda, Arup.” Baselines And Better Plans” Oracle Magazine.Mar/Apr 2009:n-pag. Retrieved 02/24/2014 from http://www.oracle.com/technetwork/issue-archive/2009/09-mar/o29spm-092092.html Baselines_And_Better_Plans TECHNOLOGY: SQL Baselines and Better Plans By Arup Nanda Use SQL plan management in Oracle Database 11g to optimize execution plans. Have you ever been in a situation in which some database queries that used to behave well suddenly started performing [...]

On Tuning, Planning, and Contexts

Kyte, Tom. “On Tuning, Planning, and Contexts” Oracle Magazine. March/April 2011:n.page; Retrieved02/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21asktom-312223.html on_tuning_planning_and_contexts TECHNOLOGY: Ask Tom On Tuning, Planning, and Contexts By Tom Kyte Our technologist tunes data models, plans for partitions, and puts SQL in context. I have a query that is not very complex but is executed very often. All the [...]