SQL - High Parses

 

Hi,

 

In one of our 10.2.0.4 databases, AWR section related to “SQL ordered by Parse Calls” is showing one of the SQLs to be parsed 34,755 times (as below)

SQL ordered by Parse Calls

• Total Parse Calls: 610,409
• Captured SQL account for 49.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
34,755	34,755	5.69	0h6b2sajwb74n		select privilege#, level from ...
22,094	22,094	3.62	asgnsmjcfxxvc	JDBC Thin Client	SELECT DATE_UPDATED, TIME_UPD..

But looking at the code, we can see that the code is using bind variables (see below)

asgnsmjcfxxvc

 SELECT DATE_UPDATED, TIME_UPDATED, TIME_TRACING_SHIPMENT, CUST_NO, DATE_TRACING_SHIPMENT, TIME_ZONE, MODIFIED_BY, TRACING_DATE_NO, FILE_NO FROM SHIPMENT_DATES WHERE ((TRACING_DATE_NO = :1 ) AND (FILE_NO = :2 ))