SAP ABAP Table DBSTATITEM (Statistical data for individual SAP tables)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	DBSTATITEM	Table Relationship Diagram
Short Description	Statistical data for individual SAP tables

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	UPDCNT	☐	UPDCNTD	DEC12	DEC	12	0	No. of UPDATE commands
2	UPDFAIL	☐	UPDFAILD	DEC12	DEC	12	0	No. of failed update commands
3	DELCNT	☐	DELCNTD	DEC12	DEC	12	0	No. of DELETE attempts
4	DELFAIL	☐	DELFAILD	DEC12	DEC	12	0	No. of failed DELETE attempts
5	INSCNT	☐	INSCNTD	DEC12	DEC	12	0	No. of INSERT attempts
6	INSFAIL	☐	INSFAILD	DEC12	DEC	12	0	No. of failed INSERT attempts
7	DIRCNT	☐	DIRCNTD	DEC12	DEC	12	0	Number of DIRECT READs
8	DIRFAIL	☐	DIRFAILD	DEC12	DEC	12	0	No. of failed SELECT SINGLE commands
9	SEQCNT	☐	SEQCNTD	DEC12	DEC	12	0	No. of SEQUENTIAL READs
10	UPD_PREP	☐	UPDPREPD	DEC12	DEC	12	0	Number of PREPAREs for UPDATE commands
11	UPD_EXEC	☐	UPDEXECD	DEC12	DEC	12	0	Number of EXECUTEs for UPDATE commands
12	UPD_ROW	☐	UPDROWD	DEC12	DEC	12	0	Number of Changed Records in a Table
13	UPD_DUR	☐	UPDDURD	DEC12	DEC	12	0	Length of UPDATE commands in milliseconds
14	DEL_PREP	☐	DELPREPD	DEC12	DEC	12	0	Number of PREPAREs for DELETE commands
15	DEL_EXEC	☐	DELEXECD	DEC12	DEC	12	0	Number of EXECUTEs for DELETE commands
16	DEL_ROW	☐	DELROWD	DEC12	DEC	12	0	Number of deleted records in a table
17	DEL_DUR	☐	DELDURD	DEC12	DEC	12	0	Length of DELETE commands in milliseconds
18	INS_PREP	☐	INSPREPD	DEC12	DEC	12	0	Number of PREPAREs for INSERT commands
19	INS_EXEC	☐	INSEXECD	DEC12	DEC	12	0	Number of EXECUTEs for INSERT commands
20	INS_ROW	☐	INSROWD	DEC12	DEC	12	0	Number of new records inserted in a table
21	INS_DUR	☐	INSDURD	DEC12	DEC	12	0	Length of INSERT commands in milliseconds
22	DIR_PREP	☐	DIRPREPD	DEC12	DEC	12	0	Number of PREPAREs for direct read commands (SELECT SINGLE)
23	DIR_OPEN	☐	DIROPEND	DEC12	DEC	12	0	Number of OPENs for direct read commands (SELECT SINGLE)
24	DIR_FETCH	☐	DIRFETCHD	DEC12	DEC	12	0	Number of FETCHes for direct read commands (SELECT SINGLE)
25	DIR_DUR	☐	DIRDURD	DEC12	DEC	12	0	Length of direct read commands in milliseconds
26	SEQ_PREP	☐	SEQPREPD	DEC12	DEC	12	0	Numbe rof PREPAREs for sequential read commands
27	SEQ_OPEN	☐	SEQOPEND	DEC12	DEC	12	0	Number of OPENs for sequential read commands
28	SEQ_FETCH	☐	SEQFETCHD	DEC12	DEC	12	0	Number of FETCHes for sequential read commands
29	SEQ_ROW	☐	SEQROWD	DEC12	DEC	12	0	Number of records read at sequential read operations
30	SEQ_DUR	☐	SEQDURD	DEC12	DEC	12	0	Length of the sequential read command in milliseconds
31	LOAD_PREP	☐	LDPREPD	DEC12	DEC	12	0	Number of PREPAREs for buffer load operations
32	LOAD_OPEN	☐	LDOPEND	DEC12	DEC	12	0	Number of OPENs for buffer load operations
33	LOAD_FETCH	☐	LDFETCHD	DEC12	DEC	12	0	Number of FETCHes for buffer load operations
34	LOAD_ROW	☐	LDROWD	DEC12	DEC	12	0	Number of records read at buffer load operations
35	LOAD_DUR	☐	LDDURD	DEC12	DEC	12	0	Length of buffer load operations in milliseconds
36	BUF_RESET	☐	PBUFRESETD	DEC12	DEC	12	0	No. of buffer resets
37	BUF_SIZE	☐	PBUFSIZED	DEC12	DEC	12	0	Size of the buffer for an object
38	BUF_SIZEMX	☐	PBUFSIZEMD	DEC12	DEC	12	0	Maximum buffer size for an object
39	BUF_RECS	☐	PBUFRECSD	DEC12	DEC	12	0	No. of buffered records for an object
40	BUF_RECSMX	☐	PBUFRECSMD	DEC12	DEC	12	0	Maximum no. of buffered records for an object
41	BUF_DIR	☐	PBUFDIRD	DEC12	DEC	12	0	No. of direct hits in the buffer
42	BUF_SEQ	☐	PBUFSEQD	DEC12	DEC	12	0	No. of sequential buffer accesses
43	REGIONS_N	☐	GENREGIOND	DEC12	DEC	12	0	No. of generic regions of a buffered table
44	SEQ_SCAN	☐	SEQ_SCAND	DEC12	DEC	12	0	No. of records read with seq. acess
45	TNAME	☐	DBSTATTABN	AS4TAB	CHAR	30	0	Table name	*
46	REF	☐	TABTYPES	TABTYPESD	CHAR	1	0	Table type (short text)
47	RNAME	☐	DBSTATSQLT	AS4TAB	CHAR	30	0	Name of the pool or cluster	*
48	BUF	☐	BUFMODE	BUFMODED	CHAR	1	0	Buffer mode of an SAP table
49	SQL	☐	SQLACCESSD	AS4FLAG	CHAR	1	0	Flag: Table processed via EXEC SQL?
50	BUF_STATE	☐	PBUFSTATE	PBUFSTATE	CHAR	1	0	Status of the table in the table buffer

History

Last changed by/on	SAP	20130604
SAP Release Created in