| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> sql_Trace and tkprof
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
![]() |
![]() |