Chinese

问题现象：
应用无法创建新的连接，监听日志：
10-OCT-2012 08:59:40 * (CONNECT_DATA=(SID=ora9)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=*******)(PORT=34997)) * establish * ora9 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
IBM/AIX RISC System/6000 Error: 12: Not enough space

alert告警日志伴随有：
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn5
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3


数据库平台 AIX530 ORACLE9208

内存情况如下：

size inuse free pin virtual
memory 7667712 7656619 11093 5878075 7136556
pg space 8388608 180536

work pers clnt other
pin 5614358 0 2758 260959
in use 6994085 5 662529

PageSize PoolSize inuse pgsp pin virtual
s 4 KB - 7443643 86024 5706571 6817420
m 64 KB - 13311 5907 10719 19946


数据库内存分配情况 SGA=12G PGA=3G

操作系统缓存参数设置
maxclient% = 8
maxperm% = 12
minperm% = 5

数据占用内存最多15G左右 文件缓存也设置的很低，总共28G的内存 空闲内存怎么那么少 到底内存消耗到哪里去了很迷惑

-------------------------------------------------------------------------------------------------------------------------------------
AIX INFO

-rwsr-s--x 1 oracle dba 76743075 Jun 04 2011 /data/oracle/app/9.2/bin/oracle
oracle
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 4000
-------------------------------------------------------------------------------
size inuse free pin virtual available
memory 29952.00 29875.23 76.8 22959.37 27821.32 922.99
pg space 32768.00 703.20

work pers clnt other
pin 21929.22 0 10.8 1019.37
in use 27269.90 0.02 2605.32
Page Space Physical Volume Volume Group Size %Used Active Auto Type
paging00 hdisk1 rootvg 16384MB 3 yes yes lv
hd6 hdisk0 rootvg 16384MB 3 yes yes lv
attribute value description user_settable

realmem 30670848 Amount of usable physical memory in Kbytes False
IPC status from /dev/mem as of Wed Oct 10 10:49:04 BEIST 2012
T ID KEY MODE OWNER GROUP
Shared Memory:
m 1048576 0xffffffff rw-rw-- root system
m 1048577 0x900dc0de rw----- root system
m 1048578 0x78000009 --rw-rw-rw- root system
m 1048579 0x670040a9 rw-rr-- root system
m 4 0xffffffff rw-rw-- root system
m 5 0x680040a9 rw-rr-- root system
m 6 0x700040a9 rw----- root system
m 7 0xffffffff rw-rw-- root haemrm
m 9437192 0xa09542c8 rw-r--- oracle dba
m 4194314 0x00005643 --rw-rw-rw- root system
m 4194315 0x00005654 --rw-rw-rw- root system
m 5242892 0x53494152 rw-rr-- root system
m 5242893 0x44525354 rw-rr-- root system
m 5242894 0x55315352 --rw-rw-rw- root system
m 5242895 0x4d4e5251 rw-rr-- root system
m 640679952 0xffffffff rw----- oracle system
2357.17

Edited by: 963675 on 2012-10-9 下午7:50