Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trace file Anomolies

Re: Trace file Anomolies

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: 10 Nov 2004 12:21:28 -0800
Message-ID: <4ef2fbf5.0411101221.145b5bbf@posting.google.com> 





> 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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US