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 InfoCube management (transaction RSA1 -> InfoCube -> context menu: 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 NetWeaver 7.x
  • DB: ORACLE
  • SAP Basis 6.10 and above

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.