Oracle - Parameterized Query has EXECUTIONS = PARSE_CALLS
- by Cory Grimster
We have a .NET application talking to Oracle 10g. Our DBA recently pulled a list of queries where executions is equal to parse_calls. We assumed that this would help us find all of the unparameterized queries in our code.
Unexpectedly, the following query showed up near the top of this list, with 1,436,169 executions and 1,436,151 parses:
SELECT bar.foocolumn
FROM bartable bar,
baztable baz
WHERE bar.some_id = :someId
AND baz.another_id = :anotherId
AND baz.some_date BETWEEN bar.start_date AND (nvl(bar.end_date, baz.some_date + (1/84600)) - (1/84600))
Why is executions equal to parse_calls for this query?