In the first example, the cursor handle (3) you refererence is reused w/out the STAT lines being emitted. In the second, it does emit STAT lines. Rajesh.Rao@xxxxxxxxxxxx wrote: >I thought I did see the stat lines, albeit its all clubbed together at the >end. Like for your first SQL, the one selecting from mystat with rownum=1. >Isnt the first stat line (the one with the STOPKEY) for this query. > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------