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

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