TKPROF Parse/Execute count

From: obiru <boogab00_at_yahoo.com>
Date: 28 May 2004 12:05:23 -0700
Message-ID: <32948959.0405281105.11220953@posting.google.com>

Obviously there's something I don't understand about parsing. The following is a tkprof excerpt from a trace I did on my own sql*plus session. I just entered the query once, and ran it 11 times by entering "/" and hitting return. Does anyone know why I had 11 parses and 11 executes?

select count(*)
from
dba_tables

call     count       cpu    elapsed       disk      query    current  
     rows

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

Parse       11      0.04       0.04          0          3          0  
        0
Execute     11      0.00       0.00          0          0          0  
        0
Fetch       22      1.64       1.80         11     194975         44  
       11

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

total       44      1.68       1.84         11     194978         44  
       11

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 5 Received on Fri May 28 2004 - 14:05:23 CDT