From rockyw_99@yahoo.com Thu, 13 Sep 2001 11:16:17 -0700 From: Rocky Welch Date: Thu, 13 Sep 2001 11:16:17 -0700 Subject: Re: User Processes Taking 200 Megs of RAM Upon Connecting Message-ID: MIME-Version: 1.0 Content-Type: text/plain !! Please do not post Off Topic to this List !! Hi Todd, How many users are there and what is the nature of their database access and are you running Multi-threaded server? -Rocky --- DBarbour@austin.isd.tenet.edu wrote: > !! Please do not post Off Topic to this List !! > > > What are your hard and soft ulimits? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > tcarlson@tripo > > s.com To: Multiple recipients of > list ORACLE-L > Sent by: cc: > > root@fatcity.c Subject: User Processes > Taking 200 Megs of RAM Upon Connecting > om > > > > > > 09/12/2001 > > 09:20 PM > > Please respond > > to 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@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@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). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: DBarbour@austin.isd.tenet.edu > > 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@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). __________________________________________________ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: rockyw_99@yahoo.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@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).