This tutorial describes how Result Cache improves query execution time and application performance in Oracle Database 11g.
Release Date: 01-Jul-07
Duration: 40 minutes
Credited To: -
No Flash Plugin Needed
16-Oct-14
For someone who has never used or read about the result Cache, the tutorial was sucinct and clear. It raise some unanswered questions regarding the Result Cache: Can anybody use the RESULT_CACHE SQL hint in their queries? What happens when the SQL query has a where-clause condition and different users use the same query but only vary the where-clause condition values? Are there separate result caches for each unique condition? Is a result cache even feasible in that situation? Who has visibility to the result cache created by a SQL query? Is is limitied to the session that runs the query, or is the result cache visible to all sessions (assuming the have access to the underlying table--which raises another question regarding object-level security). In the case of a result cache being used in a function, does each unique input parameter passed to the function result in a separate cache with a different result set?
Visit the Full Site | About Oracle | Contact Us | Terms of Use