Re: User Processes Taking 200 Megs of RAM Upon Connecting

On Wed, 12 Sep 2001, tcarlson_at_tripos.com wrote:

> Hey gang. New job, new problems. I have just been handed a 8.1.7.0.0
> database on solaris 5.8 with a little problem.
> Everything time a client connects, regardless of type, the OS dedicates
> over 200+ Megs of RAM (as shown by Top) to the user process. Naturally,
> this is running the box out of memory. The init.ora has the following
> parameters:
> db_block_size = 8192
> db_block_buffers = 9652
> large_.pool_size = 2000000
> sort_area_size=65342
> sort_area_retained_size=65342

You didn't mention it, but let me guess, your shared_pool_size is 128M?

75M of buffer cache
2M of large pool
128M of shared pool
=
205M

The Virtual Set Size (VSS) is the total of process memory and shared memory that the process is attached to.

The Resident Set Size (RSS) is the process memory total.

On most Unixes, you can distinguish these by using the ps command. On Solaris, RSS appears to include shared memory. I'm not sure how to ascertain the non-shm process memory size on Solaris.

I suspect your processes are not using 200M each. Just think about it for a second. You have at least PMON, LGWR, RECO, DBW0, SMON, CKPT and at least one dedicated server process. That totals 7 processes at 200M each. So, you have at least 1.35Gb of memory, right? More likely you have many more database processes than that, maybe 50 or more. Do you really have 10Gb of memory? I think if you consider it for a moment, you will realize that your processes are probably not using over 200M of memory each.

Probably a few processes are leaking, most likely SNP processes.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).