Oracle-L: memory usage by dbw very high

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Fri, 31 Oct 2003 13:49:25 -0800
Message-ID: <F001.005D5386.20031031134925@fatcity.com>

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

sga size:
Total System Global Area 1084823632 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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sai Selvaganesan
INET: ssaisundar_at_sbcglobal.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 31 2003 - 15:49:25 CST