CHAPTER
3
SQL Tuning Sets and Tuning Advisor
Prior to Oracle Database 10g, tuning SQL statements was a complex, repetitive, and time-consuming activity for DBAs. Beginning with version 10g, Oracle Database has included several performance management tools and Advisors that help automate performance management and tuning. Oracle Database includes several Advisors, each one analyzing a specific database aspect and providing specific recommendations.
SQL Tuning Advisor is one of these Advisors; SQL Tuning Advisor helps the DBA resolve problems related to suboptimally performing SQL statements and offers recommendations for improving performance ...
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.
