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 with Oracle , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.