ORACLE 10g PERFORMANCE ON SOLARIS 10

Hi all,

In sunfire v890 we have installed oracle 10g release 2 on solaris 10.

prstat -a command shows :

NPROC USERNAME SIZERSSMEMORYTIME CPU

105root9268M 6324M20%1:21:57 0.4%

59oracle24G22G 71%0:04:33 0.1%

2nobody484M69M 0.2%0:11:32 0.0%

2esbuser13M9000K0.0%0:00:46 0.0%

1smmsp 7560K 1944K0.0%0:00:00 0.0%

4 daemon12M7976K0.0%0:00:00 0.0%

and top utility shows :

last pid: 8639; load avg: 0.09, 0.09, 0.09;up 2+06:05:2917:07:50

171 processes: 170 sleeping, 1 on cpu

CPU states: 98.7% idle, 0.7% user, 0.7% kernel, 0.0% iowait, 0.0% swap

Memory: 32G phys mem, 22G free mem, 31G swap, 31G free swap

therefore from prstat we come to know that memory used by oracle is 71%

where as top says 31.25% used.....

which one is true in this scenario.....

shall we go ahead in trusting top utility?

Advance thanks to you.

[930 byte] By [kyran55a] at [2007-11-26 19:09:18]
# 1

> therefore from prstat we come to know that memory

> used by oracle is 71%

> where as top says 31.25% used.....

>

> which one is true in this scenario.....

>

> shall we go ahead in trusting top utility?

In this case top is more accurate. prstat pretends all the memory used by each Oracle process is used only by that process. But lots of the memory used by Oracle is shared between several processes. prstat is counting that shared memory over and over for each process... resulting in the higher figure.

http://forum.java.sun.com/thread.jspa?threadID=5114263&tstart=105

Regards,

Mike.Kirk@HalcyonInc.com

http://www.HalcyonInc.com

Aroneka at 2007-7-9 21:04:02 > top of Java-index,Solaris Operating System,Solaris 10 Features...
# 2
excellent explanation thank you厖.
kyran55a at 2007-7-9 21:04:02 > top of Java-index,Solaris Operating System,Solaris 10 Features...