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…

I didn't find the right solution from the Internet.
References
https://community.oracle.com/thread/4074562
Product Demo Example