RE: Active sessions chewing up a huge amount of RAM

> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
>
>
> How big is the SGA?

Dunno specifics, but it's on the order of a gig.

> On Unix at least, each DB process
> appears to be taking
> a huge chunk'o'virtual memory (as seen from Glance on HP/UX),
> but in reality
> most of that is just the shared mem of the SGA.

Ahhh...

I misspoke, this is on Solaris (too many customers on too many different platforms); the appserver is on NT, but that isn't relavent. This may be the (non)issue; it at least is a fun story to try and float over to the customer...

They've not reported actual "problems", and this customer has been whining pretty hard about us opening a buncha connections and caching them (Weblogic does this pretty well in my experience; however old client-server trained DBA's freak out).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.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).