SAP ABAP Table STATS_SUB_RECORD_DB_DATA (Statistics Sub Record with DB Related Data)

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_SUB_RECORD_DB_DATA	Table Relationship Diagram
Short Description	Statistics Sub Record with DB Related Data

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	DIR_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Request Count - Direct Read Requests
2	SEQ_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Request Count - Sequential Read Requests
3	INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Request Count - Insert Requests
4	UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Request Count - Update Requests
5	DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Request Count - Delete Requests
6	PHYSICAL_READ_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_READ	PTC_COUNT	DEC	12	0	DB Physical Request Count - Read Requests
7	PHYSICAL_INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Physical Request Count - Insert Requests
8	PHYSICAL_UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Update Requests
9	PHYSICAL_DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Delete Requests
10	DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Row Count - Direct Read Requests
11	SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Row Count - Sequential Read Requests
12	INSERT_ROW_COUNT	☐	STATS_DB_ROW_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Row Count - Insert Requests
13	UPDATE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Row Count - Update Requests
14	DELETE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Row Count - Delete Requests
15	BUFFER_DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Direct Read Requests
16	BUFFER_SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Sequential Read Requests
17	TOTAL_REQUEST_TIME	☐	STATS_DB_TIME_TOTAL	PTC_DURATION	DEC	15	0	DB Request Time [ms] - All Requests
18	DIR_READ_REQUEST_TIME	☐	STATS_DB_TIME_DIR_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Direct Read Requests
19	SEQ_READ_REQUEST_TIME	☐	STATS_DB_TIME_SEQ_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Sequential Read Requests
20	INSERT_REQUEST_TIME	☐	STATS_DB_TIME_INSERT	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Insert Requests
21	UPDATE_REQUEST_TIME	☐	STATS_DB_TIME_UPDATE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Update Requests
22	DELETE_REQUEST_TIME	☐	STATS_DB_TIME_DELETE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Delete Requests
23	DB_PROCEDURE_CALL_COUNT	☐	STATS_DB_REQ_COUNT_PROC_CALL	PTC_COUNT	DEC	12	0	DB Procedure Call Count
24	DB_PROCEDURE_TIME	☐	STATS_DB_TIME_PROC_CALL	PTC_DURATION	DEC	15	0	DB Procedure Call Time [ms]
25	ENQUEUE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_ENQUEUE	PTC_COUNT	DEC	12	0	Enqueue Count
26	ENQUEUE_TIME	☐	STATS_DB_TIME_ENQUEUE	PTC_DURATION	DEC	15	0	Enqueue Time [ms]
27	COMMIT_TIME	☐	STATS_DB_TIME_COMMIT	PTC_DURATION	DEC	15	0	Commit Time [ms]

History

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