SESSION UGA MEMORY MAX

From: Bachmann, Henrik <Henrik.Bachmann_at_bim-consulting.de>
Date: Tue, 20 Nov 2001 08:31:02 -0800
Message-ID: <F001.003C9782.20011120081522@fatcity.com>

Hi there,

anybody out there who can give me some hints for the following effects.

I have an oracle dedicated server 8.1.6 on unix with 1GB of memory. I have to tune the system and I am looking for bottlenecks. Now I found the following: There are some sessions with a value for SESSION UGA MEMORY MAX of nearly 3.000.000.000 (session connect time 48 hours). What does it mean? Is this a potential performance killer?

Thanks in advance.

Best regards

Henrik Bachmann                    mailto:Henrik.Bachmann_at_bim-consulting.de

B.I.M.-Consulting Magdeburg        http://www.bim-consulting.de/
D-39108 Magdeburg                  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bachmann, Henrik
  INET: Henrik.Bachmann_at_bim-consulting.de

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 Tue Nov 20 2001 - 10:31:02 CST