Hi Guys,

I've oracle 9i on Solaris 8, with a RAM of 2560 Mb, 3 CPUs.
the SGA details are
SGA Area MB
java pool 32
large pool 96
shared pool 207
Buffer Cache (approx) 500
Fixes SGA 1
Log Buffers 1
Total 837

This is a development environment. I have found a High memory utilization 98 % to 99% (always) even when
the CPU utilization is under 1%.

below is the scenario

$ prstat -a
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLW
18314 oracle 914M 868M sleep 54 0 0:00.00 0.1% oracle/1
18021 oracle 914M 868M sleep 48 0 0:00.07 0.0% oracle/1
18321 oracle 1504K 1168K cpu3 50 0 0:00.00 0.0% prstat/1
18312 oracle 1032K 736K sleep 40 0 0:00.00 0.0% sh/1
18011 oracle 922M 867M sleep 58 0 0:00.00 0.0% oracle/15
18316 root 1664K 1088K sleep 58 0 0:00.00 0.0% rquotad/1
18310 root 1784K 1320K sleep 38 0 0:00.00 0.0% in.telnetd/
1849 oracle 17M 6872K sleep 48 0 0:01.39 0.0% tnslsnr/1
213 root 3504K 1912K sleep 58 0 0:00.00 0.0% syslogd/14
234 root 2432K 1648K sleep 53 0 0:00.00 0.0% nscd/8
199 daemon 2488K 1744K sleep 0 0 0:00.00 0.0% statd/4
217 root 1928K 1176K sleep 46 0 0:00.00 0.0% cron/1
198 root 1864K 1184K sleep 50 0 0:00.00 0.0% lockd/1
252 root 1360K 872K sleep 50 0 0:00.00 0.0% powerd/3
159 root 2392K 1368K sleep 58 0 0:00.00 0.0% rpcbind/1
NPROC USERNAME SIZE RSS MEMORY TIME CPU
23 oracle 18G 17G 99% 0:01.48 0.3%
48 root 149M 99M 0.6% 0:00.25 0.0%
1 daemon 2488K 1744K 0.0% 0:00.00 0.0%

Total: 72 processes, 233 lwps, load averages: 0.02, 0.01, 0.01


$ ps -ef | grep oracle
oracle 1849 1 0 Aug 20 ? 1:39 /opt/oracle/product/920/bin/tnslsnr LISTENER -inherit
oracle 18331 1 0 01:57:49 ? 0:00 ora_p004_orcl
oracle 18013 1 0 00:10:41 ? 0:00 ora_ckpt_orcl
oracle 18015 1 0 00:10:42 ? 0:01 ora_smon_orcl
oracle 18009 1 0 00:10:41 ? 0:00 ora_dbw0_orcl
oracle 18280 1 0 01:14:37 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18007 1 0 00:10:41 ? 0:00 ora_pmon_orcl
oracle 18021 1 0 00:10:42 ? 0:08 ora_qmn0_orcl
oracle 18325 1 0 01:57:49 ? 0:00 ora_p001_orcl
oracle 18019 1 0 00:10:42 ? 0:00 ora_cjq0_orcl
oracle 18288 1 0 01:16:02 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18023 1 0 00:10:42 ? 0:00 ora_s000_orcl
oracle 18312 18310 0 01:57:33 pts/2 0:00 -sh
oracle 18256 1 0 01:14:25 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18332 18312 0 01:59:27 pts/2 0:00 grep oracle
oracle 18305 1 0 01:36:43 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18284 1 0 01:16:00 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18025 1 0 00:10:42 ? 0:00 ora_d000_orcl
oracle 18327 1 0 01:57:49 ? 0:00 ora_p002_orcl
oracle 18011 1 0 00:10:41 ? 0:01 ora_lgwr_orcl
oracle 18290 1 0 01:16:11 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18323 1 0 01:57:49 ? 0:00 ora_p000_orcl
oracle 18292 1 0 01:16:22 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18308 1 0 01:53:10 ? 0:02 oracleorcl (LOCAL=NO)
oracle 18017 1 0 00:10:42 ? 0:00 ora_reco_orcl
oracle 18286 1 0 01:16:01 ? 0:00 oracleorcl (LOCAL=NO)
oracle 18329 1 0 01:57:49 ? 0:00 ora_p003_orcl

Help me figure out the problem
Need to resolve this problem, Quick response is appreciable.

Thanks in advance.

Padmesh