SAP Knowledge Base Article - Preview

1966669 - KMC_DBRM tables consume many resources filling DB archive logs

Symptom

  • The following DB requests are executed repeatedly in your system consuming DB resources and causing the archive logs to rapidly increase in size 
    INSERT INTO "KMC_DBRM_CONTENT"
    ("ID","COMPRESSED","CONTENT","REFCOUNTER","TOBEREMOVED") VALUES
    (:1,:2,:3,0,0);
    and
    UPDATE "KMC_DBRM_NODES" SET "ID" = "ID" WHERE "ID" = :1
    AND "TOBEREMOVED" = 0 ;
  • Other KMC_DBRM_* tables may also be affected

Read more...

Environment

  • KMC Content Management
  • Release Independent
  • SAP NetWeaver
  • Linux
  • IBM JVM

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

oraarch, tablespace, KMC_DBRM, lobsegment Production ABAP R/3 ERP SRM CRM ERP PPM SEM APO XI PI PORTAL Test development QA 1891472 Cluster Monitor Service , KBA , EP-KM-CM , KM Content Management , EP-KM-ADM , KM System Administration , EP-KM-DB , KM Database , 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.