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 'PILOTReceived on Mon Jun 22 1998 - 05:42:17 CDT