trcsess utility

The trcsess utility consolidates trace output from selected trace files based on several criteria:

trcsess  [output=output_file_name]
         [session=session_id]
         [clientid=client_id]
         [service=service_name]
         [action=action_name]
         [module=module_name]
         [trace_files]
trcsess output=main.trc service=psdwh *trc

After the consolidate trace file had been generated you can execute tkprof on it.
For example:
tkprof main.trc main.prf sys=no sort=exeela
TKPROF: Release 10.2.0.3.0 - Production on Thu Feb 28 13:38:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.

for more information:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm

Comments

Anonymous said…
trcsess is very useful. Is there a 9i version ?
Yossi Nixon said…
It seems that 9i trace files can be used with 10g trcsess utility

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP