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.
- SAP BW >= 7.x
- DB ORACLE
- SAP Basis >= 6.10
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 pageThis 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.