Search This Blog

Tuesday, February 21, 2012

read trace file

SQL>show parameter background dump dest;

In OS prompt, go to the location.
you will find .trc and .trm files which are not in human readable format. To read the trace file, do the following.

$tkprof .trc filename

The output file will be created with .prf

open the .prf file using more or tail command.

No comments:

Post a Comment