Re: User Processes Taking 200 Megs of RAM Upon Connecting

!! Please do not post Off Topic to this List !!

5 users and no MTS. I have found out that the users where doing something they should have, which caused the problem. What a suprise. The list was right, top reports the user process memory allocations incorrectly. The whole issue is solved for the moment. Thanks for all who helped.

At 11:08 AM 9/13/01 -0800, you wrote:
>!! 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_at_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_at_tripo
> >
> > s.com To: Multiple recipients of
> > list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent by: cc:
> >
> > root_at_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_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).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: DBarbour_at_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_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).
>
>
>__________________________________________________
>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_at_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_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).

-- 
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).