2台机器的环境:
操作系统(都一样):
[root@localhost dbs]# uname -a
Linux localhost.localdomain 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 i686 i386 GNU/Linux
数据库(也一样):
Release 10.2.0.1.0
[root@localhost dbs]# cat /proc/meminfo
机器A:MemTotal: 8309880 kB
机器B:MemTotal: 6232116 kB
free -m:
A:
total used free shared buffers cached
Mem: 8115 8042 72 0 9 6357
-/+ buffers/cache: 1675 6439
Swap: 15939 733 15205
B:
total used free shared buffers cached
Mem: 6086 4207 1878 0 286 2319
-/+ buffers/cache: 1601 4484
Swap: 11954 65 11888
此外2台机器的环境变量都一样的,根据:http://www.puschitz.com/TuningLinuxForOracle.shtml上的描述:
Memory (VLM).
RHEL 3/4 Kernel 10g DB Version Default Supported SGA
without VLM Max Supported SGA
without VLM Comments
smp kernel (x86) 10g Release 1 Up to 1.7 GB Up to 2.7 GB 10g R1 must be relinked to increase the SGA size to approx 2.7 GB
hugemem kernel (x86) 10g Release 1 Up to 2.7 GB Up to 3.42 GB 10g R1 must be relinked to increase the SGA size to approx 3.42 GB
smp kernel (x86) 10g Release 2 Up to ~2.2 GB (*) Up to ~2.2 GB (*) No relink of 10g R2 is necessary but the SGA Attach Address is a little bit higher than in R1
hugemem kernel (x86) 10g Release 2 Up to ~3.3 GB (*) Up to ~3.3 GB (*) No relink of 10g R2 is necessary but the SGA Attach Address is a little bit higher than in R1
在没有without VLM 下,sga_max_size最多达到2.2G,我的A机器最大能达到这个数字,在我的B机器上能达到2483027968(=2.3125G)
现在的问题:
(1)我的B机器sga_max_size超过了2.2G,跟文档上说的不一样,不知道各位有没碰到(有些文档上也描述过这个情况)
(2)B机器上的MEM小,SGA_MAX_SIZE比A机器大,不知道是什么原因,不知道各位有没碰到过。
当然在32位机器上可以使用DB_BLOCK_BUFFERS这个参数;你机器上的SGA_MAX_SIZE有多大?