TKPROF Output Explanation

From: Dusan Bolek <spambin_at_seznam.cz>
Date: 22 Mar 2005 00:38:40 -0800
Message-ID: <1111480720.656757.245060@o13g2000cwo.googlegroups.com>

Hello,

I'm trying to interpret SQL traces generated by users. There is about 120MB of them in more than thousand of files so it is not possible to process them in raw format. So I have used TKPROF instead of it. The reason why I'm doing this is to prepare as much as possible authentic test scenario representing a real production load. However, I have problem how to interpret numbers like this:

call count cpu elapsed disk query current

rows
------- ------ -------- ---------- ---------- ---------- ----------

Parse     1105      0.05       0.09          0        106          0
       0
Execute      0      0.00       0.00          0          0          0
       0
Fetch        0      0.00       0.00          0          0          0
       0

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

total     1105      0.05       0.09          0        106          0
       0

How it can happen that some statement was parsed many times without *ANY* actual executions (never used cursor?) and how it is possible to represent this in a simple test case?

--

Dusan Bolek
http://www.db-support.com

Email: spambin_at_seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email will face an unpleasant end as SPAM. Received on Tue Mar 22 2005 - 02:38:40 CST