TKPROF: Release 8.1.6.0.0 - Production on Wed May 16 23:59:57 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Trace file: ora_855.trc
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing 
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************

select ename,job,hiredate,dname 
from
 emp e,dept d where e.deptno = d.deptno


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.04          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.01          0          2          8          14
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.00       0.05          0          2          8          14

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20  (SCOTT)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   MERGE JOIN
      0    SORT (JOIN)
      0     TABLE ACCESS (FULL) OF 'DEPT'
      0    SORT (JOIN)
      0     TABLE ACCESS (FULL) OF 'EMP'




********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.04          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.01          0          2          8          14
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.00       0.05          0          2          8          14

Misses in library cache during parse: 1


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        0      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0

    1  user  SQL statements in session.
    0  internal SQL statements in session.
    1  SQL statements in session.
    1  statement EXPLAINed in this session.
********************************************************************************
Trace file: ora_855.trc
Trace file compatibility: 8.00.04
Sort options: default

       1  session in tracefile.
       1  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       1  SQL statements in trace file.
       1  unique SQL statements in trace file.
       1  SQL statements EXPLAINed using schema:
           SCOTT.prof$plan_table
             Default table was used.
             Table was created.
             Table was dropped.
      26  lines in trace file.