两个sqlplus 进程使用内存的比较

svmon命令对 两个sqlplus 进程使用内存的比较[@more@][node1:root] svmon -P 7143574 [node1:root] svmon -P 17039518
------------------------------------------------------------------------------- -------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB
7143574 oracle 171966 22512 4037 151396 Y N N 17039518 oracle 171618 22512 4037 151048 Y N N

PageSize Inuse Pin Pgsp Virtual PageSize Inuse Pin Pgsp Virtual
s 4 KB 27950 0 3589 7140 s 4 KB 27602 0 3589 6792
m 64 KB 9001 1407 28 9016 m 64 KB 9001 1407 28 9016

Vsid Esid Type Description PSize Inuse Pin Pgsp Virtual Vsid Esid Type Description PSize Inuse Pin Pgsp Virtual
1068a99 70000002 work default shmat/mmap m 3591 0 0 3591 1068a99 70000002 work default shmat/mmap m 3591 0 0 3591
10415d3 70000001 work default shmat/mmap m 2688 0 0 2688 10415d3 70000001 work default shmat/mmap m 2688 0 0 2688
106ff39 10 clnt text data BSS heap, s 23489 0 - - 106ff39 10 clnt text data BSS heap, s 23489 0 - -
/dev/fslv00:335943 /dev/fslv00:335943
1054015 90000000 work shared library text m 1237 925 3 1237 1054015 90000000 work shared library text m 1237 925 3 1237
10172e5 70000003 work default shmat/mmap m 808 0 0 808 10172e5 70000003 work default shmat/mmap m 808 0 0 808
8002 0 work kernel segment m 508 479 25 523 8002 0 work kernel segment m 508 479 25 523
100d720 70000000 work default shmat/mmap m 161 0 0 161 100d720 70000000 work default shmat/mmap m 161 0 0 161
102dae8 80020014 work USLA heap sm 1805 0 0 1805 1035dee 80020014 work USLA heap sm 1805 0 0 1805
102dce8 11 work text data BSS heap sm 1494 0 0 1494 1045d92 11 work text data BSS heap sm 1174 0 0 1174
105c017 90020014 work shared library s 850 0 1500 1562 105c017 90020014 work shared library s 850 0 1500 1562
1049cf1 9001000a work shared library data sm 119 0 0 119 1035e0e 9001000a work shared library data sm 119 0 0 119
14005 9ffffffd work shared library sm 83 0 2072 2072 14005 9ffffffd work shared library sm 83 0 2072 2072
1011e27 f00000002 work process private m 5 3 0 5 105dc94 f00000002 work process private m 5 3 0 5
1061b1b ffffffff work application stack sm 51 0 0 51 1039d6d ffffffff work application stack sm 23 0 0 23
1027669 90000001 work shared library text m 3 0 0 3 1027669 90000001 work shared library text m 3 0 0 3
3000c 9ffffffe work shared library sm 22 0 17 23 3000c 9ffffffe work shared library sm 22 0 17 23
104c193 9fffffff clnt USLA text,/dev/hd2:4218 s 13 0 - - 104c193 9fffffff clnt USLA text,/dev/hd2:4218 s 13 0 - -
103db6c 8fffffff work private load data s 11 0 0 11 1065e1a 8fffffff work private load data s 11 0 0 11
1020bea - clnt /dev/fslv00:301607 s 10 0 - - 1020bea - clnt /dev/fslv00:301607 s 10 0 - -
107dcfc 8001000a work private load data sm 3 0 0 3 1015e26 8001000a work private load data sm 3 0 0 3
[node1:root] [node1:root]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/271063/viewspace-1060050/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271063/viewspace-1060050/