Re: ora-4031 & large

From: Terry Sutton <terrysutton_at_usa.net>
Date: Tue, 18 May 2004 15:44:39 -0700
Message-ID: <026001c43d2e$d4a6aee0$57761a0a@TerrySutton>

Thanks, Mark & Rachel. But they're not using XA or connection pooling.

I'm sure increasing the large pool would might help the problem, but I really wanna know why the large pool would be used.

I can't connect to the database right now, but looking at hourly samples (including one taken a couple minutes after the error occurred), the large_pool free memory always shows 16,777,216. This would seem to indicate the large pool isn't getting used.

--Terry

Original Message -----

having run into this exact problem not that long ago, increase the size of the large pool.

If you are using connection pooling to access the database, you are using XA. And XA needs a (no pun intended) large large_pool. Ours broke when a DBA not familiar with our application and database made changes to the init.ora and decreased the size of the large pool.

Terry Sutton <terrysutton_at_usa.net> wrote:
> One of our clients is getting the following error occasionally on a
> 9.2.0.3 DB:
> ORA-04031: unable to allocate 8704 bytes of shared memory ("large
> pool","unknown object","hash-join subh","kllcqas:kllsltba")
>
> The large pool is set at 16M, which isn't high, but they shouldn't be
> using the large pool at all. The don't use MTS, they don't use
> parallel query or have parallel_automatic_tuning set to true, and
> they don't use RMAN. AFAIK, those are the only things which use the
> large pool.
>
> Any ideas?
>
> --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
> -----------------------------------------------------------------

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/

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
-----------------------------------------------------------------



----------------------------------------------------------------
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 - 18:18:20 CDT

Re: ora-4031 & large_pool