Tuesday, December 25, 2012

Trace Analyzer, also known as TRCANLZR or TRCA,



From the below note-id download the trace Analyzer.

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces [ID 224270.1]

Unzip the trca on db node:
Install the trace Analyzer : follow the installation doc in the trca directory

Run trace Analyzer:

$cd /home/oracrp/trca/run
login as apps user
sql > start trcanlzr.sql CRP2_ora_29564.trc

provide the trace file to be analyzed as given above
once the trace analyzer is completed you will get the trca_*.zip file in the same directory.

No comments:

Post a Comment