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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l