tkprof question - parse counts

Hi,

    I have an interesting problem regarding parse counts in tkprof. One process makes a query several times and uses a host variable as in where field1 = :1. It has a count of 1 for the parse and 200 for the execute and fetch. A different process makes the exact same type of query to a different table. It has a count of 200 for the parse, execute, and fetch. What would cause the one process to parse only once and the other process to parse 200 times when the query is essentially the same?

Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com Received on Wed Oct 11 2000 - 12:08:36 CDT