1. Home
  2. Resources
  3. SAP Tables
  4. DBSTATTORA - Actual size of tables on the database

SAP Table DBSTATTORA

Actual size of tables on the database

DBSTATTORA (Actual size of tables on the database) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DBSTATTORA to other SAP tables.

Source: DBSTATTORA (Actual size of tables on the database)

DBSTATTORA table fields

Field Data element Checktable Datatype Length Decimals
TNAME Table name TNAME CHAR 30 0
ANDAT Analysis date (yyyymmddhhmm) AM_DATE CHAR 12 0
VWTYP Type of Usage of Table Entry AM_VWTYP CHAR 2 0
A Application table monitor (also possibly with DB optimizer)
O Only for optimizer (STANDARD)
AMETH Analysis Method for Collecting Statistics AM_AMETH CHAR 4 0
E Estimate Statistics (Standard)
EH Estimate Statistics and Generate Histograms
EI Estimate Statistics and Evaluate Structure of Indexes
EX Estimate Statistics/Generate Histograms/Evaluate Structure
C Create Exact Statistics
CH Create Exact Statistics and Generate Histograms
CI Create Exact Statistics and Evaluate Structure of Indexes
CX Create Exact Statistics/Generate Histograms/Eval. Structure
A Estimate Statistics with Auto Sample Size
AH Generate Statistics with Auto Sample Size and Histograms
AI Statistics with Auto Sample + Structure Eval. of Indexes
AX Statistics with Auto Sample + Histograms + Structure Eval.
DB6B DB2/UDB: Statistics Basis for Tables and Indexes (Standard)
DB6T DB2/UDB: Basis Statistics for Tables
DB6I DB2/UDB: Basis Statistics for Indexes
DB6A DB2/UDB: Distribution Frequency for Tables and Indexes
DB6D DB2/UDB: Distribution Frequency for Tables
DB6X DB2/UDB: Distribution Frequency for Indexes
DB6E DB2/UDB: Distribution Frequency: Tables, Basis for Indexes
DB6Y DB2/UDB: Basis for Tables, Distribution Frequency Indexes
OPTIO Sample Size for Collection of Statistics AM_OPTIO CHAR 5 0
NROWS Number of rows in a table OROWS DEC 15 0
OCCBL Used blocks of a table in KB UBLOCKS_KB DEC 11 0
EMPBL Empty blocks of a table in kb EBLOCKS_KB DEC 11 0
AFREE Avg. freespace in a used data base block OAVG_BFREE INT4 10 0
CHAIN Number of rows requiring block chaining OCHAINED DEC 15 0
AROWL Average row length (Oracle result) OAVG_ROW_L DEC 7 0
HWMBL Empty blocks (kb) above High Water Mark HWBLKS_KB DEC 11 0
INDBS Used blocks of an index-Btree (kb) BBLOCKS_KB DEC 15 0