How To Check Table Statistics In Sap

admin



** Tested with UNIX / Linux operating system.

Delta merge activities are tracked in table MDELTAMERGESTATISTICS and its history in HOSTDELTAMERGESTATISTICS. See SAP Note 2088971 for details how to configure the amount of data available in monitoring view MDELTAMERGESTATISTICS. You can use SQL: 'HANATablesColumnStoreMerges' (SAP Note 1969700) to retrieve information. It provides information like execution time, merge type, table name, merge duration, number of rows merged and merge errors. How about using the new (and mind boggling difficult to use) spspaceusage system proc (note, 'usage' not 'used'). I find it really hard to use because the parameters are variable (you need to specify different kinds of parameters depending on earlier parameters in the parameter list and they don't use intelligent defaults) and they're not fully defined in the help pages. Open transaction code DB20. Put in the table name and refresh (update info). This will shows the current statistics update. Choose create to create a new statistics for the inserted table. ST03 SAP tcode for – Workload and Performance Statistics. Here we would like to draw your attention to ST03 transaction code in SAP.As we know it is being used in the SAP BC-CCM (Use Subcomponents in Basis) component which is coming under BC module (BASIS).ST03 is a transaction code used for Workload and Performance Statistics in SAP.

1. Connect to BRTOOLS via ora<SID>.

How To Check Table Statistics In Sap

2. Select 7 for Database statistics.

3. Select 1 to Update database statistics.

4. This page is the main options for update statistic. Type ‘c’ to continue. (or select 11, to update a specific table)

Check

5. This page is the additional options for update statistics. Type ‘c’ to continue.

6. This step is to check the statistics. Type ‘c’ to continue.

7. Type ‘c’ to proceed with the statistics. Please wait a moment untill the statistics update is done.

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

List Of Tables In Sap


Read more...

Sap How To Check Inventory

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 ONE Support launchpad (Login required). How To Check Table Statistics In Sap

How To Check Table Statistics In Sql Server

Search for additional results

How To Check Table Statistics In Sap Analytics

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