Re: ora-4031 & large

From: Terry Sutton <terrysutton_at_usa.net>
Date: Tue, 18 May 2004 14:34:49 -0700
Message-ID: <01fa01c43d20$09c48b60$57761a0a@TerrySutton>

<<Are you sure that they use Oracle RDBMS? Just kidding. They DO USE MTS,
otherwise hash area would
be allocated from the process memory and not from the large pool. The only way that hash heap is
allocated from the large pool is if the join is done by the process connected to a shared and not
to the dedicated server.>>

Well, I can't guarantee they're not using MTS, but since DISPATCHERS, MAX_DISPATCHERS, SHARED_SERVERS, MAX_SHARED_SERVERS, CIRCUITS, and SHARED_SERVER_SESSIONS have never been set (i.e., they're at the default values), I'm making the rash assumption that they're not using MTS.

<<Apparently, the instance is haunted.>>

No doubt.

--Terry

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 18 2004 - 16:32:25 CDT

Re: ora-4031 & large_pool