client802（BC卷test）經常出現ABAP dump
從DB13中看到如下提示﹕ORA-04031: unable to allocate 4160 bytes of
shared memory ("shared pool","unknown object","sga heap(1,0)","state objects"
RootCause 分析﹕
數據庫參數(init
解決過程﹕
step1：執行DB13，發現從12/25 DB check 中就已報告此異常
step2：查看LOG﹐發現系統有“ORA-04031: unable to allocate 4160 bytes of shared memory＂錯誤提示
step3: 在OS平台下用oracle帳號查錯誤代碼ora-04031的詳細信息﹐得知﹕"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 initialization parameters
SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the
initialization parameter LARGE_POOL_SIZE＂
step4：去DB主機上$ORACLE_HOME/dbs/init
parameter(如下)，然后把SAP shutdown-startup。以下為修改前后參數值﹕
Parameter name Old value New Value
SHARED_POOL_RESERVED_SIZE 50331648 100401094
SHARED_POOL_SIZE 100663296 1006632960
step5﹕經與用戶確認問題未再發生
經驗教訓﹕
BC卷挂起后在正式開放給用戶使用之前﹐應該先檢查這些參數﹐并根據主機硬體資源情況設置合理的參數值
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21495077/viewspace-605413/ ，如需转载，请注明出处，否则将追究法律责任。
