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
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
======= 2002-12-11 11:53:00 ,you wrote��=======
>> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
>>
>>
>> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
