Re: RE: Active sessions chewing up a huge amount of RAM

Jeremy Pulcifer,

		Take a look at this link,
		http://www.orafaq.net/archive/oracle-l/2002/10/04/103821.htm, several people answered this topic and pmap does mean something. 
		Also take a look at this thread:
	http://www.orafaq.net/archive/oracle-l/2002/12/03/112855.htm
  		

Regards
zhu chao
chao_ping_at_vip.163.com
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

• 2002-12-11 11:53:00 ,you wrote£º=======

>> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
>>
>>
>> Jeremy - How many connections is Weblogic creating?
>
>20-30 per appserver. 4 appservers.
>
>> Are you using Oracle MTS?
>
>No. At least they're not supposed to be.
>
>> I'm also
>> wondering what
>> the SQL looks like. Is it possible your transactions are very
>> large (not
>> committing often enough)?
>
>The transactional data isn't real significant, however there is a huge
>amount of selects that the OO structures (poorly designed, I might add)
>query, and the reports use a funky system of "temporary tables" that are
>never committed. So, the SGA and PGA get pretty worked; there's not a great
>deal of data involved, however, so it's usually a matter of getting enough
>CPU's on the db, and (to a lesser extent) enough RAM.
>
>Thanks...

• = = = = = = = = = = = = = = = = = = =

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