Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Enable result cache on Database 12c

Babar_BaigAug 22 2017 — edited Aug 25 2017

Hi,

I am trying to enable result cache on Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 by issuing the following command. 

alter system set result_cache_max_size=10 scope=both;

But the system still shows old result_cache value.

SQL> show parameter result

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 0

result_cache_mode                    string      MANUAL

result_cache_remote_expiration       integer     0

Please help

Regards

Babar

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2017
Added on Aug 22 2017
#general-database-discussions
14 comments
972 views