O'Reilly logo

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

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

Images

CHAPTER

8

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 ...

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