SAP Knowledge Base Article - Preview

2212229 - Performance problem for a DELETE statement on SLT Logging tables where the SLT source system uses an Oracle Database

Symptom

  • Performance problem with 'DELETE from logging table' statement on the replication source system running on an Oracle database.
  • The problem happens when the daily statistics update is executed when the logging table is empty.


Read more...

Environment

SAP Landscape Transformation Replication Server on DMIS 2011 (SLT 2.0) SP10 or earlier

Product

SAP Landscape Transformation all versions

Keywords

Wrong access plan; update statistics; Primary Index; IUUC_SET_LOGTAB_OPTIMIZER_STAT , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , HAN-DB , SAP HANA Database , 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.