OS :Windows 10 1809 ,Memory 16G (比较奇怪的是,DBCA认为OS只有15G)
DB:RDBMS 12.2.0.1
因为要测试个功能,刚好Win10上有Oracle 12cR2,在DBCA建库的时候,选择了自动内存管理,结果提示错误。
查了一下MOS,有两篇文章
DBCA does not set AMM as default for 11.2.0.3 or higher when RAM > 4GB, and DBT-11211 can be seen in 12.2. (文档 ID 1453227.1)
12.2:[INS-35178]The Automatic Memory Management Option Is Not Allowed During RunInstaller or Using DBCA If Physical Memory Is Greater Than 4G. (文档 ID 2244817.1)
解决方法,都是要求使用Automatic Shared Memory Management option来替换Automatic Memory Management的方式。
再来看官方的Administrator guide上的说明,之前看11g的文档多一些,11g的文档中,官方建议使用自动内存管理。但是,在12c的官方文档上,官方也建议使用自动内存管理,但是有个限制,SGA+PGA 不要超过4G。
官方文档地址:
6.1 About Memory Management
The memory structures that must be managed are the system global area (SGA) and the instance program global area (instance PGA). Oracle Database supports various memory management methods, which are chosen by initialization parameter settings.
Automatic Memory Management
Oracle Database can manage the SGA memory and instance PGA memory completely automatically. You designate only the total memory size to be used by the instance, and Oracle Database dynamically exchanges memory between the SGA and the instance PGA as needed to meet processing demands. This capability is referred to as automatic memory management. With this memory management method, the database also dynamically tunes the sizes of the individual SGA components and the sizes of the individual PGAs. Oracle recommends automatic memory management for databases where the total size of the SGA and PGA memory is less than or equal to four gigabytes.
END