How do we stop statement from parsing everytime, it over 200,000,000 parses
We have following issue with excessive parses. We have 20 windows COM+ components that every 60 secs. query Oracle for work. They send the following statement
SELECT JOB_ID,WORKORDER_ID FROM JOB WHERE TRY_COUNT >= 1 AND SUCCEEDED = 0 AND WORKSERVER_NAME IS NULL for update
(we are looking for work to do, if the worksever field is null and it has tried more than once we want it)
The problem we are having is that it appers that the statement is being parse everytime we send it. The big problem with that is that to date we have done it over 200,000,000 times
the following (via TOAD) executions 210,000,000 parse call 209,890,000. Why are we parsing it almost every single time. I understand the issue of bind variables, etc, but the statement is static same every single time.
Is there a way to have it not parse at much??