Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High parse calls

user12180928Oct 22 2010 — edited Oct 25 2010

Hi,

The Workload Repository report for 1 hour period says that the following sql had Parse Calls = Executions = 11,223:

SELECT CODLOC FROM R016HIE WHERE NUMLOC=:NumLoc AND DATINI <= :DatIni AND DATFIM >= :DatFim

Can anyone explain why is it so, since the sql is using bind variables and the instance has 30% free shared pool space? Why Oracle is parsing the sql before every execution? Why is it not reusing the parse information?
Thanks,

Ezio.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2010

Added on Oct 22 2010

#general-database-discussions

5 comments

889 views