SQL Performance (MOSC)

MOSC Banner

SQL Query Result Set Cache in 11.2.0.3

edited Jun 6, 2013 4:44AM in SQL Performance (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center