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

brandon_oh_at_yahoo.com (Brandon) wrote in message news:<a03c2125.0205232302.361fb15e_at_posting.google.com>...
> Hi,
>
> Is it that all the Oracle generated trace file (*.trc) should end with
> something like the following sentence :
>
> A) 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

statistics are only dumped if the transaction is committed explicitly.

Hth
Sybrand Bakker
Senior Oracle DBA Received on Fri May 24 2002 - 06:19:59 CDT