Re: ORA-4031 SHARED POOL error

From: <cloggans_at_yahoo.com>
Date: Thu, 07 Oct 1999 18:33:55 GMT
Message-ID: <7tip2i$3ga$1@nnrp1.deja.com>

We've been running into this error too, from queries executed by the PeopleSoft front end. We had the same circumstances: 100MB shared pool, <5 users, re-booting database did not help, error was consistantly repeatable. It would only happen on specific views though. I eventually got around the issue by re-writing the view and using hints to change the execution plan. Sounds to me more like an Oracle 8 bug. (I'm running Oracle 8.0.5.2 on HPUX 10.20)

-Chris

In article <37FA89B3.1FA7375_at_travel-net.com>, Gerry <mulcahey_at_travel-net.com> wrote:
> Hi
> We are currently testing a new application that was developed using
> Developer 2000, r2.1 with the October 1998 patch set. It is running
in
> Windows 95, connecting to an Oracle 8.0.5 database on a DEC Alpha Unix
> server.
>
> The test team keeps getting ORA-04031, "not enough memory in the
shared
> pool", but they don't always get it in the same location.
>
> The shared pool size in the instance is now up to 75 megabytes and we
> only have 5 users connected. I don't believe that it is a shared pool
> error.
>
> I'm guessing a bug of some sorts with Developer 2000, perhaps even on
> this release. We went back to this specific patch because the later
> patch, April 1999, was causing compile problems.
>
> Anyone else run into this at their site?
>
> Any help appreciated. Thanks.
>
> Gerry
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 13:33:55 CDT