Database Administration (MOSC)

MOSC Banner

Help: Unable to Enable Result Cache

edited Jan 8, 2014 10:16AM in Database Administration (MOSC) 13 commentsAnswered
Environment:


Oracle 11.2.0.2 on RH Linux 64
memory_target = 4000 MB

Memory Advisor in DB Control shows the following:

Automatic Shared Memory Management Enabled
Total SGA Size (MB)2608
Shared Pool 1536
Buffer Cache 960
Large Pool 32
Java Pool 16
Other 64

 I have two DBs in the same Oracle home. I was able to enable result in one of them, but not the other. Here was what did:

alter system set result_cache_max_size = 32M scope=both;  -- System altered

select * from v$parameter where name = 'result_cache_max_size';  --- 32M

exec DBMS_RESULT_CACHE.BYPASS(FALSE);

SELECT DBMS_RESULT_CACHE.STATUS FROM DUAL; -- disabled

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