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 , Content Management , EP-KM-ADM , System Administration , EP-KM-DB , Database , 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.