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

The STAT lines get printed to the trace data only when the cursor closes. This happens implicitly upon disconnect. Good (scalable) applications don't close their cursors or disconnect very often, so missing STAT lines can be common. You can reproduce what the STAT lines would have said by using explain plan, as long as there've been no intervening parameter, statistic, schema, SQL, etc. changes.

Cary

"Svend Jensen" <Svend_at_OracleCare.Com> wrote in message news:3CEE8C98.8010700_at_OracleCare.Com...
> Brandon wrote:
>
> > 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
> >
>
> A trace is only complete IF the tracing session disconnects/terminates.
> Else you risk missing information at "the end"
>
> /Svend Jensen
>
Received on Mon Jun 03 2002 - 01:14:54 CDT