[root@ora ~]# cat /proc/meminfo | grep Mem
MemTotal: 8308784 kB
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
SQL> show parameter sga_max_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 1678842656
[root@ora ~]# uname -a
Linux ora 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 athlon i386 GNU/Linux
[root@ora ~]# ipcs -m
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000001 32768 root 600 655360 0
0x00000000 3375105 oracle 640 4194304 14
0x00000000 3407874 oracle 640 419430400 14
0x00000000 3440643 oracle 640 318767104 14
0x00000000 3473412 oracle 640 234881024 14
0x00000000 3506181 oracle 640 352321536 14
0x725c60bc 3538950 oracle 640 356515840 70
为什么有这么多行oracle的,oracle 10G的也没这么大,那里的sga_max_size=2.1G
MemTotal: 8308784 kB
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
SQL> show parameter sga_max_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 1678842656
[root@ora ~]# uname -a
Linux ora 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 athlon i386 GNU/Linux
[root@ora ~]# ipcs -m
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000001 32768 root 600 655360 0
0x00000000 3375105 oracle 640 4194304 14
0x00000000 3407874 oracle 640 419430400 14
0x00000000 3440643 oracle 640 318767104 14
0x00000000 3473412 oracle 640 234881024 14
0x00000000 3506181 oracle 640 352321536 14
0x725c60bc 3538950 oracle 640 356515840 70
为什么有这么多行oracle的,oracle 10G的也没这么大,那里的sga_max_size=2.1G
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751051/viewspace-731729/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751051/viewspace-731729/