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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.