Toad Tips and Tricks are a collection of suggestions, insights and how-tos from our in-house experts as well as Toad users from around the world. Do you have a tip you'd like to share? Submit your tip.
Posted by: Dan Hotka TOAD is a useful tool for finding and tuning SQL statements. This tech tip will focus only on the explain plan from the SQL Editor window. Quest Software has a SQL Tuner environment available to TOAD. The DBA module of TOAD also has a Stats Pack and an AWR viewer built in. Trace files can easily be viewed using the TKProf Interface and the session browser allows for trace to be started/stopped, view current SQL and all open cursors, locking situations involving a particular user, and more.
PDF file, 143 KB
