Result cache seems to be disabled
Oracle 11.2.0.2 on Linux
It seems that the result cache option is disabled but the init.ora parameters seem to be OK
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
result_cache_max_result integer 5
result_cache_max_size big integer 125856K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
SQL> EXECUTE DBMS_RESULT_CACHE.MEMORY_REPORT;
R e s u l t C a c h e M e m o r y R e p o r t
Cache is disabled.
SQL> select *
2 from V$RESULT_CACHE_OBJECTS;