Advertisement

Automated SQL Tuning

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

Abstract

Prior to Oracle Database 11g, accurately identifying poorly performing SQL queries and recommending solutions was mainly the purview of veteran SQL tuners. Typically one had to know how to identify high-resource SQL statements and bottlenecks, generate and interpret execution plans, extract data from the dynamic performance views, understand wait events and statistics, and then collate this knowledge to produce good SQL queries. As you’ll see in this chapter, the Oracle SQL tuning paradigm has shifted a bit.

Keywords

Enterprise Manager Sample Output Execution Plan Single Quote Staging Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati, Darl Kuhn, and Bill Padfield 2011

Authors and Affiliations

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

There are no affiliations available

Personalised recommendations