oracle禁用amm,[20180211]11g关闭AMM.txt

[20180211]11g关闭AMM.txt

--//指点别人的系统关闭AMM,使用hugepages遇到问题,主要问题是对方设置如下参数在spfile文件中:

*.memory_max_target=0

*.memory_target=0

--//通过例子说明:

1.环境:

SCOTT@book> @ &r/ver1

PORT_STRING                    VERSION        BANNER

------------------------------ -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SYS@book> create pfile='/tmp/@.ora' from spfile;

File created.

--//修改 /tmp/book.ora 文件增加如下:

*.memory_max_target=0

*.memory_target=0

2.测试:

SYS@book> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@book> startup pfi