Query Tuning: Developer and Beginner DBA
This chapter focuses on specific queries that you may encounter and some general information for tuning those specific queries, but it has also been updated to include some basic information on Oracle’s 11g Automatic SQL Tuning and some queries to access Oracle’s 11g Automatic Workload Repository (AWR). Examples of query tuning are spread throughout this book as well as instructions on making them more effective in terms of your system’s architecture. This chapter centers on some of the most common ...

Get Oracle Database 11g Release 2 Performance Tuning Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.