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

Filed under:
|
|
|

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

Related posts about Oracle

Related posts about oracle10g