Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL_TRACE Question
In this case i'm interested in the meaning of the column current. We could
never interprete a meaningfull value to it.
Thank you.
Andreas Prusch
In article <357a5994.5988050_at_192.86.155.100>,
tkyte_at_us.oracle.com wrote:
>
> A copy of this was sent to Umar FArooq <umar.farooq_at_cressoft.com.pk>
> (if that email address didn't require changing)
> On Sat, 06 Jun 1998 15:51:20 +0500, you wrote:
>
> >Im currently working on SQL_TRACE. I view the .trc file using tkprof. In
> >the output file the number of rows is indicated for each
> >parse/fetch/execute operation. What does teh row column signify? How is
> >it different from the row count indicated alongside each execution step
> >in the explain plan statistics.
> >
> >Thx.
> >
> >Umar.
>
> consider:
>
> ==========================================================================
> select *
> from
> emp, dept
>
> call count cpu elapsed disk query current
rows
> ------- ------ -------- ---------- ---------- ---------- ----------
2 056
> Execute 1 0.00 0.00 0 0
0 0
> Fetch 5 0.00 0.00 2 12 15
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 08 1998 - 02:45:15 CDT