hi,

i see an sql query "select * from table where sr='1020' " appearing number of times in v$sql and increasing continuously.

This sql is being requested by a web applicaton.

possible things i can think about is to let web application request for a procedure instead of a direct sql query with those literals.

Is this approach is the right way ??? Plz suggest...


thanx
Jr.