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.
[url=http://www.oraclepoint.com]SU8PubUNrOraclePoint0tubvL28A[/url]
Note: Activating event 10046 as following:
alter session set events '10046 trace name context forever, level num'; [url=http://www.oraclepoint.com]HX0iGmfCaOraclePointR4aHMvFbg[/url]
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.
[url=http://www.oraclepoint.com]gwtOvc9MNOraclePointKELKMjJvp[/url]
Report generated includes: - response time components,
- db call summaries;
[url=http://www.oraclepoint.com]vQrMilmqxOraclePointYvP5SBngw[/url]
- list of top SQL according to response time;
- SQL genealogy with recursive dependencies;
- segment i/o wait summaries;
[url=http://www.oraclepoint.com]Gf0UpEfzQOraclePointE0BuuSb81[/url]
- hot blocks;
- gaps of no tracing activity;
- transaction summary;
- non-default initialization parameters;
[url=http://www.oraclepoint.com]Ckg19SF3kOraclePointGgG4nm48R[/url]
- row source plans;
- explain plans;
- tables and indexes referenced by explain plans;
[url=http://www.oraclepoint.com]8dHOiGPS2OraclePointhtyYwY6nW[/url]
- indexed columns;
- CBO statistics for tables, indexes and their columns;
- bind variables used by relevant SQL;
[url=http://www.oraclepoint.com]NsPxzw5tZOraclePointgmXyk17yY[/url]
- time analysis for SQL itself and their progeny;
- list and details of relevant executions for top SQL.
Installation Guide: [url=http://www.oraclepoint.com]DEq5matANOraclePointI61fJju7Y[/url]
# cd trca/install
# sqlplus /nolog
SQL> connect / as sysdba
[url=http://www.oraclepoint.com]h2I7YvTMWOraclePointKJKiMPPH2[/url]
SQL> start tacreate.sql
Source of Trace Analyzer: Oracle Metalink Note: 224270.1
[url=http://www.oraclepoint.com]p1339yse8OraclePointSO5rvvzsJ[/url]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0 to 11.1
[url=http://www.oraclepoint.com]lCW8MgHusOraclePointX01OprGhq[/url]
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.
[url=http://www.oraclepoint.com]6QK3jZwQKOraclePointiF4rq6EnI[/url]
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]kv4TI3KXiOraclePoint2eGhZXrR7[/url]
[url=http://www.oraclepoint.com]GEMRmSLU9OraclePointHYmP0YITh[/url]