SAP ABAP Table SYB_XCHG_STMTCACHE (SYB: xchg data structure for statement cache)

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	SYB_XCHG_STMTCACHE	Table Relationship Diagram
Short Description	SYB: xchg data structure for statement cache

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	STATEMENT	☐	SYBMON_CACHEDSTMT		STRU	0	0
2	.INCLUDE	☐				0	0	SYB: master..monCachedStatement
3	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
4	SSQLID	☐			INT4	10	0
5	HASHKEY	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	VARIANT_CNT	☐			INT4	10	0
7	USERID	☐			STRG	0	0
8	SUSERID	☐			STRG	0	0
9	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
10	STMTTYPE	☐			STRG	0	0
11	HASAUTOPARAMS	☐			CHAR	3	0
12	PARALLELDEGREE	☐			INT2	5	0
13	QUOTEDIDENTIFIER	☐			CHAR	3	0
14	TRANSACTIONISOLATIONLEVEL	☐			STRG	0	0
15	TRANSACTIONMODE	☐			STRG	0	0
16	SAAUTHORIZATION	☐			CHAR	3	0
17	SYSTEMCATALOGUPDATE	☐			CHAR	3	0
18	CACHEDDATE	☐			STRG	0	0
19	OPTGOAL	☐			CHAR	30	0
20	OPTLEVEL	☐			CHAR	30	0
21	REMOVALDATE	☐			STRG	0	0
22	ABAP_SOURCE	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program
23	RAND_SSQLID	☐			INT4	10	0
24	TOTAL_PCT	☐			DEC	6	2
25	USECOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	STATEMENTSIZE	☐			INT4	10	0
27	MINPLANSIZEKB	☐			INT4	10	0
28	MAXPLANSIZEKB	☐			INT4	10	0
29	CURRENTUSAGECOUNT	☐			INT4	10	0
30	MAXUSAGECOUNT	☐			INT4	10	0
31	NUMRECOMPILESSCHEMACHANGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	NUMRECOMPILESPLANFLUSHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	METRICSCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	MINPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	MAXPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	AVGPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	MINLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	MAXLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	AVGLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	MINCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	MAXCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
42	AVGCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	MINELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	MAXELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	AVGELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	TOTALELAPSEDTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	TOTALCPUTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	TOTALLIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	TOTALPIO	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
50	ROWS_READ_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
51	LIO_ROWS_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
52	PIO_ROWS_PROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
53	LASTUSEDDATE	☐			STRG	0	0
54	LASTRECOMPILEDDATE	☐			STRG	0	0
55	STMT_TEXT	☐			STRG	0	0
56	SHORT_STMT_TEXT	☐			STRG	0	0
57	NUM_PLANS_CACHED	☐			INT4	10	0
58	AVGSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
59	MAXSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
60	TOTALSCANROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
61	AVGQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
62	MAXQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
63	TOTALQUALIFYINGREADROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
64	AVGQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
65	MAXQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
66	TOTALQUALIFYINGWRITEROWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
67	LOCKWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
68	LOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
69	AVGLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
70	SORTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
71	SORTSPILLEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
72	TOTALSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
73	MAXSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
74	AVGSORTTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
75	PARALLELDEGREEREDUCED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
76	PARALLELPLANRANSERIAL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
77	WORKERTHREADDEFICIT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
78	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
79	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
80	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
81	TIME_PERIOD	☐			INT4	10	0
82	BI_TOP	☐			CHAR	1	0
83	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
84	PLAN_VERSIONS	☐	SYBMON_CACHEDPROC_TAB		TTYP	0	0
85	QPLAN_VERSIONS_CACHE	☐	SYB_QPLANVERSION_TAB		TTYP	0	0
86	QPLAN_VERSIONS_DBH	☐	SYB_QPLANVERSION_TAB		TTYP	0	0
87	CURR_TOPNMETRIC	☐			STRG	0	0
88	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
89	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
90	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
91	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
92	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
93	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
94	RANGETYPE	☐			INT4	10	0
95	TIME_ZONE	☐			STRG	0	0
96	GRANULARITY	☐			INT4	10	0
97	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
98	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
99	TIME_RANGE_DESCR	☐			STRG	0	0
100	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
101	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
102	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

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