Oracle-L: RE: memory usage by dbw very high

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 31 Oct 2003 14:24:25 -0800
Message-ID: <F001.005D5389.20031031142425@fatcity.com>

If I'm not mistaken, this figure includes the size of the shared memory segment from the SGA. Take the output of the "oracle" line of "ipcs -a"
(hopefully you'll only have one!) and subtract it from the process size to
get a better idea of the non-shared memory size of the process.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----
Sent: Friday, October 31, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L

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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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 - 16:24:25 CST