hi, friends:
I have a system running AIX5.1-ML04 and Oracle 9.2.0.3 64bit. Datafiles
all on raw devices. System physical memory is 16Gb and Oracle SGA is
8592011632(sga_max_size).PGA_TARGET_aggregate is 3Gb.paging space is 16GB.
This is a Dedicated database server.
Currently system has ~120 connections and paging space utilization is
about 20% and it is continously increasing.
I thought the system should not use so many memory.I listed a oracle
server process from topas list, and used svmon to trace it. Can AIX grurus
help me analyze how much memory does this process consume?
Shared memory segment size should be: 8592011632/1024 = 8390636.36 Kbytes
The process memory size: 1611316 (in use) + 639673 (pgsp) = 2250989 pages.
Pagesize in aix is 4K.
So, the process memory utilization is 9003956 Kbytes.
If i use 9003956 -8390636 =613320Kbyte, this should be the actual size of
oracle server process, right? But if the normal oracle server use so much
memory?
Please share your experience? Is their known bugs in aix5l?
Thanks.
bash-2.05a$ svmon -P 1892470
----------------------------------------------------------------------
---------
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd LPage
1892470 oracletpl9 1611316 3060 639673 1750976 Y N N
Vsid Esid Type Description LPage Inuse Pin Pgsp Virtual
916e9 70000008 work default shmat/mmap - 64290 0 9884 65520
1d13dd 70000012 work default shmat/mmap - 64171 0 33299 65520
71527 70000009 work default shmat/mmap - 64111 0 12216 65520
131233 7000001f work default shmat/mmap - 63927 0 10456 64022
1c14dc 70000016 work default shmat/mmap - 63677 0 13363 65520
1b143b 70000007 work default shmat/mmap - 63179 0 14891 65520
1620 7000000f work default shmat/mmap - 63011 0 23958 65520
e17ee 70000015 work default shmat/mmap - 62876 0 20112 65520
d14ad 7000000a work default shmat/mmap - 62652 0 14414 65520
101270 7000000c work default shmat/mmap - 62479 0 37566 65520
11201 7000000d work default shmat/mmap - 62465 0 25634 65520
21362 70000006 work default shmat/mmap - 62199 0 19054 65520
111c1 70000017 work default shmat/mmap - 61809 0 22617 65520
d144d 7000000e work default shmat/mmap - 61711 0 22109 65520
512e5 70000010 work default shmat/mmap - 61651 0 28692 65520
111411 70000014 work default shmat/mmap - 61603 0 18975 65520
141414 70000013 work default shmat/mmap - 61519 0 30904 65520
f128f 7000001b work default shmat/mmap - 60880 0 18828 65520
815e8 7000000b work default shmat/mmap - 60304 0 30833 65520
161556 70000018 work default shmat/mmap - 60244 0 32235 65520
11561 7000001a work default shmat/mmap - 59518 0 29242 65520
191619 7000001c work default shmat/mmap - 56158 0 30039 65520
131253 70000019 work default shmat/mmap - 55939 0 39391 65520
311e3 70000011 work default shmat/mmap - 55525 0 32287 65520
1b159b 7000001e work default shmat/mmap - 52409 0 13369 61241
1c159c 70000005 work default shmat/mmap - 49776 0 18536 53235
812a8 7000001d work default shmat/mmap - 13021 0 33792 40979
a172a 10 pers text data BSS heap,large fil - 7273 0 - -
/dev/orasoft:1409201
0 0 work kernel segment - 4652 3038 2132 5878
161376 70000020 work default shmat/mmap - 4258 0 571 4258
1484f4 11 work text data BSS heap - 2094 0 0 11815
d09ad 90000000 work loader segment - 1314 0 32 1797
1812f8 70000000 work default shmat/mmap - 120 0 59 178
1c8abc 9001000a work shared library text - 114 0 0 114
1088b0 80020014 work private load - 103 0 0 103
137273 8001000a work private load - 90 0 0 90
130db3 90020014 work shared library text - 75 0 182 216
38523 ffffffff work application stack - 35 0 0 35
158855 f00000002 work process private - 29 22 0 29
1713b7 - pers large file - 20 0 - -
/dev/orasoft:966737
f0aef 9ffffffe work other kernel segments - 15 0 1 16
97f89 8fffffff work private load - 10 0 0 10
f0daf 9fffffff pers ,/dev/hd2:2401 - 10 0 - -
167136 fffffffb work application stack - 0 0 0 0
1a73fa fffffff4 work application stack - 0 0 0 0
b86cb fffffffa work application stack - 0 0 0 0
1175d1 fffffffc work application stack - 0 0 0 0
28a62 fffffff3 work application stack - 0 0 0 0
f12af 70000003 work default shmat/mmap - 0 0 0 0
1274d2 fffffff5 work application stack - 0 0 0 0
1585d5 fffffff7 work application stack - 0 0 0 0
61466 70000004 work default shmat/mmap - 0 0 0 0
1b867b fffffffe work application stack - 0 0 0 0
101410 70000002 work default shmat/mmap - 0 0 0 0
17f01 fffffff2 work application stack - 0 0 0 0
e71ae fffffff9 work application stack - 0 0 0 0
141274 70000001 work default shmat/mmap - 0 0 0 0
286e2 fffffff0 work application stack - 0 0 0 0
1b821b fffffffd work application stack - 0 0 0 0
a6e4a fffffff1 work application stack - 0 0 0 0
137b93 fffffff8 work application stack - 0 0 0 0
1b499b fffffff6 work application stack - 0 0 0 0
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: zhu chao
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
