Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Error 04031

Status
Not open for further replies.

brains

Programmer
Joined
Jan 15, 2002
Messages
3
Location
US
ERROR at line 4:
ORA-04031: unable to allocate 2168520 bytes of shared memory ("shared
pool","unknown object","cursor work he","kllcqc:kllcqslt")


I have already used the

$ORACLE_HOME/bin/oerr ora 04031

it reports back with:

04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s",\"%s\")"
// *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
// INIT.ORA parameters "shared_pool_reserved_size" and
// "shared_pool_size".
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".

but there appears to be more to it than that, because we haven't been able to fix this problem for months.

ORACLE supplied a patch but applying the patch is out of my hands.

Any help would be appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top