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