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 :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
- as of Oracle RDBMS 10g
- SAP System independent
- 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.