As always with so many things, I struggled initially to understand the trace file. More often, I would generate a trace file and did not understand every aspect of the trace file. However with experience, I have figured what is written to the trace file and sharing my findings below.

When a trace is run for SQL statements, the resulting trace statement will have various parts. Here is the list along with the description.

First Part: n-xxxxx.

This is a sequential line counter for the process (exe). n is a integer starting from 1 to n. xxxxx is reserved for each line written to the trace file. If there is a second process, then it would be 2-xxxxx, for the third one it would be 3-xxxxx and so on.

Second Part: hh.mi.ss

It indicates the timestamp at which the trace line is written. This timestamp is retrieved from the machine in which PeopleTools is running.

Read Further:http://peoplesoftwiki.blogspot.com/2013/03/how-to-read-sql-trace-in...