On Wed, 12 Sep 2001, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
