Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Diagnosing causes to ORA-4031

Re: Diagnosing causes to ORA-4031

From: Matthias Gresz <nospam_at_newsranger.com>
Date: Fri, 07 Sep 2001 06:23:14 GMT
Message-ID: <mJZl7.7603$4z.32485@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 Fri Sep 07 2001 - 01:23:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US