-
Title
Post stopped: Error: Unexpected Oracle error: ORA-04031: unable to allocate xxxx bytes of shared -
Description
You see the following messages in the event_log:
[1554] 07/12/07 11:41 Notice: ORA-04031: unable to allocate xxxx bytes of shared memory ("shared pool","XF_OL_ST_COTXNADFC0030","KGLS heap","KGLS MEM BLOCK"). [sp_opst_mt(osp)/9978262]
[1554] 07/12/07 11:41 Error: Unexpected Oracle error: ORA-04031: unable to allocate xxxx bytes of shared memory ("shared pool","XF_OL_ST_COTXNADFC0030","KGLS heap","KGLS MEM BLOCK"). (object name: "ADFC0030"."XF_OL_ST_COTXN") [sp_opst_mt (for o.XXX-o.YYY queue QUEUE_NAME)/9978262]
07/12/07 11:41 Process exited sp_opst_mt (for o.XXX-o.YYY queue QUEUE_NAME) [pid = 9978262] - exit(1) -
Cause
SharePlex can't allocate memory in the Shared Pool.
-
Resolution
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".