Symptom
While running EWA Report collection, below Warning is visible in the Oracle Alert Log
...
Memory Notification: Library Cache Object loaded into SGA
Heap size 58944K exceeds notification threshold (51200K)
...
...
KGL object name :xxxxxxxxxxxxxxxx:create global temporary table ORA_SSA_SDCC_HELPER as select * from ( SELECT NAME, VALUE, CATEGORY, decode( instr(','||restriction||',',',DISABL
ED[ALL],')+ instr(','||restriction||',',',DISABLE[DRSORASTT],'), 0, cmp_fail, ' ') SHOW_RSORASTT, decode( instr(','||restriction||',',',DISABLED[ALL],')+
instr(','||restriction||',',',DISABLED[EWA],'), 0, cmp_fail, ' ') SHOW_EWA, RESTRICTION, CMP_FAIL, CMP_OP, CMP_VAL, ACTION, RETENTION, CLASS FROM
( SELECT
Read more...
Environment
- Operating System Independent
- Oracle RDBMS 10g and above
- EWA Report
Product
Keywords
EWA, ORA_SSA_SDCC_HELPER, shared pool, shared_pool_size, _kgl_large_heap_warning_threshold, ST-A/PI, Memory Notification , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview