RE: ora-4031 & large_pool
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 May 2004 16:21:08 -0400
Are you using Oracle XA by any chance? It also requires a large pool.
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Terry Sutton
Sent: Tuesday, May 18, 2004 3:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ora-4031 & large_pool
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
