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

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:art39q$lj87e$1_at_ID-152732.news.dfncis.de...
> 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
>
>
>
>
>
>

Jan

04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\
")"

// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *Action: Either use the dbms_shared_pool package to pin large packages,
//          reduce your use of shared memory, or increase the amount of
//          available shared memory by increasing the value of the
//          init.ora parameter "shared_pool_size".

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 - 08:31:33 CST