Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trace file Anomolies
> Why is it that some SQL statements produce STAT lines in the trace
> output but others don't..?
STAT lines are generated when the cursor is closed (STAT means "STATistics" i believe). When testing, it is customary to exit the sqlplus session to make all the cursors close and so have the STATs dumped.
hth ...
Alberto Dell'Era
Received on Wed Nov 10 2004 - 14:21:28 CST