Re: TKPROF Output Explanation

There are some front-end tools that
generate code to pre-parse SQL so
that they can build the appropriate
memory structure for the anticipated
data.

In most cases, these reveal themselves
with tkprof outputs that show two
parses per execute.

Perhaps you have a slightly more extreme case where some such tool has pre-parsed everything in a module 'just in case', but just doesn't happen to use some specific piece of SQL to collect data.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated March 9th 2005






"Dusan Bolek" <spambin_at_seznam.cz> wrote in message 
news:1111480720.656757.245060_at_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.

>