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

More New PL/SQL Features

Jagannath, Sushma” More New PL/SQL Features” Oracle Magazine. May/Jun 2009:n-pag, Retrieved from http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39ocp-087552.html More_New_PLSQL_Features More New PL/SQL Features By Sushma Jagannath Improve performance in Oracle Database 11g with new PL/SQL features. Oracle Database 11g introduced several new PL/SQL features and tools that help you improve application performance. Continuing the discussion of new PL/SQL features from [...]

Wrap Your Code in a Neat Package

 Feuerstein, Steven. “Wrap Your Code in a Neat Package” Oracle Magazine. January/February 2013: n.pag, Retrieved 2/12/13 from  http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13plsql-1872456.html Wrap_Your_Code_In_a_Neat_Package TECHNOLOGY: PL/SQL  Wrap Your Code in a Neat Package By Steven Feuerstein Part 11 in a series of articles on understanding and using PL/SQL Most PL/SQL-based applications consist of hundreds of thousands of lines of code—and many [...]

Optimizing Performance by Identifying Problem SQL

Robin Schumacher. “Optimizing Performance by Identifying Problem SQL” SELECT Journal  (3rd Qtr. 2004): 31-37. Optimizing Performance by Identifying Problem SQL OVERVIEW As a DBA, you need to have the right game plan in place for finding and fixing problem SQL code in your database. Fortunately, Oracle is better than most DBMSs at providing information in [...]

Oracle Performance Tuning: A Systematic Approach

Harrison, Guy (2007).  Oracle Performance Tuning:  A Systematic Approach.  Retrieved 8/27/12, from http://guyharrison.typepad.com: http://guyharrison.typepad.com/SystematicOracletuning.pdf Oracle Performance Tuning a Systematic Approach OVERVIEW A mission critical application system is experiencing unsatisfactory performance. As an experienced Oracle performance specialist, you are called in to diagnose the problem. You’re well versed in modern wait-based performance profiling oriented performance diagnostics [...]