Previous installment: Day One: Do What You Do Do Well
Next Installment: Day Three: Just a Mess Without a Clue

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep.

—Stopping by Woods on a Snowy Evening by Robert Frost

SQLT adoption has been limited even though it is the best tool for investigating SQL performance.

  • It is only available as a download from Oracle Support. It is not available as a download from OTN. Ideally, it should be distributed together with the Oracle software and be part of every ORACLE_HOME (like Statspack).
  • It creates tables and PL/SQL procedures in the database. This is a serious roadblock in production environments. There is a stripped-down version called “SQL Health Check” (SQLHC) but it only captures a very small subset of the information captured by SQLT.
  • It does not support Statspack, only AWR.  I don’t have know what percentage of Oracle customers have licensed the Diagnostics Pack (required to use AWR) but, Paul Vallée, the founder of Pythian said in 2007:  “I tried to determine the exact number of Pythian clients that are licensees of the Diagnostic Pack, and to the best of my abilities the number is two. Out of 70. And while it _may_ be a UK/USA thing, there really are some big customers in that list so I don’t think it’s a simple big shop small shop issue.” (http://oracledoug.com/serendipity/index.php?/archives/1289-AWR-Licensing.html).

P.S. Mauro Pagano has released a freely-available tool called sqld360 which does not create objects in the database.

The Twelve Days of SQL

The Twelve Days of NoSQL

Copyright © 2015 Iggy Fernandez