|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
result_cache [Oracle SQL hint]
select /*+ result_cache */ ....
result_cache is a hint that is new with Oracle 11g. It caches the result set of the select statement. If now another session does the same select statement, Oracle can return the result from the cache rather than executing the query, which might be a performance improvement.
See also other hints.