CHAPTER 8Query Tuning: Developer and Beginner DBA

This chapter will focus 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 10g Automatic SQL Tuning and some queries to access Oracle's 10g Automatic Workload Repository (AWR). There are examples of query tuning spread throughout this book as well as instructions to make them more effective in terms of the architecture of your system. This chapter will focus on some of the most common queries that can be tuned on most systems. There are several variations in behavior that can be displayed by a query, depending on the architecture of the system, the distribution of ...

Get Oracle Database 10g Performance Tuning Tips & Techniques now with O’Reilly online learning.

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