Wednesday, May 21, 2014

RESULT_CACHE hint on Oracle 11G

Result Cache is a new feature in Oracle 11g.  It caches the results of queries and puts it into shared pool. If you are executing the same query without changes then it uses the result of shared pool. 

http://docs.oracle.com/cd/E16655_01/server.121/e15857/tune_result_cache.htm#TGDBA648