Re: Urgent ! ORA-04031 error

From: Scott Gamble <zifnab_at_nospam.reddragon.org>
Date: Sat, 27 Oct 2001 14:19:27 GMT
Message-ID: <Xns91475F3445D36zifnabnospamreddrago@64.154.60.173>

If the other posts about the shared pool don't help, you might want to search metalink.

There is/was a bug with 8.1.7.1 that resulted in this error happening quite often. There was a work around with a hidden parameter. You might want to check metalink to see if it also affects 8.1.6. Off the top of my head I don't recall.

Scott Gamble

"Chris" <chris.lo_at_cyberwisdom.net> wrote in news:9q16o1$mmk$1_at_tenorhorn.hk.dyxnet.com:

> I wrote an servlet application that use Oracle 8.1.6 as the database. The
> servlet works fine for servel months and the application is in the
> production mode. However users get the following error when access one of
> the page:
>
> ORA-04031: unable to allocate 184 bytes of shared memory ("shared
> pool","unknown object","sql area","qerixs : rixalo")
>
> Any idea is highly appreciated.
> Chris
>
>
Received on Sat Oct 27 2001 - 09:19:27 CDT