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
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