Scheduler shutdown with ORA-04031 error message

Document ID : KB000007746
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

 

Scheduler shutds down with "ORA-04031" error message in event_demon.<INS> log.

CAUAJM_E_18402 ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","BEGIN :RetVal := ujo_sendafm...","*********","kglHeapInitialize:temp")

Environment:
CA WAAE R11.3.x Onwards
Cause:


Receiving an oracle error message ORA-04031 in the autosys logs usually means that the Oracle database does not have enough shared memory available in Oracle for the amount of requests (processes) that are being run.

Resolution:

 

To resolve the issue, one needs to perform following steps for Oracle Database: 
1. Increase SGA (sga_target and sga_max_size)
2. Increase shared_pool.
3. Increase shared_pool_reserved_size.
4. Or set _SHARED_POOL_RESERVED_PCT=10 - this setting will make sure that there is always 10% reserved size available of shared pool.

Post increasing Shared pool memory kindly start scheduler and execute "chk_auto_up -r 111" to verify whether jobs are running to success.

Additional Information: