Advertisement

SQL Monitoring and Tuning

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

Abstract

SQL is the language used to create, retrieve, update, and delete (CRUD) data from databases. If your SQL statements are slow, the whole system suffers. Whether you’re a developer or a DBA, effectively tuning SQL is a critical job requirement. When troubleshooting performance issues, you must know how to identify and tune resource-intensive queries.

Keywords

Execution Plan Trace File Access Path Full Table Oracle Database 
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

© Grant Allen, Bob Bryla, and Darl Kuhn 2009

Authors and Affiliations

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

There are no affiliations available

Personalised recommendations