From: toto@united_kingdom.co.uk   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)