Re: sql_Trace and tkprof

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 22 Jun 1998 12:50:35 GMT
Message-ID: <359152a4.2425317@192.86.155.100>

A copy of this was sent to Umar FArooq <umar.farooq_at_cressoft.com.pk> (if that email address didn't require changing) On Mon, 22 Jun 1998 15:42:17 +0500, you wrote:

>Hi!
>I executed tkprof to check the sql_trace stats but i got a zero row
>count against each step of the execution plan. The query returns 93
>rows. Can anyone tell me why is there a zero row count?
>
>Thx.
>
>Umar Farooq Ch.
>

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

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;

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.

>
>
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 121 (NWDB)
>
>Rows Execution Plan
>------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 0 HASH JOIN
> 0 TABLE ACCESS (FULL) OF 'PERMANENT_POSITION_AWARD'
> 0 HASH JOIN
> 0 TABLE ACCESS (FULL) OF 'PILOT_PREFERENCE'
> 0 HASH JOIN
> 0 TABLE ACCESS (FULL) OF 'PILOT_TEMP_PREFERENCE'
> 0 TABLE ACCESS (FULL) OF 'PILOT
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 22 1998 - 07:50:35 CDT