Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Solaris Memory Usage

573186Apr 30 2007 — edited Apr 30 2007
Hi,

How to find solaris server actual memory usage?
My server is Solaris SPARC 5.8

I know there is prstat utility to find the system perfrmance including cpu, memory, paging....etc.

but prstat doesnt sho actual memory usage. For example:

$ prstat -a
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
18203 oracle 4430M 4347M cpu3 10 0 0:00.09 7.0% oracle/1
7396 oracle 4430M 4350M sleep 22 0 5:05.33 2.5% oracle/1
12147 oracle 4434M 4358M sleep 59 0 0:03.05 1.8% oracle/1
7390 oracle 4431M 4349M sleep 23 0 2:12.57 0.9% oracle/1
16571 oracle 4431M 4350M sleep 59 0 0:00.01 0.5% oracle/1
18042 oracle 4431M 4345M sleep 55 0 0:00.01 0.4% oracle/1
12618 oracle 4435M 4359M sleep 58 0 0:00.03 0.3% oracle/1
13801 oracle 4436M 4360M sleep 28 0 0:00.10 0.3% oracle/1
25836 oracle 26M 7752K sleep 32 0 0:06.09 0.3% tnslsnr/6
10190 oracle 4431M 4351M sleep 54 0 0:00.13 0.2% oracle/1
12528 oracle 4436M 4355M sleep 59 0 0:00.06 0.2% oracle/1
16052 oracle 4435M 4358M sleep 10 0 0:00.03 0.2% oracle/1
7388 oracle 4430M 4352M sleep 48 0 0:19.54 0.1% oracle/1
12405 oracle 4430M 4349M sleep 51 0 0:00.26 0.1% oracle/1
14192 oracle 4431M 4350M sleep 59 0 0:00.04 0.1% oracle/1
NPROC USERNAME SIZE RSS MEMORY TIME CPU
308 oracle 1308G 1284G 100% 10:15.41 17%
39 root 116M 61M 0.0% 0:10.29 0.1%
1 daemon 2544K 1184K 0.0% 0:00.00 0.0%


Total: 348 processes, 1157 lwps, load averages: 0.88, 0.77, 0.77

in the above, it shows that 1308Gb is been used totaly. But actually I have 8 gb total in system. More over for each process it shows as 443x mb as used. This is my SGA size(4430). I believe from the above list, it shows the sga size for each process as memory used.

can anybody give me to find corrct memory usage?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2007
Added on Apr 30 2007
6 comments
676 views