Re: Diagnosing causes to ORA-4031

From: Sweet Pete <pgadah_at_magicnet.net>
Date: Thu, 20 Sep 2001 19:23:10 GMT
Message-ID: <3baa420d.11120094@news.magicnet.net>

Ray

A good post to look at is the following: http://www.orafaq.com/msgboard/server/messages/6325.htm

Regards,
Peter

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
Received on Thu Sep 20 2001 - 14:23:10 CDT