linux 内存占用率 高 通过分析 发现dbwl 进程占用比较高 ，结合strace 进一步分析 发现俩错误，不太清楚这俩是什么原因导致的,另外数据库正常，session并发量300左右

top - 09:35:07 up 152 days, 23:51, 2 users, load average: 2.99, 1.54, 0.89
Tasks: 1261 total, 2 running, 1259 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.3%us, 1.0%sy, 0.0%ni, 91.1%id, 6.0%wa, 0.6%hi, 0.0%si, 0.0%st
Mem: 65947768k total, 65585200k used, 362568k free, 144360k buffers
Swap: 4063224k total, 4k used, 4063220k free, 45304040k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
77931 oracle 20 0 41.5g 56m 26m D 10.5 0.1 0:09.71 oracle
77930 oracle 20 0 41.5g 56m 26m D 7.5 0.1 0:10.34 oracle
75003 oracle 20 0 41.5g 242m 236m S 5.6 0.4 0:01.66 oracle
78140 oracle 20 0 41.5g 130m 126m S 4.2 0.2 0:00.60 oracle

ps aux|head -1;ps aux|grep -v PID|sort -rn -k +4|head
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 46417 0.0 14.2 43506116 9368924 ? Ss Jan20 8:31 ora_dbw1_orcl
oracle 46415 0.0 13.4 43507120 8846884 ? Ss Jan20 8:40 ora_dbw0_orcl
oracle 46413 0.0 5.6 43497224 3727420 ? Ss Jan20 3:01 ora_mman_orcl
oracle 46423 0.0 3.3 43508044 2180516 ? Ss Jan20 15:53 ora_smon_orcl
oracle 55844 0.1 2.8 43508248 1870796 ? Ss Apr14 2:36 oracleorcl (LOCAL=NO)
oracle 46553 0.0 2.5 43501964 1708852 ? Ss Jan20 18:53 ora_cjq0_orcl
oracle 75595 0.0 2.2 43508300 1476796 ? Ss Apr14 0:25 oracleorcl (LOCAL=NO)
oracle 71568 0.1 2.1 43513484 1447844 ? Ss Apr14 1:36 oracleorcl (LOCAL=NO)
oracle 55927 0.1 2.1 43509488 1405564 ? Ss Apr14 1:57 oracleorcl (LOCAL=NO)
oracle 46427 0.0 2.0 43507444 1355664 ? Ss Jan20 32:38 ora_mmon_orcl

MemTotal: 65947768 kB
MemFree: 14643864 kB
Buffers: 145832 kB
Cached: 44935272 kB
SwapCached: 0 kB
Active: 26344248 kB
Inactive: 20303752 kB
Active(anon): 15761768 kB
Inactive(anon): 9399436 kB
Active(file): 10582480 kB
Inactive(file): 10904316 kB
Unevictable: 99760 kB
Mlocked: 22088 kB
SwapTotal: 4063224 kB
SwapFree: 4063220 kB
Dirty: 52 kB
Writeback: 0 kB
AnonPages: 1666712 kB
Mapped: 18768128 kB
Shmem: 23592296 kB
Slab: 574832 kB
SReclaimable: 501872 kB
SUnreclaim: 72960 kB
KernelStack: 4944 kB
PageTables: 3527616 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 37037108 kB
Committed_AS: 46469132 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 141784 kB
VmallocChunk: 34359592240 kB
HardwareCorrupted: 0 kB
AnonHugePages: 100352 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 9212 kB
DirectMap2M: 67090432 kB

strace -c -d -r -T /software/output.txt 46417
[wait(0x137f) = 80625]
pid 80625 stopped, [SIGSTOP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x137f) = 80625]
pid 80625 stopped, [SIGSTOP]
[wait(0x137f) = 80625]
pid 80625 stopped, [SIGSTOP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
strace: exec: Exec format error
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x57f) = 80625]
pid 80625 stopped, [SIGTRAP]
[wait(0x100) = 80625]
pid 80625 exited with 1
% time seconds usecs/call calls errors syscall

-nan 0.000000 0 1 write
-nan 0.000000 0 1 close
-nan 0.000000 0 1 fstat
-nan 0.000000 0 1 1 lseek
-nan 0.000000 0 1 mmap
-nan 0.000000 0 1 munmap
-nan 0.000000 0 1 dup
-nan 0.000000 0 1 1 execve
-nan 0.000000 0 1 kill
-nan 0.000000 0 1 fcntl
-nan 0.000000 0 1 geteuid

100.00 0.000000 11 2 total

SQL> select count(*) from v$session;

COUNT(*)

   310
复制