Hi All,
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production SQL> show parameter result_cache 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 SQL> select dbms_result_cache.status from dual; STATUS -------------------- BYPASS SQL> sho parameter target NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_flashback_retention_target integer 2880 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 90G memory_target big integer 75G parallel_servers_target integer 384 pga_aggregate_target big integer 0 sga_target big integer 0 SQL> alter system set result_cache_max_size=2G scope=both; System altered. SQL> show parameter result_cache_max NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ result_cache_max_result integer 5 result_cache_max_size big integer 0
May you explain me why the result_cache_max_size value is not changing?
Thanks in advance,
Jacek