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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.