Skip to Main Content
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
book

Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

by Sam R. Alapati, Darl Kuhn, Bill Padfield
August 2011
Intermediate to advanced content levelIntermediate to advanced
594 pages
15h 54m
English
Apress
Content preview from Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

C H A P T E R  9

Manually Tuning SQL

It has been said many times in books, articles, and other publications that over 90% of all performance problems on a database are due to poorly written SQL. Often, database administrators are given the task of “fixing the database” when queries are not performing adequately. The database administrator is often guilty before proven innocent—and often has the task of proving that a performance problem is not the database itself, but rather, simply, SQL statements that are not written efficiently. The goal, of course, is to have SQL statements written efficiently the first time. This chapter's focus is to help monitor and analyze existing queries to help show why they may be underperforming, as well as show ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

Darl Kuhn, Sam Alapati, Arup Nanda

Publisher Resources

ISBN: 9781430236627Purchase book