12. Leveraging SQL Advisors to Analyze and Fix SQL Problems

SQL issues formulate the major chunk of an Oracle professional’s troubleshooting activity. Hardly a day goes by in the professional life of an Oracle DBA that SQL issues don’t present a hardy challenge. With the sophistication of technology and the rapid advancement of subsequent versions loaded with new features, an advanced-level Swiss-knife toolset is required to address these issues. Oracle has come a long way in responding to the complex challenge of analyzing, troubleshooting, and fixing various SQL issues with a broad suite of SQL Advisors to address a wide spectrum of problem scenarios.

This chapter’s pointed focus is on the SQL Tuning Advisor—the standard tool of choice for ...

Get Oracle Database Problem Solving and Troubleshooting Handbook now with O’Reilly online learning.

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