TKPROF interpreting help

From: Andrey Bronfin <Andreyb_at_maxbill.com>
Date: Sun, 24 Jun 2001 03:49:57 -0700
Message-ID: <F001.0033596B.20010624034520@fatcity.com>

Dear list !

I'm pretty confused with the following : i opened an SQL*Plus session and reran exactly THE SAME query several times . I expected to see one Parse , one Execute and several Fetches in the TKPROF report.

I was shocked to see the following in the YKPROF report :

---

select ENTITYTYPE from ZENTITYTYPEATTRIBUTE where ENTITYTYPE < 2

call     count       cpu    elapsed       disk      query    current        rows

------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse       18      0.00       0.00          1          0          1           0
Execute     18      0.00       0.00          0          0          0           0
Fetch       36      0.00       0.00          1         36          0         234

------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       72      0.00       0.00          2         36          1         234

Misses in library cache during parse: 1
Optimizer goal: CHOOSE

---

That means that each time i reran EXCATLY the same query , there was a Parse , an Execute and 2 Fetches !!!!!! Why ?
(It's Oracle 8.1.5 on Solaris ) .

Thanks in advance ! Received on Sun Jun 24 2001 - 05:49:57 CDT