Oracle 11gR2修改MEMORY_TARGET参数
发布时间:2020-12-12 15:03:11 所属栏目:百科 来源:网络整理
导读:Oracle 11g默认使用AMM(Automatic Memory Management,自动内存管理)功能。在安装数据库过程中,指定Oracle使用内存的百分比,这个取值就作为MEMORY_TARGET和MEMORY_MAX_TARGET的初始取值使用。 Oracle版本 SQL select * from v$version;BANNER-------------
Oracle版本SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production 查看MEMORY_TARGET和相关参数值SQL> show parameter memory NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 2496M memory_target big integer 2496M shared_memory_address integer 0 SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 2496M sga_target big integer 0 SQL> show parameter pga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _pga_max_size big integer 209700K pga_aggregate_target big integer 0 修改MEMORY_TARGET
SQL> alter system set memory_max_target=26G scope=spfile; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 2.7793E+10 bytes Fixed Size 2214096 bytes Variable Size 2.7380E+10 bytes Database Buffers 268435456 bytes Redo Buffers 141578240 bytes Database mounted. Database opened. SQL> show parameter memory; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 26G memory_target big integer 2560M shared_memory_address integer 0 SQL> alter system set memory_target=24G; System altered. SQL> show parameter memory; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 26G memory_target big integer 24G shared_memory_address integer 0 SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 26G sga_target big integer 0 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |