ORA-04031 - "unknown object" in shared pool ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 25 Nov 2002 16:05:28 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702F8B8F7@lnewton.leeds.lfs.co.uk>

Upgrade to 8174 - there is a bug in earlier versions which causes the problem you are seeing.

Having said that, this was a bug on HP 64 bit systems running 64 bit Oracle - it *seems* to have been fixed at 8174, but still needs much more shared pool under 817 than under 806.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: costello_at_muikku.baana.suomi.net
[mailto:costello_at_muikku.baana.suomi.net]On Behalf Of costello_at_iki.fi (Antti Järvinen)
Posted At: Monday, November 25, 2002 3:04 PM Posted To: server
Conversation: ORA-04031 - "unknown object" in shared pool ? Subject: Re: ORA-04031 - "unknown object" in shared pool ?

"Sally Pearce" <sally.pearce_at_ncr.com> writes:
> The message means that there wasn't enough shared memory left in the
shared
> pool to perform the requested function. By increasing the size of the
shared
> pool you resolved the immediate problem. A side effect may be that the
> available memory on the server is now so low that there is
insufficient free
> memory on the server and it's having to page. This will certainly slow
> things down. You should be able to use sar (with the-r option) to see
the
> usage .
Received on Mon Nov 25 2002 - 10:05:28 CST