O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19. Monitoring and Tuning

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.

A good developer must be familiar with query-tuning techniques. Ideally, developers will proactively evaluate queries for potential performance issues before they are deployed to production. In reality, bad SQL often makes it into production because it wasn't adequately tested, or the test environment does not accurately reflect the production environment (in terms of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required