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

Hello,

I would like to know if somebody here had ever observed an error message like the following

ORA-04031 unable to allocate 4112 bytes of shared memory
("shared pool","unknown object","sga heap","multiblock rea")

and what had been done with it eventually to fix it up.

In my case this message came up several times on some 10 clients one day. We never had this message ever before.
(I was absent on holidays that time it occured, 3 weeks ago)
And they just increased shared_pool_size from 60M to 90M and restarted the instance -
and the error message never came back again.

What I am wondering is the "unknown object" - unfortunately rather too late to chase it back now.
What _could_ that have been (if any answer could be given at all ... ).

And some say that after that parameter change the system became "a little slower" - but
I do not give much on such roumors ... too many reasons there.

My system:
Oracle EE 8.1.7 on AIX 4.3.3 (4 CPU), C/S environment with 200 clients, but only 10 active (avg) at the same time.
Oracle Forms&Reports Runtime Environment on clients. Some network problem have been observed sometimes, though.

I would appcreciate any comments.
ThanX in advance !

Jan Received on Mon Nov 25 2002 - 05:57:47 CST