SQL Query Result Set Cache in 11.2.0.3
Hi,
We are upgrading one of our 10.2.0.4 database to 11.2.0.3
As part of the upgrade, we are planning to utlize the 11g SQL Query Result Caching feature
we have multiple queries which uses bind varaibles and due to the nature of the application using "HINTS"
is not an option. Below is an example of the kind of queries that the application submits to the database
select DTS, TRS, DATE_UPD, TIME_UPD, MOD_BY
from SHDAT
where SHDAT.FILENO=:E3 and SHDAT.TRD_NO=:E2 and SHDAT.DTS>:E1
The value of the either one or ALL of the 3 bind varaibles (E1,E2 and E3) could and would change with each execution
0