LINUX7.3 ORACLE 11204
启用了大页+SGA+PGA,现想切换到 MEMORY_TARGET 参数作测试,发现,即便关闭数据库,关闭CRS,还是没法释放大页占用的内存,导致设置了 MEMORY_TARGET 参数后,无法启动。
请问:在不重启服务器的情况下,如何释放大页占用的内存?
SYS@orcl2>show parameter memory
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SYS@orcl2>show parameter pga
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
pga_aggregate_target big integer 30G
SYS@orcl2>show parameter sga
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 70G
sga_target big integer 70G
SYS@orcl2>alter system set memory_target=100g scope=spfile sid='*';
System altered.
Elapsed: 00:00:00.07
SYS@orcl2>alter system reset pga_aggregate_target scope=spfile sid='*';
System altered.
Elapsed: 00:00:00.01
SYS@orcl2>shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@orcl2>startup nomount;
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 26
Additional information: 3538951
Additional information: -2147483648
SYS@orcl2>
SYS@orcl2>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[cloudrac2@oracle /tmp]
$free -m
total used free shared buff/cache available
Mem: 128648 75805 49176 390 3666 42744
Swap: 4095 0 4095
[cloudrac2@oracle /tmp]
$