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 great information on Oracle 12c Adaptive Query Optimization, on Oracle’s Automatic SQL Tuning, and some queries to access Oracle’s 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 queries that can be tuned on most systems. A query can display ...