Result_cache

Result_Cache is a new feature in 11g using which we can store the results of a query in SGA. We can define deterministic functions also using the result_cache keyword. Here is a nice reference which gives a small example of how result_cache really works.

I came across the result_cache in one of the questions I was answering for plsqlchallenge.com . My rank naturally stumbled becasue of the fact that I did'nt know anything about how to use the result_cache in a function. Good thing is that now I know it.