RE: AIX pinned memory

From: Adrian <ade.turner_at_gmail.com>
Date: Thu, 14 Dec 2006 21:59:45 -0000
Message-ID: <4581c952.32815873.3dbe.2608@mx.google.com>

Hi Brandon,

If it helps, I too see an over-allocation on an AIX 5.3 LPAR:

$ vmstat -v

             33554432 memory pages
             26814245 lruable pages
               679183 free pages
                    6 memory pools
              7689914 pinned pages

679183 x 4Kb = 29.33GB

But...

	sga_max_size     = 20G
	lock_sga         = TRUE

and

ipcs -am segsz=21474881536

I'm not sure what it means, or if it matters, other than perhaps something else is pinning memory?

HTH
Adrian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Sent: 13 December 2006 21:23
To: Mladen Gogala; Mladen Gogala; ORACLE-L Subject: RE: AIX pinned memory

The amount of pinned pages it's reporting is changing all the time so I don't think it's reporting a fixed page tables size or any similarly fixed kernel parameter setting. The output from ipcs is below. The fact that there are only 2 shared memory segments owned by Oracle and they match the size of my two Oracle SGAs (production database and the recovery catalog) makes me more comfortable that the high pinned pages are not the result of old Oracle SGAs not being released.

Thanks,
Brandon

/opt/oracle ->ipcs -am
IPC status from /dev/mem as of Wed Dec 13 13:13:19 PST 2006

T        ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP
NATTCH     SEGSZ  CPID  LPID   ATIME    DTIME    CTIME

Shared Memory:
m 19922944 0x9342a43c --rw-r----- oracle oinstall oracle oinstall 123 3221233664 544894 258166 13:13:15 13:13:16 15:18:22

m   1048577 0x7800077b --rw-rw-rw-     root   system     root   system
1      2656 422114 5873884  9:24:11  9:24:11 16:25:25
m   1048578 0x7800060f --rw-rw-rw-     root   system     root   system

2 16777216 438510 5873884 9:24:11 9:24:22 16:25:13 m 1048579 0x5c70ce5c --rw-r----- oracle oinstall oracle oinstall 21 268439552 266456 5664798 13:13:15 13:13:15 16:25:45

m         4 0xffffffff --rw-rw----     root   system     root   system
1      4096 606252 606252 13:11:28 13:11:28 16:25:59
m         5 0xffffffff --rw-rw----     root   system     root   system
1      4096 606252 606252 13:11:28 13:11:28 16:25:59
m         6 0xffffffff --rw-rw----     root   system     root   system
1      4096 606252 606252 13:11:28 13:11:28 16:26:00
m         7 0xe4663d62 --rw-rw-rw-   imnadm   imnadm   imnadm   imnadm
1        96 721012 721012 16:26:28 16:26:29 16:26:28
m         8 0x9308e451 --rw-rw-rw-   imnadm   imnadm   imnadm   imnadm
1     97948 721012 721012 16:26:28 16:26:29 16:26:28
m         9 0x52e74b4f --rw-rw-rw-   imnadm   imnadm   imnadm   imnadm
1     36028 721012 721012 16:26:28 16:26:29 16:26:28
m        10 0xc76283cc --rw-rw-rw-   imnadm   imnadm   imnadm   imnadm
1     42268 721012 721012 16:26:28 16:26:29 16:26:28
m        11 0x298ee665 --rw-rw-rw-   imnadm   imnadm   imnadm   imnadm
1      2844 721012 721012 16:26:28 16:26:29 16:26:28
m        12 0x0c6629c9 --rw-r-----     root   system     root   system
1   1663028 778386 532486 16:26:42 16:26:43 16:26:42
m        13 0x06347849 --rw-rw-rw-     root   system     root   system
0     65590 778386 778386 16:26:42 16:26:42 16:26:42
m        14 0x31000002 --rw-rw-rw-     root   system     root   system
2    131164 794772 790688 16:26:42 no-entry 16:26:42
m        15 0x00001515 --rw-rw-rw-     root   system     root   system
0        16 634984 634984 16:26:43 16:26:43 16:26:43
m        16 0x0d000a5e --rw-rw----     root   system     root   system
1      1440 835588 4763760 10:19:53 10:19:53 16:29:45
m   5242897 0x01015b35 --rw-rw-rw-     root   system     root   system
129  16777216 958578 1032370 13:10:00 13:13:16 16:35:50
m   1048594 0xffffffff --rw-rw-rw-     root   system     root   system
128  16777216 1081408 1032370 13:10:00 13:13:16 16:37:01
m  34603027 0xc5e70000 --rw-rw-rw-      tle      tle      tle      tle
14    114036 5079068 5357750 15:27:13 13:12:49 15:27:11
m  10485780 0xc5e70001 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:11
m   2097173 0xc5e70002 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097174 0xc5e70003 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097175 0xc5e70004 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097176 0xc5e70005 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097177 0xc5e70006 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097178 0xc5e70007 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097179 0xc5e70008 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097180 0xc5e70009 --rw-rw-rw-      tle      tle      tle      tle
14  11534336 5079068 5357750 15:27:13 13:12:49 15:27:12
m   2097181 0xc5e7000a --rw-rw-rw-      tle      tle      tle      tle

14 11534336 5079068 5357750 15:27:13 13:12:49 15:27:12

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 14 2006 - 15:59:45 CST