Oracle-L: RE: Active sessions chewing up a huge amount of RAM

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 11 Dec 2002 11:00:13 -0800
Message-ID: <F001.00517D13.20021211110013@fatcity.com>

In many O/S the more SGA blocks the Oracle processes touch, the bigger amount of memory gets reported in use.

So it's not private memory it's usually the SGA memory.

You have to use a good tool to diagnose memory issues ( I think there is memtool for Solaris).

Waleed

-----Original Message-----
Sent: Wednesday, December 11, 2002 12:39 PM To: Multiple recipients of list ORACLE-L

I have a customer that is reporting that each of the connections our Weblogic appserver uses is using something on the order of 100+MB of RAM on the db server, ostentatiously the Snnn processes are frickin' HUGE. I've never seen that kind of issue, and not real comfortable vouching for the accuracy of this, but I gotta at least ask:

Is there some setting/confluence of circumstances where this is even remotely sensical?

Thanks... We're dealing with Oracle 8.1.6, Weblogic 5.1, running on NT 4.0.

--

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

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Dec 11 2002 - 13:00:13 CST