关于prstat和oracle的问题

jason_lii

关于prstat和oracle的问题，请教 \r\n我的数据库是oracle9202，os是sun 5.8，数据库配置如下 \r\nSQL>; show sga \r\n\r\nTotal System Global Area 756516552 bytes \r\nFixed Size 730824 bytes \r\nVariable Size 486539264 bytes \r\nDatabase Buffers 268435456 bytes \r\nRedo Buffers 811008 bytes \r\nSQL>; show parameter pga \r\n\r\nNAME TYPE VALUE \r\n------------------------------------ ----------- ------------------------------ \r\npga_aggregate_target big integer 25165824 \r\n\r\n我的数据库没有任何压力，可是使用prstat -a 获得如下的结果 \r\nroot@sfcl01 # prstat -a \r\nPID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP \r\n27757 root 2936K 2080K sleep 59 0 2:24.42 0.3% radsnmp/4 \r\n27755 root 2176K 1712K sleep 59 0 3:23.07 0.3% snmpdx/1 \r\n19021 root 31M 22M sleep 60 0 0:03.49 0.2% radius_ora8/25 \r\n24059 root 1560K 1400K cpu0 49 0 0:00.00 0.0% prstat/1 \r\n19 root 54M 53M sleep 59 0 1:28.53 0.0% vxconfigd/1 \r\n18975 oracle 988M 942M sleep 59 0 1:31.15 0.0% oracle/1 \r\n710 root 8920K 7680K sleep 157 - 0:50.45 0.0% had/1 \r\n561 root 2456K 1208K sleep 59 0 0:02.44 0.0% arraymon/1 \r\n504 root 3104K 1016K sleep 59 0 0:00.00 0.0% lpsched/1 \r\n517 root 1448K 960K sleep 59 0 0:00.00 0.0% powerd/4 \r\n576 root 2216K 1248K sleep 100 - 0:00.34 0.0% xntpd/1 \r\n604 root 1720K 752K sleep 59 0 0:00.00 0.0% smcboot/1 \r\n498 root 2712K 1944K sleep 59 0 0:00.00 0.0% nscd/9 \r\n89 root 2664K 1416K sleep 59 0 0:00.00 0.0% devfsadm/7 \r\n455 root 1920K 1352K sleep 59 0 0:00.00 0.0% lockd/1 \r\n451 root 2440K 1912K sleep 59 0 0:01.23 0.0% inetd/1 \r\n351 root 4488K 4312K sleep 59 0 0:03.06 0.0% picld/11 \r\n456 daemon 2528K 1856K sleep 59 0 0:00.00 0.0% statd/3 \r\n389 root 162M 149M sleep 60 0 0:00.01 0.0% vxsvc/14 \r\n462 root 4112K 3224K sleep 59 0 0:00.02 0.0% automountd/5 \r\n419 root 2272K 1352K sleep 59 0 0:00.00 0.0% rpcbind/1 \r\nNPROC USERNAME SIZE RSS MEMORY TIME CPU \r\n67 root 454M 360M 2.8% 8:30.44 0.8% \r\n17 oracle 13G 12G 97% 2:20.46 0.0% \r\n1 daemon 2528K 1856K 0.0% 0:00.00 0.0% \r\n从上面可以看到，oracle消耗了12G的内存，实际上我的物理内存是2G，swap区是4G，总共才6G，所以就感到非常疑惑. \r\n\r\n为prstat何会有这个结果呢？ \r\n请各位兄弟姐妹指教