- 最后登录
- 2014-10-30
- 在线时间
- 23 小时
- 威望
- 0
- 金钱
- 129
- 注册时间
- 2014-1-26
- 阅读权限
- 10
- 帖子
- 29
- 精华
- 0
- 积分
- 0
- UID
- 1650
|
1#
发表于 2014-2-19 18:42:30
|
查看: 3617 |
回复: 6
数据库版本(有asm):
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
os平台:centOS 6.0
[oracle@mysqldb87 trace]$ uname -a
Linux mysqldb87 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
相关内核参数(正在报错时收集的信息):
[oracle@mysqldb87 trace]$ free -m
total used free shared buffers cached
Mem: 387577 186632 200944 0 252 163082
-/+ buffers/cache: 23296 364280
Swap: 32767 0 32767
[oracle@mysqldb87 trace]$ vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
1 0 0 205655808 258892 166996992 0 0 33 50 0 0 1 0 99 0 0
# Controls the default maxmimum size of a mesage queue
kernel.msgmnb = 65536
# Controls the maximum size of a message, in bytes
kernel.msgmax = 65536
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 20971520000
kernel.shmmax =350000000000
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 350000000000
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
#* soft nproc 16384
#* hard nproc 16384
grid soft nproc 16384
grid hard nproc 16384
oracle soft nproc 16384
oracle hard nproc 16384
* soft nofile 131072
* hard nofile 131072
* soft memlock 50000000
* hard memlock 50000000
|
|