Can I ask if anyone of you here encounter the similar problem/scneario
before?

We have set a project for the Oracle Install. And, we assign this
project to the user"oracle" in /etc/user_attr. The V890 we have has
16GB physical RAM, and we assign 12GB for the shm-max.

oracle
projid : 100
comment: ""
users : (none)
groups : (none)
attribs: process.max-sem-nsems=(priv,1024,deny)
project.max-sem-ids=(priv,1024,deny)
project.max-shm-ids=(priv,1024,deny)
project.max-shm-memory=(priv,12884901888,deny)

Oracle starts up fine. It runs, but, our DBA and me (the sysadmin)
worries about the memory usage of it. Whenever we run TOP, the
available memory is very low. We wonder where those memory goes?! And,
can anyone suggest where else i can look at to prove that the OS/
System is ok? Any help - much appreicated

top: version 3.5.1
load averages: 0.14, 0.11, 0.09 13:01:29
204 processes: 202 sleeping, 1 zombie, 1 on cpu

Memory: 16G real, 829M free, 2888M swap in use, 32G swap free


PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
24016 oracle 1 59 0 1470M 1437M sleep 0:06 0.16% oracle
18797 oracle 11 59 0 1478M 1442M sleep 0:37 0.13% oracle
23315 oracle 1 59 0 543M 474M sleep 0:11 0.03% oracle
5253 appworx 76 59 0 169M 60M sleep 13:40 0.03% java
2667 oracle 1 59 0 1471M 1423M sleep 7:53 0.02% oracle
24573 melvinw 1 49 0 2912K 1664K cpu/17 0:00 0.02% top
10671 oracle 1 59 0 1475M 1441M sleep 0:06 0.02% oracle
1130 netconne 14 59 0 9024K 4968K sleep 1:32 0.01% srsproxy
2692 oracle 29 29 10 233M 81M sleep 6:12 0.01% java
3398 oracle 24 29 10 218M 69M sleep 5:24 0.01% java
2711 oracle 1 59 0 1473M 1424M sleep 4:02 0.01% oracle
122 root 13 59 0 8352K 4072K sleep 3:50 0.01% picld
2617 oracle 1 59 0 1471M 1414M sleep 3:38 0.01% oracle
3223 oracle 1 59 0 543M 441M sleep 3:16 0.01% oracle
2607 oracle 11 59 0 1473M 1407M sleep 3:02 0.01% oracle

I ran vmstat, sar before. There is not much going on for si/so, and sr
mostly stays at 0.

VMStat
kthr memory page disk faults
cpu
r b w swap free si so pi po fr de sr m0 m1 m3 m4 in sy cs
us sy id
0 0 0 33359288 878272 0 0 257 0 0 0 0 6 0 0 0 691 1787 1426
0 1 99
0 0 0 33359288 878256 0 0 2 0 0 0 0 0 0 0 0 702 1610 1183
0 0 99
0 0 0 33359288 878256 0 0 27 2 2 0 0 3 0 0 0 594 3188 1277
1 1 98
0 0 0 33359288 878248 0 0 24 6 6 0 0 0 0 2 0 667 2525 1428
0 1 99
0 0 0 33359088 878040 0 0 53 2 2 0 0 2 0 0 0 722 1856 1485
1 1 99
0 0 0 33359384 878304 0 0 18 0 0 0 0 2 0 0 0 709 1719 1288
1 1 98
0 0 0 33359416 878288 0 0 22 0 0 0 0 0 0 0 0 718 1446 1421
0 1 99
0 0 0 33359416 878232 0 0 126 0 0 0 0 2 0 0 0 756 1606 1303
0 0 99
0 0 0 33359416 878224 0 0 19 0 0 0 0 2 0 0 0 670 1662 1263
0 1 99
0 0 0 33358472 877128 0 0 46 2 2 0 0 5 0 1 0 686 4545 1424
1 1 98
0 0 0 33359416 878216 0 0 2 0 0 0 0 0 0 0 0 650 1278 1332
0 0 99
0 0 0 33359416 878216 0 0 32 0 0 0 0 4 0 0 0 578 2970 1224
1 1 98
0 0 0 33359184 877992 0 0 8 0 0 0 0 1 0 0 0 1011 4994 1779
1 1 98
0 0 0 33358904 877696 0 0 5 0 0 0 0 12 0 0 0 816 1807 1435
0 1 99
0 0 0 33358096 877144 0 0 22 0 0 0 0 2 0 0 0 687 1884 1269
0 1 99
0 0 0 33358904 877688 0 0 2 3 3 0 0 0 0 1 0 694 2633 1448
0 1 99
0 0 0 33358536 877320 0 0 61 2 2 0 0 2 0 0 0 1490 2799 2088
1 1 98
0 0 0 33357104 875848 0 0 14 0 0 0 0 2 0 0 0 704 1556 1440
0 1 99
0 0 0 33357032 875776 0 0 8 0 0 0 0 0 0 0 0 664 1410 1360
0 0 99

SAR
SunOS xxxx 5.10 Generic_118833-24 sun4u 05/22/2007

12:48:17 swpin/s bswin/s swpot/s bswot/s pswch/s
12:48:22 0.00 0.0 0.00 0.0 1402
12:48:27 0.00 0.0 0.00 0.0 1622
12:48:32 0.00 0.0 0.00 0.0 1367
12:48:37 0.00 0.0 0.00 0.0 1464
12:48:42 0.00 0.0 0.00 0.0 1390

Average 0.00 0.0 0.00 0.0 1449