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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment