Oracle 11g RESULT_CACHE_MODE
Oracle 11g has the RESULT_CACHE_MODE database parameter.
This parameter can have 3 values : MANUAL, FORCE and AUTO.
Strangely enough in the documentation only MANUAL and FORCE are described:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/memory.htm#PFGRF10121
What does the AUTO value do?