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.