TKPROF output - couple of questions
edited Oct 20, 2018 8:04AM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 5 commentsAnswered
Hi
We have a couple of questions on TKPROF results against one of our queries
Here is the output of TKPROF
SELECT DATE_UPDATED, TIME_UPDATED, TIME_TRACING_SHIPMENT, CUST_NO,
DATE_TRACING_SHIPMENT, TIME_ZONE, MODIFIED_BY, TRACING_DATE_NO, FILE_NO
FROM
SHIP_DATES WHERE ((TRACING_DATE_NO = :1 ) AND (FILE_NO = :2 ))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 8937 0.07 0.06 0 0 0 0
Execute 8937 0.78 0.79 0 0 0 0
Fetch 8937 0.10 0.10 0 20089 0 2215
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 26811 0.96 0.96 0 20089 0 2215
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: FIRST_ROWS
Rows Row Source Operation
0