Home -> Usenet -> comp.databases.oracle -> Difficulty to interpret a TKPROF output

Difficulty to interpret a TKPROF output

From: toto4UK <toto_at_united_kingdom.co.uk>
Date: Fri, 26 Sep 2003 15:08:24 +0200
Message-ID: <bl1dev$2221_at_news.rd.francetelecom.fr> 






Hello,



One of my queries running with Oracle 8.1.7.4 on a SPARC machine with SunOS
5.8 has been


traced and TKPROF gave me the following result for PEF stats :



Need to say that query is a simple SELECT statement using a WHERE clause
parametrized with bind vars


given to Oracle through JDBC Thin Driver



call     count       cpu    elapsed       disk      query    current
rows


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






Parse      590      0.23       0.23          0          0          0
0


Execute    590      0.30       0.29          0          0          0
0


Fetch      590      0.37       0.35          0       1154       4616
544


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






total     1770      0.90       0.87          0       1154       4616
544



Misses in library cache during parse: 1


Optimizer goal: CHOOSE



I wanted to know why that query has so many parses.



Thanx for answers.



Sebastian.
Received on Fri Sep 26 2003 - 15:08:24 CEST












Original text of this message