oracle相关参数进行调整,
要变更的参数如下:
sga_target
原值:3g
新值:20g
pga_aggregate_target
原值:15g
新值:4g
开始工作:
alter system set sga_target=20g scope=spfile;
alter system set pga_aggregate_target=4g;
然后
shutdown immediate
最后
startup
报错如下:
SQL> startup
ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
后经查看suse linux的相关参数配置
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4
LN-STAT-WEB:/etc # more /etc/sysctl.conf
# Disable response to broadcasts.
# You don't want yourself becoming a Smurf amplifier.
net.ipv4.icmp_echo_ignore_broadcasts = 1
# enable route verification on all interfaces
net.ipv4.conf.all.rp_filter = 1
# enable ipV6 forwarding
#net.ipv6.conf.all.forwarding = 1
#add for oracle11g
kernel.shmall =8388608 -- 值一定要配置成这个(page size)
kernel.shmmax = 15618062894 --配置为物理内存一半
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max = 6553600
sysctl -p --生效之
接着startup就可以了