Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

TKPROF output - couple of questions

 
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center