Oracle - Parameterized Query has EXECUTIONS = PARSE_CALLS
Posted
by Cory Grimster
on Stack Overflow
See other posts from Stack Overflow
or by Cory Grimster
Published on 2010-05-11T13:42:51Z
Indexed on
2010/05/11
13:44 UTC
Read the original article
Hit count: 358
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?
© Stack Overflow or respective owner