SAP ABAP Table STATS_MAIN_RECORD_DB (Main Statistics Record (DB Related Fields))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-PA (Application Component) Performance Analysis (Transaction ST05)
     ⤷ STATS (Package) STATS Performance Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	STATS_MAIN_RECORD_DB	Table Relationship Diagram
Short Description	Main Statistics Record (DB Related Fields)

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	.INCLUDE	☐				0	0	Statistics Sub Record with DB Related Data
2	DIR_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Request Count - Direct Read Requests
3	SEQ_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Request Count - Sequential Read Requests
4	INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Request Count - Insert Requests
5	UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Request Count - Update Requests
6	DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Request Count - Delete Requests
7	PHYSICAL_READ_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_READ	PTC_COUNT	DEC	12	0	DB Physical Request Count - Read Requests
8	PHYSICAL_INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Physical Request Count - Insert Requests
9	PHYSICAL_UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Update Requests
10	PHYSICAL_DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Delete Requests
11	DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Row Count - Direct Read Requests
12	SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Row Count - Sequential Read Requests
13	INSERT_ROW_COUNT	☐	STATS_DB_ROW_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Row Count - Insert Requests
14	UPDATE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Row Count - Update Requests
15	DELETE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Row Count - Delete Requests
16	BUFFER_DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Direct Read Requests
17	BUFFER_SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Sequential Read Requests
18	TOTAL_REQUEST_TIME	☐	STATS_DB_TIME_TOTAL	PTC_DURATION	DEC	15	0	DB Request Time [ms] - All Requests
19	DIR_READ_REQUEST_TIME	☐	STATS_DB_TIME_DIR_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Direct Read Requests
20	SEQ_READ_REQUEST_TIME	☐	STATS_DB_TIME_SEQ_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Sequential Read Requests
21	INSERT_REQUEST_TIME	☐	STATS_DB_TIME_INSERT	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Insert Requests
22	UPDATE_REQUEST_TIME	☐	STATS_DB_TIME_UPDATE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Update Requests
23	DELETE_REQUEST_TIME	☐	STATS_DB_TIME_DELETE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Delete Requests
24	DB_PROCEDURE_CALL_COUNT	☐	STATS_DB_REQ_COUNT_PROC_CALL	PTC_COUNT	DEC	12	0	DB Procedure Call Count
25	DB_PROCEDURE_TIME	☐	STATS_DB_TIME_PROC_CALL	PTC_DURATION	DEC	15	0	DB Procedure Call Time [ms]
26	ENQUEUE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_ENQUEUE	PTC_COUNT	DEC	12	0	Enqueue Count
27	ENQUEUE_TIME	☐	STATS_DB_TIME_ENQUEUE	PTC_DURATION	DEC	15	0	Enqueue Time [ms]
28	COMMIT_TIME	☐	STATS_DB_TIME_COMMIT	PTC_DURATION	DEC	15	0	Commit Time [ms]
29	TOTAL_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Request Count - All Requests
30	PHYSICAL_TOTAL_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Physical Request Count - All Requests
31	PHYSICAL_CHANGE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_CHANGE	PTC_COUNT	DEC	12	0	DB Physical Request Count - All Change Requests
32	TOTAL_ROW_COUNT	☐	STATS_DB_ROW_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Row Count - All Requests
33	BUFFER_TOTAL_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Buffer Row Count - All Requests
34	TOTAL_TIME_PER_ROW	☐	STATS_DB_TIME_TOTAL_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - All Requests
35	DIR_READ_TIME_PER_ROW	☐	STATS_DB_TIME_DIR_READ_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Direct Read Requests
36	SEQ_READ_TIME_PER_ROW	☐	STATS_DB_TIME_SEQ_READ_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Sequential Read Requests
37	INSERT_TIME_PER_ROW	☐	STATS_DB_TIME_INSERT_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Insert Requests
38	UPDATE_TIME_PER_ROW	☐	STATS_DB_TIME_UPDATE_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Update Requests
39	DELETE_TIME_PER_ROW	☐	STATS_DB_TIME_DELETE_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Delete Requests

History

Last changed by/on	SAP	20141013
SAP Release Created in	740