SAP Knowledge Base Article - Preview

1831561 - Database check showing missing statistics

Symptom

In the CheckDB job log there are tables/indexes partitions with missing statistics, as example below:

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table partition) SAPSR3./BI0/F0SM_ESRSD./BI0/F0SM_ESRSD0000000123
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRSD~01./BI0/F0SM_ESRSD0000000123
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRSD~02./BI0/F0SM_ESRSD0000000123
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRSD~04./BI0/F0SM_ESRSD0000000123
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRSD~05./BI0/F0SM_ESRSD0000000123
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRSD~06./BI0/F0SM_ESRSD0000000123 


Read more...

Environment

  • SAP NW systems
  • Oracle RDBMS any version
  • Any OS platform

Keywords

Oracle, RDBMS, check, MISSING_STATISTICS, partitioned, part, DB check, process chain , KBA , BC-DB-ORA-DBA , Database Administration , BW-SYS-DB-ORA , BW ORACLE , How To

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.