Is it that all Oracle Trace file should end with the following text?

From: Brandon <brandon_oh_at_yahoo.com>
Date: 24 May 2002 00:02:21 -0700
Message-ID: <a03c2125.0205232302.361fb15e@posting.google.com>

Hi,

Is it that all the Oracle generated trace file (*.trc) should end with something like the following sentence :

1. STAT #1 id=1 cnt=1 pid=0 pos=0 obj=2103 op='TABLE ACCESS BY ROWID RAW_RECORD_STATUS'

   STAT #1 id=2 cnt=2 pid=1 pos=1 obj=2220 op='INDEX RANGE SCAN '

In other words, is it that the trace file should be ended with the "STAT" words??

If i have the following ending sentences for the trace file, as shown below, am i right to say that the oracle process has not finish it's operation which cause no "STAT" words there ??

For example :

B) FETCH #1:c=0,e=0,p=0,cr=1,cu=2,mis=0,r=1,dep=0,og=4,tim=69645325

   EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=69645325
   EXEC #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=69645326
   EXEC #4:c=0,e=0,p=0,cr=0,cu=0,mis=0

C) FETCH #12:c=0,e=0,p=0,cr=1,cu=2,mis=0,r=1,dep=2,og=4,tim=69645691

   EXEC #11:c=0,e=0,p=0,cr=1,cu=2,mis=0,r=1,dep=1,og=4,tim=69645691
   FETCH #2:c=0,e=0,p=0,cr=3,cu=6,mis=0,r=1,dep=0,og=4,tim=69645691
   EXEC #14:c=1,e=0,p=0,cr=181,cu=1,mis=0,r=1,dep=1,og=4,tim=696

Is there a problem with the oracle if the trace file ends with something like option (A) and (B).

Thanks for enlightening me : )

rgds,
Brandon Received on Fri May 24 2002 - 02:02:21 CDT