hi
i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts.
here are the spces
version:9.2.0.4
os:Linux 2.4.9-e.24smp
o/p from top:
1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35
132 processes: 131 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle
CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle
CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle
CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle
Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff
Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached
132 processes: 131 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle
CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle
CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle
CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle
Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff
Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached
sga size:
Total System Global Area 1084823632 bytes
Fixed Size 452688 bytes
Variable Size 335544320 bytes
Database Buffers 738197504 bytes
Redo Buffers 10629120 bytes
Fixed Size 452688 bytes
Variable Size 335544320 bytes
Database Buffers 738197504 bytes
Redo Buffers 10629120 bytes
pga aggregate size:700M
and ps o/p of dbw process
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06 ora_dbw0_revenue
please advise. what is really going on.
thanks
sai