Beginning Performance Tuning: Diagnose the Past

http://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62dba-1741123.html Nanda, Arup. “Beginning Performance Tuning: Diagnose the Past” Oracle Magazine. Nov/Dec 2012: n.pag, Retrieved 9/18/13 from http://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62dba-1741123.html TECHNOLOGY: Tuning Beginning Performance Tuning: Diagnose the Past By Arup Nanda Oracle ACE Director TECHNOLOGY: Tuning Beginning Performance Tuning: Diagnose the Past By Arup Nanda Oracle ACE Director Take the next step in diagnosing Oracle Database performance [...]

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 [...]

Managing Database Resources

Jagannath, Sushma. ”Managing Database Resources”Oracle Magazine.Jan.Feb 2009:n.pag,Retrieved 02/15/20013 from http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19ocp-090244.html Managing_Database_Resources TECHNOLOGY: OCP Managing Database Resources By Sushma Jagannath New features in Oracle Database 11g help you assess performance and limit I/O usage. The database resource manager prioritizes and manages the distribution of resources among database sessions, by controlling the execution schedule inside Oracle Database. In [...]

Beginning Performance Tuning

Nanda, Arup.” Beginning Performance Tuning” Oracle Magazine. July.2012:n.pag. Retrieved 02-09-2013 from http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42dba-1566567.html Beginning_Performance_Tuning TECHNOLOGY: Tuning Beginning Performance Tuning By Arup Nanda Resolve session performance issues in Oracle Database. It’s the middle of the night, and you get a frantic call from someone complaining that the database is slow. The caller demands to know why—and what [...]