| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: User Processes Taking 200 Megs of RAM Upon Connecting
!! Please do not post Off Topic to this List !!
Top shows the SGA size with each process, using pmap you can actually see the break down.
With a 200Mb SGA (or slightly less actually) you will see 200Mb tied to each process, plus the process memory.
Unfortunately I have not seen a tool as useful as top which has distinguished this.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Wednesday, September 12, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
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
There is nothing from any logs or trace files that helps. Plus, I am new to
UNIX.
Any help you could offer would be greatly appreciated.
Todd Carlson
www.tripos.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tcarlson_at_tripos.com
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).
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). Received on Thu Sep 13 2001 - 08:40:49 CDT
 |
 |