Images

CHAPTER

4

SQL Access Advisor

In this chapter, you’ll learn about the Oracle SQL Access Advisor, which is useful when you need to analyze how an object is being accessed and how to improve that access path to reduce the optimizer cost.

Oracle SQL Access Advisor, introduced in Oracle Database 10g, receives a real or hypothetical workload as input and then analyzes how each object involved in each SQL statement is being accessed. It uses Automatic Tuning Optimizer to perform the analysis of several hypothetical improvements and calculates the resulting optimizer cost of each improvement. It lists all improvements that offer considerable benefits ...

Get Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability now with O’Reilly online learning.

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