SAP ABAP Table SYBMON_CACHEDSTMT (SYB: master..monCachedStatement)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYBMON_CACHEDSTMT	Table Relationship Diagram
Short Description	SYB: master..monCachedStatement

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	SYB: master..monCachedStatement
2	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
3	SSQLID	☐			INT4	10	0
4	HASHKEY	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
5	VARIANT_CNT	☐			INT4	10	0
6	USERID	☐			STRG	0	0
7	SUSERID	☐			STRG	0	0
8	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
9	STMTTYPE	☐			STRG	0	0
10	HASAUTOPARAMS	☐			CHAR	3	0
11	PARALLELDEGREE	☐			INT2	5	0
12	QUOTEDIDENTIFIER	☐			CHAR	3	0
13	TRANSACTIONISOLATIONLEVEL	☐			STRG	0	0
14	TRANSACTIONMODE	☐			STRG	0	0
15	SAAUTHORIZATION	☐			CHAR	3	0
16	SYSTEMCATALOGUPDATE	☐			CHAR	3	0
17	CACHEDDATE	☐			STRG	0	0
18	OPTGOAL	☐			CHAR	30	0
19	OPTLEVEL	☐			CHAR	30	0
20	REMOVALDATE	☐			STRG	0	0
21	ABAP_SOURCE	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
22	RAND_SSQLID	☐			INT4	10	0
23	TOTAL_PCT	☐			DEC	6	2
24	USECOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	STATEMENTSIZE	☐			INT4	10	0
26	MINPLANSIZEKB	☐			INT4	10	0
27	MAXPLANSIZEKB	☐			INT4	10	0
28	CURRENTUSAGECOUNT	☐			INT4	10	0
29	MAXUSAGECOUNT	☐			INT4	10	0
30	NUMRECOMPILESSCHEMACHANGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	NUMRECOMPILESPLANFLUSHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	METRICSCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	MINPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	MAXPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	AVGPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	MINLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	MAXLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	AVGLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	MINCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	MAXCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	AVGCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
42	MINELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	MAXELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	AVGELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	TOTALELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	TOTALCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	TOTALLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	TOTALPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	ROWS_READ_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
50	LIO_ROWS_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
51	PIO_ROWS_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
52	LASTUSEDDATE	☐			STRG	0	0
53	LASTRECOMPILEDDATE	☐			STRG	0	0
54	STMT_TEXT	☐			STRG	0	0
55	SHORT_STMT_TEXT	☐			STRG	0	0
56	NUM_PLANS_CACHED	☐			INT4	10	0
57	AVGSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
58	MAXSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
59	TOTALSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
60	AVGQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
61	MAXQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
62	TOTALQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
63	AVGQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
64	MAXQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
65	TOTALQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
66	LOCKWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
67	LOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
68	AVGLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
69	SORTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
70	SORTSPILLEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
71	TOTALSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
72	MAXSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
73	AVGSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
74	PARALLELDEGREEREDUCED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
75	PARALLELPLANRANSERIAL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
76	WORKERTHREADDEFICIT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
77	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
78	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
79	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
80	TIME_PERIOD	☐			INT4	10	0
81	BI_TOP	☐			CHAR	1	0
82	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname

History

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