Database Tuning (MOSC)

MOSC Banner

Result cache seems to be disabled

edited May 7, 2014 12:00PM in Database Tuning (MOSC) 10 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center