ORACLE 大内存的设定

时间：2006-08-29 来源：cxm.cm

1   [root@localhost root]# vi /etc/sysctl.conf
            #oracle used
kernel.shmmax = 3221225472
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem    = 250 32000 100 128
fs.file-max   = 327679
net.ipv4.ip_local_port_range = 1024 65000
kernel.shm-use-bigpages = 2
2   [root@localhost root]# vi /etc/grub.conf

default=0
timeout=10
splashimage=(hd0,0)/grub/splash.xpm.gz
title Red Hat Enterprise Linux AS (2.4.21-4.ELsmp)
        root (hd0,0)
        kernel /vmlinuz-2.4.21-4.ELsmp ro root=LABEL=/ bigpages=4100MB
3     [root@localhost root]# vi /etc/fstab
LABEL=/data1            /data1                  ext3    defaults        1 2
LABEL=/data2            /data2                  ext3    defaults        1 2
none                    /dev/pts                devpts gid=5,mode=620 0 0
none                    /proc                   proc    defaults        0 0
none                    /dev/shm                tmpfs   size=3g         0 0
LABEL=/tmp              /tmp                    ext3    defaults        1 2
/dev/sda5               swap                    swap    defaults        0 0
4
The following parameter should be added to the spfile or pfile: use_indirect_data_buffers=true
Also, any references to db_cache_size and db_xK_cache_size parameters should be removed and replaced with the old style db_block_buffers parameter entry: # 3Gig for an 8K db_block_size.
db_block_buffers = 393216
由于ORACLE 9I 用的db_cache_size,这样无法扩大内存，所以必须先停用db_cache_size设定为0，而把db_block_buffers打开，设定值为786432！

相关阅读更多 +