Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Diagnosing causes to ORA-4031
I think you can either apply a patch or just add a undocumented parameter
_db_handles_cached to non zero . You might be running into a known bug .
"Matthias Gresz" <nospam_at_newsranger.com> wrote in message
news:mJZl7.7603$4z.32485_at_www.newsranger.com...
> ORA-04031 unable to allocate string bytes of shared memory
> ("string","string","string","string")
>
> Cause: More shared memory is needed than was allocated in the shared pool.
>
> Action: If the shared pool is out of memory, 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 initialization
> parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large
pool is
> out of
> memory, increase the initialization parameter LARGE_POOL_SIZE.
>
>
>
Received on Sun Sep 09 2001 - 09:53:38 CDT