Re: Diagnosing causes to ORA-4031

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 20 Sep 2001 15:50:53 -0400
Message-ID: <9odhaq$csd7n$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> On 6 Sep 2001 22:29:53 -0700, ray_at_jobnet.com.au (Ray) wrote:
>
> >Sun Sparc Solaris 8
> >Oracle 8.1.7 using MTS
> >
> >All
> >
> >Anybody got any tips for diagnosing the root causes to the
> >ORA-4031 "large_pool" error. I am experiencing this even when
> >there is large amounts of free memory in the large pool (50M) and
> >the requests are for 16K.
> >
> >As a side issue how many are using MTS.
> >
> >Thanks
> >
> >Ray

You may be encountering bug 1397603 if you are on 8.1.7.0. The fix is in 8.1.7.2 and AFAIK is available on Solaris. To verify run the following query perodically. If the result is gradually increasing, you're encountering 1397603. This query must be run as SYS.

select count(*) from x$ksmsp where ksmchcls = 'perm';

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO6pImmm5A4kkb4ZsEQKGZQCgjY0GIUr0uh/75E5cTdNW1f94WrsAoOkU QpQvz2Lk58NBuF15jdF5++iT
=LHAl
-----END PGP SIGNATURE----- Received on Thu Sep 20 2001 - 14:50:53 CDT