The #n on each line in the trace file indicates which cursor the operation or
wait was associated with. For example, you may see lines like this:

    WAIT #9: nam='db file sequential read' ela= 1 p1=1 p2=1353 p3=1
    EXEC #5:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=181493245
    WAIT #5: nam='db file sequential read' ela= 1 p1=1 p2=206 p3=1

The first wait is associated with executing cursor number 9, and the second is
associated with executing cursor number 5. To find the SQL statements that are
being executed in these cursors you need to search backwards in the trace file
for the previous line beginning with PARSING IN CURSOR #n.


-----Original Message-----
Sent: Saturday, 26 August 2000 0:33


The first column in the trace file is WAIT #1.  What does it mean?