Oracle EBS: [ORA-04031: unable to allocate xxxx bytes of shared memory]

連續兩天出現ORA-04031問題(ERROR_1, ERROR_2), 看了幾篇文章, 看起來是可以透過調整參數來解決.

依參考文件查了幾個值:
  request_failures: 3904
  last_failure_size: 4080
  shared_pool_reserved_min_alloc: 4000

符合"Shared Pool保留空間缺少連續空間"的狀況.


Ref:
1.診斷並解決ORA-04031 錯誤
http://blog.xuite.net/lin666765/blog/16796093-%E8%A8%BA%E6%96%B7%E4%B8%A6%E8%A7%A3%E6%B1%BAORA-04031+%E9%8C%AF%E8%AA%A4

2.ORA-04031: unable to allocate nn bytes of shared memory
http://www.dba-oracle.com/t_ora_04031_unable_to_allocate_shared_memory.htm

3.ORA-4031 Troubleshooting Tool (Doc ID 1521925.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1521925.1


ERROR_1:

ORACLE error 4031 in FDPSTP

Cause: FDPSTP failed due to ORA-04031: unable to allocate 63192 bytes of shared memory ("shared pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_ST
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program QLTTRAMB with request ID 118229540 to start at 02-APR-2018 17:46:53 (ROUTINE=AFPSRS)


ERROR_2:

ORACLE error 4031 in FDPSTP

Cause: FDPSTP failed due to ORA-04031: unable to allocate 2088 bytes of shared memory ("shared pool","unknown object","Heap0: KGL","kgltbsgp")


ERROR_3(原有的排程沒了):

AFPSRS cannot resubmit your concurrent request 118474950. ORACLE error 4031 in FDPRRC

Cause: FDPRRC failed due to ORA-04031: unable to allocate 2416 bytes of shared memory ("shared pool","insert into Fnd_Concurrent_R...","CCursor","kkslpkp
+---------------------------------------------------------------------------+
Finished executing request completion options.
ORACLE error 4031 in FDPRRC

Cause: FDPRRC failed due to ORA-04031: unable to allocate 2416 bytes of shared memory ("shared pool","insert into Fnd_Concurrent_R...","CCursor","kkslpkp:kksclitval")