Re: Shared memory problem on Oracle 7.2.2

HI,

This is a known problem with Oracle. Only way is either to increase shared pool size or pin packages and procedures and functions into shared pool. Also, please see the application itself whether it is doing a lot of repeated activities which can be converted into procedures.

Best of Luck.

Vijay Nair

Per Eivind Solum wrote:
>
> We are quite frequently getting error 4031 from
> our Oracle 7.2.2 database:
>
>
> GST0K1 > oerr ora 4031
> 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 error occurs in an application that performs a large number of
> relatively small insert transactions. The number of bytes that Oracle
> is unable to allocate is typically in the range of 100 - 500 bytes.
>
> Our database server is a SparcStation 20 with 32Mb shared memory.
> The Oracle database has 10 Mb shared memory (init.ora parameter shared_pool_size)
>
> I have verified that the application commits each transaction properly.
> Does anyone know if this a known problem on Oracle 7.2.2?
> Is there any workaround?
>
Received on Thu Jan 04 1996 - 00:00:00 CET