Re: sql_Trace and tkprof

Thomas Kyte wrote:

> platform?
> version?
> how are you doing the tracing...
> etc, etc, etc?

Oracle 7.3.2 on UNIX

> If you are doing something like:
>
> SQL> alter session set sql_trace=true;
> SQL> select count(*) from emp;
> SQL> alter session set sql_trace=false;
>

I dont set sql_trace to false

> You'll get rowcounts of zero (using sql_trace=false) since the row
> counts are
> not written to the trace file until the cursor is CLOSED and sqlplus
> doesn't
> close the cursors right away. By doing the sql_trace=false, you've
> closed the
> trace file before the cursor data was traced.
>
> >
Received on Mon Jun 22 1998 - 08:21:32 CDT