Wait times are specified by “ela=” in the trace file. For example, the line where the wait time is specified can look something like…
WAIT #4951263987: nam='SQL*Net message from client' ela= 42664 driver id=1221361542 #bytes=1 p3=0 obj#=-1 tim=1364312166282185
OR
WAIT #0: nam='SQL*Net message from client' ela= 353686308 driver id=1284597568 #bytes=1 p3=0 obj#=87184 tim=1364312725750358
Usually, after the word WAIT indicates which cursor the wait belongs to, like in the first example above. However, WAIT #0 waits, like the second example above, are associated with transaction boundaries (commits/rollbacks). Those transactions are represented by the XCTEND lines. Toad collects these WAIT #0’s and when an XCTEND line comes along, the WAIT #0’s are associated with the statement immediately before the XCTEND.
The Wait Time listed in the main Trace File Browser window, for each statement, is the total of all the waits combined for that statement. If you want to see the individual wait times, you can view those in the Transaction Waits tab in the bottom section of the Trace File Browser window.
