也不知道起什么题目好,PGA的内存是进程私有内存,如何查看进程真正占有的操作系统内存,是不是依据v$process.PGA_ALLOC_MEM就可以,还是还需要通过其他手段。
select PGA_ALLOC_MEM/1024/1024 MEM from v$process ORDER BY MEM ;
MEM
----------
2.20257282
2.20257282
2.20257282
2.20257282
2.20257282
2.20257282
2.20257282
2.20257282
2.20257282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.26507282
2.32757282
2.32757282
2.32757282
2.39007282
2.39007282
2.39007282
2.39007282
2.39007282
2.45257282
2.45257282
2.45257282
2.45257282
2.45257282
2.45257282
2.45257282
2.45257282
2.45257282
2.51507282
2.51507282
2.51507282
2.51507282
2.57757282
2.57757282
2.57757282
2.64007282
2.64007282
2.70257282
2.70257282
2.76507282
2.76507282
2.82757282
2.82757282
2.82757282
2.82757282
2.95257282
3.07757282
3.18043995
3.26507282
3.26507282
3.32757282
3.45257282
3.45257282
3.45257282
3.51507282
3.55543995
3.57757282
3.57757282
3.57757282
3.64007282
3.64007282
3.64007282
3.64007282
3.70257282
3.70257282
3.76507282
3.76507282
3.76507282
3.76507282
3.82757282
3.82757282
3.82757282
3.89007282
3.89007282
3.89007282
3.95257282
3.95257282
3.97667408
4.01507282
4.01507282
4.01507282
4.07757282
4.07757282
4.07757282
4.14007282
4.14007282
4.14007282
4.20257282
4.20257282
4.20257282
4.20257282
4.20257282
4.32757282
4.32757282
4.39007282
4.45257282
4.55366993
4.64007282
4.95257282
6.54008961
7.26507282
8.66359425
11.0775728
19.5396471
21.5529451
21.9125109
22.0546846
22.4279451
22.4279451
22.4279451
22.4279451
22.9915972
46.3040972
75.9259233
可以看到从ORACLE提供的v$process去统计,每个进程占用的PGA内存大小一般也就3M。
可是进程真正占用的操作系统内存不仅仅如此。
ps aux | grep oraclecrmd | grep -v grep
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 415 0.1 0.0 152056 31896 ? Ss Sep22 4:21 oraclecrmd1 (LOCAL=NO)
oracle 417 0.1 0.0 152048 31932 ? Ss Sep22 5:43 oraclecrmd1 (LOCAL=NO)
oracle 419 0.1 0.0 154076 34036 ? Ss Sep22 5:19 oraclecrmd1 (LOCAL=NO)
oracle 456 0.1 0.0 152040 30028 ? Ss Sep22 6:42 oraclecrmd1 (LOCAL=NO)
oracle 582 0.1 0.0 154080 31776 ? Ss Sep22 4:47 oraclecrmd1 (LOCAL=NO)
oracle 584 0.1 0.0 152028 30148 ? Ss Sep22 4:26 oraclecrmd1 (LOCAL=NO)
oracle 586 0.1 0.0 151008 28980 ? Ss Sep22 5:39 oraclecrmd1 (LOCAL=NO)
oracle 692 0.1 0.0 155100 35112 ? Ss Sep22 6:40 oraclecrmd1 (LOCAL=NO)
oracle 694 0.1 0.0 154104 32500 ? Ss Sep22 5:42 oraclecrmd1 (LOCAL=NO)
oracle 1392 0.1 0.0 152040 31836 ? Ss Sep23 4:51 oraclecrmd1 (LOCAL=NO)
oracle 1508 0.1 0.0 151032 27492 ? Ss Sep23 4:07 oraclecrmd1 (LOCAL=NO)
oracle 2000 0.1 0.0 152036 31736 ? Ss Sep23 3:22 oraclecrmd1 (LOCAL=NO)
oracle 2994 0.1 0.0 153060 33140 ? Ss Sep23 3:29 oraclecrmd1 (LOCAL=NO)
oracle 3001 0.0 0.0 152052 29964 ? Ss Sep23 2:57 oraclecrmd1 (LOCAL=NO)
oracle 3375 0.0 0.0 149880 20632 ? Ss Sep23 0:01 oraclecrmd1 (LOCAL=NO)
oracle 3616 0.1 0.0 152032 30032 ? Ss Sep23 3:34 oraclecrmd1 (LOCAL=NO)
oracle 3650 0.1 0.0 154088 34096 ? Ss Sep23 4:34 oraclecrmd1 (LOCAL=NO)
oracle 3666 0.3 0.0 151004 27552 ? Ss Sep22 16:00 oraclecrmd1 (LOCAL=NO)
oracle 3667 0.1 0.0 153076 33212 ? Ss Sep23 4:50 oraclecrmd1 (LOCAL=NO)
oracle 3668 0.4 0.0 151004 27460 ? Ss Sep22 19:13 oraclecrmd1 (LOCAL=NO)
oracle 3670 0.4 0.0 151008 27720 ? Ss Sep22 18:10 oraclecrmd1 (LOCAL=NO)
oracle 4292 0.1 0.0 150456 23176 ? Ss Sep24 3:18 oraclecrmd1 (LOCAL=NO)
oracle 4956 0.1 0.0 151004 27592 ? Ss Sep22 6:02 oraclecrmd1 (LOCAL=NO)
oracle 5788 0.0 0.0 149880 20712 ? Ss Sep23 0:02 oraclecrmd1 (LOCAL=NO)
oracle 6305 0.1 0.0 152056 30316 ? Ss Sep22 4:38 oraclecrmd1 (LOCAL=NO)
oracle 6326 0.0 0.0 154104 33776 ? Ss Sep22 3:50 oraclecrmd1 (LOCAL=NO)
oracle 6420 0.2 0.0 154092 32428 ? Ss Sep22 8:36 oraclecrmd1 (LOCAL=NO)
oracle 6490 0.1 0.0 154104 33964 ? Ss Sep22 4:30 oraclecrmd1 (LOCAL=NO)
oracle 6522 0.1 0.0 154084 33956 ? Ss Sep22 4:30 oraclecrmd1 (LOCAL=NO)
oracle 6570 0.1 0.0 152028 31940 ? Ss Sep22 4:29 oraclecrmd1 (LOCAL=NO)
oracle 6598 0.1 0.0 154080 34200 ? Ss Sep22 5:22 oraclecrmd1 (LOCAL=NO)
oracle 6615 0.1 0.0 154096 33856 ? Ss Sep22 4:26 oraclecrmd1 (LOCAL=NO)
oracle 6703 0.0 0.0 152032 29808 ? Ss Sep22 3:55 oraclecrmd1 (LOCAL=NO)
oracle 6705 0.1 0.0 154088 34072 ? Ss Sep22 4:32 oraclecrmd1 (LOCAL=NO)
oracle 6732 0.3 0.0 153420 33592 ? Ss Sep22 15:17 oraclecrmd1 (LOCAL=NO)
oracle 6734 0.1 0.0 154080 34268 ? Ss Sep22 5:37 oraclecrmd1 (LOCAL=NO)
oracle 6743 0.1 0.0 154076 34148 ? Ss Sep22 6:32 oraclecrmd1 (LOCAL=NO)
oracle 6750 0.1 0.0 152040 32112 ? Ss Sep22 7:32 oraclecrmd1 (LOCAL=NO)
oracle 6752 0.1 0.0 154084 34028 ? Ss Sep22 5:12 oraclecrmd1 (LOCAL=NO)
oracle 6754 0.0 0.0 152032 30320 ? Ss Sep22 3:56 oraclecrmd1 (LOCAL=NO)
oracle 6756 0.1 0.0 152032 31944 ? Ss Sep22 4:40 oraclecrmd1 (LOCAL=NO)
oracle 6758 0.1 0.0 152032 32008 ? Ss Sep22 4:34 oraclecrmd1 (LOCAL=NO)
oracle 6760 0.1 0.0 152044 31980 ? Ss Sep22 8:12 oraclecrmd1 (LOCAL=NO)
oracle 7486 0.0 0.0 151008 27948 ? Ss Sep23 1:47 oraclecrmd1 (LOCAL=NO)
oracle 7488 0.0 0.0 151008 27948 ? Ss Sep23 1:45 oraclecrmd1 (LOCAL=NO)
oracle 7490 0.0 0.0 152028 29272 ? Ss Sep23 1:51 oraclecrmd1 (LOCAL=NO)
oracle 7492 0.0 0.0 154076 32048 ? Ss Sep23 2:19 oraclecrmd1 (LOCAL=NO)
oracle 7494 0.0 0.0 151012 28844 ? Ss Sep23 2:47 oraclecrmd1 (LOCAL=NO)
oracle 8051 0.1 0.0 150496 25708 ? Ss Sep22 6:10 oraclecrmd1 (LOCAL=NO)
oracle 8053 0.1 0.0 151012 26920 ? Ss Sep22 5:53 oraclecrmd1 (LOCAL=NO)
oracle 8057 0.1 0.0 151032 27604 ? Ss Sep22 5:29 oraclecrmd1 (LOCAL=NO)
oracle 8135 0.2 0.0 150972 27964 ? Ss Sep23 6:51 oraclecrmd1 (LOCAL=NO)
oracle 8905 0.0 0.0 149880 21048 ? Ss Sep22 0:04 oraclecrmd1 (LOCAL=NO)
oracle 9763 0.1 0.0 152028 32128 ? Ss Sep23 4:02 oraclecrmd1 (LOCAL=NO)
oracle 9897 0.0 0.0 152032 30304 ? Ss Sep23 2:38 oraclecrmd1 (LOCAL=NO)
oracle 10332 0.0 0.0 152052 31824 ? Ss Sep23 3:10 oraclecrmd1 (LOCAL=NO)
oracle 10334 0.0 0.0 151028 29048 ? Ss Sep23 2:52 oraclecrmd1 (LOCAL=NO)
oracle 10336 0.0 0.0 151000 29008 ? Ss Sep23 2:40 oraclecrmd1 (LOCAL=NO)
oracle 11057 0.0 0.0 149880 20892 ? Ss Sep22 0:05 oraclecrmd1 (LOCAL=NO)
oracle 11261 0.1 0.0 149948 23912 ? Ss Sep23 3:24 oraclecrmd1 (LOCAL=NO)
oracle 12176 0.1 0.0 153056 30984 ? Ss Sep22 4:24 oraclecrmd1 (LOCAL=NO)
oracle 12178 0.1 0.0 154080 34152 ? Ss Sep22 5:14 oraclecrmd1 (LOCAL=NO)
oracle 12185 0.1 0.0 152028 32008 ? Ss Sep22 6:19 oraclecrmd1 (LOCAL=NO)
oracle 12189 0.1 0.0 154076 32000 ? Ss Sep22 4:59 oraclecrmd1 (LOCAL=NO)
oracle 12191 0.1 0.0 154076 32200 ? Ss Sep22 4:20 oraclecrmd1 (LOCAL=NO)
oracle 12242 0.1 0.0 154104 31776 ? Ss Sep22 4:58 oraclecrmd1 (LOCAL=NO)
oracle 12249 0.1 0.0 154076 33868 ? Ss Sep22 5:33 oraclecrmd1 (LOCAL=NO)
oracle 12261 0.1 0.0 152032 32000 ? Ss Sep22 4:49 oraclecrmd1 (LOCAL=NO)
oracle 12267 0.2 0.0 151992 30740 ? Ss Sep23 7:47 oraclecrmd1 (LOCAL=NO)
oracle 12737 0.1 0.0 154416 32884 ? Ss Sep22 4:52 oraclecrmd1 (LOCAL=NO)
oracle 12747 0.8 0.0 154692 36576 ? Ss Sep23 26:30 oraclecrmd1 (LOCAL=NO)
oracle 12804 0.1 0.0 152032 32000 ? Ss Sep22 5:01 oraclecrmd1 (LOCAL=NO)
oracle 13085 0.0 0.0 151036 29148 ? Ss Sep23 3:17 oraclecrmd1 (LOCAL=NO)
oracle 13087 0.1 0.0 151028 30852 ? Ss Sep23 4:01 oraclecrmd1 (LOCAL=NO)
oracle 13378 0.6 0.0 154260 35404 ? Ss Sep23 20:21 oraclecrmd1 (LOCAL=NO)
oracle 15112 0.1 0.0 154076 32468 ? Ss Sep23 5:31 oraclecrmd1 (LOCAL=NO)
oracle 15194 0.0 0.0 152032 29904 ? Ss Sep23 3:31 oraclecrmd1 (LOCAL=NO)
oracle 15258 0.1 0.0 152040 31720 ? Ss Sep23 3:32 oraclecrmd1 (LOCAL=NO)
oracle 15423 0.0 0.0 154100 31688 ? Ss Sep23 3:59 oraclecrmd1 (LOCAL=NO)
RSS列为真正的进程占用内存大小,可以看到每个ORACLE进程都差不多占用了30M的操作系统内存。
还可以通过/proc/process_id下的status来查看
admin@crmd-rac1:/home/admin>cd /proc/31493
admin@crmd-rac1:/proc/31493>cat status
Name: oracle
State: S (sleeping)
SleepAVG: 98%
Tgid: 31493
Pid: 31493
PPid: 1
TracerPid: 0
Uid: 501 501 501 501
Gid: 501 501 501 501
FDSize: 64
Groups: 501 502
VmPeak: 23591404 kB
VmSize: 151020 kB
VmLck: 0 kB
VmHWM: 38340 kB
VmRSS: 29236 kB
VmData: 2476 kB
VmStk: 200 kB
VmExe: 100616 kB
VmLib: 16156 kB
VmPTE: 308 kB
StaBrk: 0e750000 kB
Brk: 0e80d000 kB
StaStk: 7fff4a3b7ab0 kB
Threads: 1
SigQ: 0/399360
SigPnd: 0000000000000000
ShdPnd: 0000000000000000
SigBlk: 0000000000000000
SigIgn: 0000000006005207
SigCgt: 00000001c9802cf8
CapInh: 0000000000000000
CapPrm: 0000000000000000
CapEff: 0000000000000000
Cpus_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,ffffffff
Mems_allowed: 00000000,00000003
VmRSS: 29236 kB,就是进程占用的操作系统内存大小。
当然通过TOP命令来看也是最方便的。
Tasks: 526 total, 1 running, 525 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.8%us, 0.5%sy, 0.0%ni, 95.4%id, 0.1%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 49448636k total, 31725736k used, 17722900k free, 825208k buffers
Swap: 20482864k total, 289672k used, 20193192k free, 1430524k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17954 oracle 18 0 22.5g 34m 24m D 15.5 0.1 8:49.84 oracle
415 oracle 15 0 22.5g 31m 24m S 0.0 0.1 4:21.48 oracle
417 oracle 15 0 22.5g 31m 25m S 0.0 0.1 5:43.78 oracle
419 oracle 15 0 22.5g 33m 25m S 0.0 0.1 5:19.47 oracle
456 oracle 15 0 22.5g 29m 23m S 0.0 0.1 6:42.85 oracle
582 oracle 15 0 22.5g 31m 24m S 0.0 0.1 4:48.01 oracle
584 oracle 15 0 22.5g 29m 23m S 0.0 0.1 4:26.69 oracle
586 oracle 15 0 22.5g 28m 22m S 0.0 0.1 5:39.92 oracle
692 oracle 15 0 22.5g 34m 28m S 0.0 0.1 6:40.93 oracle
694 oracle 15 0 22.5g 31m 24m S 0.0 0.1 5:42.40 oracle
1392 oracle 15 0 22.5g 31m 24m S 0.0 0.1 4:51.74 oracle
1508 oracle 15 0 22.5g 26m 21m S 0.0 0.1 4:07.42 oracle
1997 oracle 15 0 22.5g 17m 13m S 0.0 0.0 0:00.03 oracle
2000 oracle 15 0 22.5g 30m 24m S 0.0 0.1 3:22.19 oracle
2609 oracle 15 0 22.5g 16m 12m S 0.0 0.0 74:30.50 oracle
2611 oracle 15 0 22.5g 18m 13m S 0.0 0.0 0:00.99 oracle
2613 oracle 15 0 22.5g 15m 11m S 0.0 0.0 0:10.73 oracle
2615 oracle 15 0 22.5g 22m 15m S 0.0 0.0 37:54.79 oracle
2619 oracle 15 0 22.5g 31m 17m S 0.0 0.1 48:27.98 oracle
2621 oracle -2 0 22.5g 32m 17m S 0.0 0.1 356:03.42 oracle
2625 oracle -2 0 22.5g 32m 17m S 0.0 0.1 355:49.97 oracle
2629 oracle -2 0 22.5g 32m 17m S 0.0 0.1 352:42.52 oracle
2633 oracle -2 0 22.5g 32m 17m S 0.0 0.1 356:19.10 oracle
2637 oracle 15 0 22.5g 15m 11m S 0.0 0.0 0:05.06 oracle
2639 oracle 16 0 22.5g 43m 32m S 0.0 0.1 183:11.05 oracle
2641 oracle 16 0 22.5g 40m 32m S 0.0 0.1 179:37.22 oracle
2643 oracle 15 0 22.5g 32m 28m S 0.0 0.1 1139:53 oracle
2645 oracle 15 0 22.5g 32m 22m S 0.0 0.1 20:43.16 oracle
2647 oracle 15 0 22.5g 30m 24m S 0.0 0.1 7:30.23 oracle
2649 oracle 15 0 22.5g 20m 16m S 0.0 0.0 0:00.12 oracle
2651 oracle 15 0 22.5g 27m 21m S 0.0 0.1 1:57.78 oracle
2653 oracle 15 0 22.5g 35m 28m S 0.0 0.1 1:54.48 oracle
2655 oracle 15 0 22.5g 19m 16m S 0.0 0.0 13:57.91 oracle
2994 oracle 15 0 22.5g 32m 26m S 0.0 0.1 3:29.14 oracle
3001 oracle 15 0 22.5g 29m 23m S 0.0 0.1 2:57.37 oracle
3360 oracle 15 0 22.5g 20m 13m S 0.0 0.0 26:39.06 oracle
3375 oracle 15 0 22.5g 20m 16m S 0.0 0.0 0:02.00 oracle
3616 oracle 15 0 22.5g 29m 23m S 0.0 0.1 3:34.69 oracle
RES列为进程占用的操作系统内存大小,基本在30M左右。
我们平时为ORACLE分配内存除了考虑ORACLE自身占用的内存外,还要考虑进程本身占用的操作系统内存。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-708271/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-708271/