SAP ABAP Table /SDF/DB6_STATEMENT (SQL Statement KPIs)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/DB6_INFR_7X (Package) Data Collectors for DB6 - OO

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/DB6_STATEMENT	Table Relationship Diagram
Short Description	SQL Statement KPIs

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	ANALYSIS_ID	☐			CHAR	19	0
2	STMT_NUM	☐			INT4	10	0
3	STMT_ID	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
4	NUM_EXECUTIONS	☐			DEC	22	0
5	NUM_COMPILATIONS	☐			DEC	22	0
6	TOTAL_EXEC_TIME	☐			DEC	22	0
7	TOTAL_EXEC_TIME_MS	☐			DEC	22	0
8	TOTAL_EXEC_TIME_MILLISEC	☐			DEC	22	0
9	TOTAL_EXEC_TIME_PC	☐			DEC	22	2
10	AVERAGE_EXEC_TIME_MILLISEC	☐			DEC	22	0
11	BUFFER_QUALITY_PC	☐			DEC	22	2
12	POOL_DATA_P_READS	☐			DEC	22	0
13	POOL_TEMP_DATA_L_READS	☐			DEC	22	0
14	POOL_TEMP_DATA_P_READS	☐			DEC	22	0
15	POOL_INDEX_L_READS	☐			DEC	22	0
16	POOL_INDEX_P_READS	☐			DEC	22	0
17	POOL_TEMP_INDEX_L_READS	☐			DEC	22	0
18	POOL_TEMP_INDEX_P_READS	☐			DEC	22	0
19	POOL_XDA_L_READS	☐			DEC	22	0
20	POOL_XDA_P_READS	☐			DEC	22	0
21	POOL_TEMP_XDA_L_READS	☐			DEC	22	0
22	POOL_TEMP_XDA_P_READS	☐			DEC	22	0
23	TOTAL_USR_CPU_TIME	☐			DEC	22	0
24	TOTAL_USR_CPU_TIME_MS	☐			DEC	22	0
25	TOTAL_USR_CPU_TIME_MILLISEC	☐			DEC	22	0
26	TOTAL_SYS_CPU_TIME	☐			DEC	22	0
27	TOTAL_SYS_CPU_TIME_MS	☐			DEC	22	0
28	TOTAL_SYS_CPU_TIME_MILLISEC	☐			DEC	22	0
29	ROWS_READ	☐			DEC	22	0
30	ROWS_READ_PC	☐			DEC	22	2
31	ROWS_WRITTEN	☐			DEC	22	0
32	ROWS_WRITTEN_PC	☐			DEC	22	2
33	INT_ROWS_DELETED	☐			DEC	22	0
34	INT_ROWS_INSERTED	☐			DEC	22	0
35	INT_ROWS_UPDATED	☐			DEC	22	0
36	STMT_SORTS	☐			DEC	22	0
37	SORT_OVERFLOWS	☐			DEC	22	0
38	TOTAL_SORT_TIME	☐			DEC	22	0
39	PREP_TIME_WORST	☐			DEC	22	0
40	PREP_TIME_BEST	☐			DEC	22	0
41	DBPARTITIONNUM	☐			DEC	22	0
42	ABAP_SOURCE	☐			CHAR	40	0
43	ABAP_LINE	☐			CHAR	10	0
44	POOL_DATA_L_READS	☐			DEC	22	0
45	STATS_FABRICATE_TIME	☐			DEC	22	0
46	SYNC_RUNSTATS_TIME	☐			DEC	22	0
47	ROWS_RETURNED	☐			DEC	22	0
48	ROWS_RETURNED_PC	☐			DEC	22	2

History

Last changed by/on	SAP	20140922
SAP Release Created in	2008_1_700