trcsess utility

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

trcsess  [output=output_file_name]
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 - Production on Thu Feb 28 13:38:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.

for more information:


  1. trcsess is very useful. Is there a 9i version ?

  2. It seems that 9i trace files can be used with 10g trcsess utility


Post a Comment

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

List RMAN backups size

AWR Generating & Setting