!! 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).
Received on Thu Sep 13 2001 - 13:16:17 CDT