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