SAP Knowledge Base Article - Preview

2119064 - Bad query performance, InfoCube table statistics never updated

Symptom

The performance of a query has decreased although you did not change its structure recently. The SQL-statement shows a long lasting access on InfoCube tables.

  • The cube statistics show a yellow traffic light in transaction RSA1 -> InfoCube Manage -> Performance tab.
  • A refresh of the statistics does not work, neither manually in transactions RSA1, RSRV nor with BRCONNECT or in a Process Chain. The statistics check remains yellow.

The initial filling of aggregates may also be influenced by this problem.


Read more...

Environment

  • SAP BW >= 7.x
  • DB  ORACLE
  • SAP Basis >= 6.10

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 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

Statistics, Performance, Web Template, Analyzer, Workbook, Timeout, Time Out, TIME_OUT, BICS, MDX, SQL, Slow, Changerun, Aggregate Filling, Oracle Optimizer, DB21, BI_STAT, BI_INDX, DBSTATC, SAP_DBSTATC_CLEANUP , KBA , BW-BEX-OT , OLAP Technology , BC-DB-ORA , Oracle , BW-SYS-DB-ORA , BW 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.