Got 1 Sun Server (E4500) with 4 cpu/4G Ram, and just upgrade the sun storage for the lack of disk space, also the CPu and RAM double at the same time.
Solaris Version, 2.6, Oracle: 8.0.5, ERP 11.0.3, Mem: 8GB
But I have some confused when I check the server last day.
The following is the top result I run.
[php]
last pid: 15385; load averages: 0.43, 0.30, 0.39 08:47:57
294 processes: 290 sleeping, 2 zombie, 2 on cpu
CPU states: 66.6% idle, 15.7% user, 6.6% kernel, 11.0% iowait, 0.0% swap
Memory: 8192M real, 125M free, 385M swap in use, 1663M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
15196 ora805 1 0 0 1623M 1612M cpu9 1:36 4.92% oracle
15385 appl110 1 0 0 2280K 1856K cpu5 0:02 1.38% top
15188 ora805 1 48 2 984K 880K sleep 2:34 0.62% tar
12312 ora805 1 0 0 1623M 1612M sleep 2:19 0.34% oracle
11633 ora805 1 58 0 1516M 1506M sleep 45:24 0.29% oracle
15286 ora805 1 54 0 1623M 1612M sleep 0:30 0.28% oracle
15241 ora805 1 33 0 1623M 1612M sleep 0:33 0.08% oracle
15169 appl110 1 58 0 39M 18M sleep 0:06 0.05% f45webm
15054 appl110 1 58 0 38M 16M sleep 0:11 0.04% f45webm
15158 ora805 1 58 0 1623M 1612M sleep 2:22 0.03% oracle
15252 appl110 1 58 0 39M 18M sleep 0:04 0.02% f45webm
15230 appl110 1 58 0 38M 18M sleep 0:05 0.02% f45webm
15256 ora805 1 38 0 1622M 1612M sleep 1:16 0.02% oracle
12302 appl110 1 48 0 38M 15M sleep 0:17 0.02% f45webm
15292 appl110 1 58 0 38M 18M sleep 0:04 0.02% f45webm
[/php]
But as I know, the SGA of the Server only up
Instance 1.
[php]
SVRMGR> show sga
系统全局区域合计有 1677999632个字节
Fixed Size 48656个字节
Variable Size 448970752个字节
Database Buffers 1228800000个字节
Redo Buffers 180224个字节
[/php]
Instance 2
[php]
SVRMGR> show sga
系统全局区域合计有 1779023376个字节
Fixed Size 48656个字节
Variable Size 242794496个字节
Database Buffers 1536000000个字节
Redo Buffers 180224个字节
SVRMGR>
[/php]
And there are about 150 sessions connect to the server with Oracle.
[php]
shared_pool_size 字符串 300000000
sort_area_retained_size 整数 0
sort_area_size 整数 256000
[/php]
As the top result show, seems only 200- MB RAM free space , But I start up the 3rd instance
with the sga like following, it is also ok,
[php]
SVRMGR> show sga
系统全局区域合计有 1566973456个字节
Fixed Size 48656个字节
Variable Size 337944576个字节
Database Buffers 1228800000个字节
Redo Buffers 180224个字节
SVRMGR>
[/php]
I am confused now, which command shall I used to determin the real RAM usage information?
In all instance I configured
use_ism=true.
|
