Wednesday, May 9, 2007

Trace Analyzer : The Good Tool for Performance Monitoring

Just Came across one Good Performance Analysis Tool from Oracle.Itz Trace Analyzer.
Trace Analyzer is an Improved version of Oracle TKPROF.With Proper Layout and Format.
Trace Analyzer Utility download details are given in Metalink Note:224270.1

Download from the link and follow the steps given in the instruction.txt of the trca.zip file

Steps to Trace the Concurrent Request.

1).Enable the trace for the Concurrent Program using the following Navigation

Concurrent->Program->Define->'Program Name'

And check out the Enable Trace option

this will create the *trc file in udump directory

2)Once the Concurrent Request is completed look for the trace file with the name of request id

$ ls *requestid*

3).Login to sqlplus
SQL> conn apps/
SQL>set serverout on
SQL>exec trca$i.trace_analyzer('vis_ora_14328_SYSADMIN.trc');

Once the above procedure is completed it will create the html file the local Directory.

This file can be used for analysis of Performance.

No comments: