SAP Knowledge Base Article - Preview

3033007 - ORA_SSA_SDCC_HELPER - Heap size <xyz>K exceeds notification threshold (51200K)

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

SAP ERP 6.0

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.