Tools and Utilities - Expert Oracle RAC Performance Diagnostics and Tuning - page 176

Figure 6-22. Monitored SQL
• SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR when a session is active
Another flavor of this report is to generate this when the session is active using
SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR(type=>'active') FROM DUAL;
SQLt
sQlt is a compressive tool/script that will help diagnose why a specific sQl statement may be performing poorly.
it takes a single sQl statement (or sQl_id) as input and outputs a set of diagnostics that can be used to improve
the statement's performance.
sQlt provides large amounts of information on a wide range of topics pertinent to that sQl including execution
plans, cost-based optimizer CBo statistics, schema objects metadata, performance statistics, configuration
parameters, and other elements that influence the performance of the one sQl being analyzed.
the tool and the install guides can be downloaded from Metalink Mos #215187.1
sQlt provides several methods of information extraction. table 6-6 lists the various methods, scripts, and their
description.