SAP Knowledge Base Article - Preview

2048136 - Performance issue after applying OLTP compression

Symptom

Performance is very bad when performing DML statements on OLTP compressed tables


Read more...

Environment

  • Oracle 11.2.0.2 or 11.2.0.3
  • Any platform
  • OLTP compression enabled
  • DB Block Checking Enabled

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; 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 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

performance slow hang bad compression advanced data manipulation language alter table transaction verification validation , KBA , BC-DB-ORA , Oracle , Bug Filed

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.