Reparsing using OCI calls

Reparsing on OCI calls.

An Oracle SE claimed that making an OCI parse call ALWAYS does a parse, in other words, the shared SQL pool is not visited. However, using ESQL, the compiler is "smarter" and reuses the shared pool when it can.

The question is, Is there a way when using OCI, to reuse the SQL statements in the shared pool to avoid reparsing each time.

Also, tkprof trace results always show (using an OCI application) that the number of parse and execution statements are always twice the actual amount. Is this a bug or a feature?

Thanks in advance,

--Troy

Keywords:

-- 
Troy Schumaker
dbINTELLECT Technologies
(303) 763-3821  troy_at_dbintellect.com