19. Using SQLT to Boost Query Performance
Oracle DBAs can be divided into two broad groups: those of us who are lucky enough to have installed, configured, and leveraged the SQLT utility to help improve SQL query performance and those of us who have never even heard of the SQLT utility. Carlos Sierra created SQLT while working for Oracle many years ago, well before many of today’s Oracle database performance analysis tools that are built into more current versions of the database kernel—SQL Tuning Advisor, SQL Access Advisor, SQL Performance Analyzer, and SQL Monitor—even existed.
Because it focuses on the best practices for tuning SQL statements effectively and with minimum effort, SQLT is also a great introduction for a “newbie” DBA to learn ...
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.
