Thursday, February 28, 2008

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:


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