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 -> sql_Trace and tkprof

sql_Trace and tkprof

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Mon, 22 Jun 1998 15:42:17 +0500
Message-ID: <358E3508.C403BBB4@cressoft.com.pk>


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.

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


Received on Mon Jun 22 1998 - 05:42:17 CDT

Original text of this message

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