SAP ABAP Table SDBCMDSTAT (SAP DB: sysinfo.commandstatistics (Command Stats Shared SQL))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SDB (Application Component) MaxDB
     ⤷ SADA (Package) Porting and CCMS SAP DB

Basic Data

Table Category	INTTAB	Structure
Structure	SDBCMDSTAT	Table Relationship Diagram
Short Description	SAP DB: sysinfo.commandstatistics (Command Stats Shared SQL)

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	COMMANDID	☐	ADA_SYSK	CHAR16	CHAR	16	0	SAP DB: Syskey
2	INTERNAL	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
3	HASHVALUE	☐	INT4	INT4	INT4	10	0	Natural number
4	HASHTBSLOT	☐	INT4	INT4	INT4	10	0	Natural number
5	STATUS	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
6	USERNAME	☐	SDB_DBUSER	SDB_DBUSER	CHAR	64	0	SAP DB: DBUser name
7	SCHEMANAME	☐	SDB_DBUSER	SDB_DBUSER	CHAR	64	0	SAP DB: DBUser name
8	SQLMODE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
9	ISOLEVEL	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
10	DATEFORMAT	☐	CHAR15	CHAR15	CHAR	15	0	Char 15
11	MASSCMD	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
12	CODETYPE	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
13	STMNTSIZE	☐	INT4	INT4	INT4	10	0	Natural number
14	S_SQLSTMNT	☐	ADA_SSTMT	CHAR80	CHAR	80	0	SAP DB: Start of SQL command
15	PLANSIZE	☐	INT4	INT4	INT4	10	0	Natural number
16	PREPCOUNT	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE
17	REFCOUNT	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE
18	CUREXECCNT	☐	INT4	INT4	INT4	10	0	Natural number
19	EXEC_COUNT	☐	ADA_CCNT	DEC20	DEC	20	0	SAP DB: Counter for command calls
20	PREP_TIME	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
21	EXEC_TIME	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
22	AVGEXECTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
23	MINEXECTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
24	MAXEXECTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
25	ROWS_READ	☐	ADA_READ	DEC20	DEC	20	0	SAP DB: Counter for rows read
26	ROWS_QUAL	☐	ADA_QUAL	DEC20	DEC	20	0	SAP DB: Counter for qualified rows
27	VIRTUAL_R	☐	ADA_VRDS	DEC20	DEC	20	0	SAP DB: Counter for virtual reads
28	PHYS_READ	☐	ADA_PHIO	DEC20	DEC	20	0	SAP DB: Counter for physical I/O access
29	R_FETCHED	☐	ADA_RFET	DEC20	DEC	20	0	SAP DB: Counter for "gotten" rows
30	VSUSPENDS	☐	ADA_VSUS	DEC20	DEC	20	0	SAP DB: Counter for task suspensions
31	VWAITS	☐	ADA_VWAI	DEC20	DEC	20	0	SAP DB: Counter for SQL waits
32	RQ_PEREXEC	☐	ADA_RQPE	DEC20	DEC	20	0	SAP DB: Qualified rows per execution
33	VR_PEREXEC	☐	ADA_VRPE	DEC20	DEC	20	0	SAP DB: Number of page accesses per execution
34	VR_PERLINE	☐	ADA_VRPL	DEC20_2	DEC	20	2	SAP DB: Number of page accesses per row
35	TABNAME	☐	ADATABNAME	CHAR30	CHAR	30	0	SDB Table Name
36	OPERATION	☐	ADA_OP	CHAR10	CHAR	10	0	SAP DB: SQL operation
37	TOTAL_IO	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE

History

Last changed by/on	SAP	20130604
SAP Release Created in	700