Trace Analyzer is a tool which reads and parses on eor several SQL traces generated by SQL Trace or by event 10046 at any level (1, 4, 8 or 12) and produces a comprehensive report with performance related details.

Note: Activating event 10046 as following:
alter session set events '10046 trace name context forever, level num';
          Where num is either 1,4,8 or 12, with 1 being the same as a normal set sql_trace=true, 4 including values of bind variables, 8 including
          wait events, and 12 including both bind variables and wait events.

Report generated includes:

• response time components,
  
• db call summaries;
  [url=http://www.oraclepoint.com]k9G7qYoGYOraclePointled1303x6[/url]
  
  
• list of top SQL according to response time;
  
• SQL genealogy with recursive dependencies;
  
• segment i/o wait summaries;
  [url=http://www.oraclepoint.com]BhaWvylJUOraclePointpL0Pw8Wtn[/url]
  
  
• hot blocks;
• gaps of no tracing activity;
  
• transaction summary;
  
• non-default initialization parameters;
  [url=http://www.oraclepoint.com]uXuJ0On1HOraclePointns5jtb0FN[/url]
  
  
• row source plans;
  
• explain plans;
  
• tables and indexes referenced by explain plans;
  [url=http://www.oraclepoint.com]xrWIXiHnUOraclePointE0Dsubc5b[/url]
  
  
• indexed columns;
  
• CBO statistics for tables, indexes and their columns;
  
• bind variables used by relevant SQL;
  [url=http://www.oraclepoint.com]riRyLAsutOraclePointKuzXihtr6[/url]
  
  
• time analysis for SQL itself and their progeny;
  
• list and details of relevant executions for top SQL.

Installation Guide:

   # cd trca/install
   # sqlplus /nolog
   SQL> connect / as sysdba
   SQL> start tacreate.sql

Source of Trace Analyzer: Oracle Metalink Note: 224270.1

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0 to 11.1
OSS Support Tools - Version: 9.2.0 to 11.1
Oracle Application Object Library - Version: 11.5.5 to 12.0
Information in this document applies to any platform.

Note: Trace Analyzer is highly recommended to be installed when use XECUTE method (SQLTXPLAIN), but not mandatory. If installed, XECUTE report consists more statistics details, such of "segemnt statistics".

[url=http://www.oraclepoint.com]x5Nfp5VqKOraclePointvxBslPG9W[/url]