SAP ABAP Table SYBMON_TABLE_PERF (SYB: Table related data (performace/IO only))

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_TABLE_PERF	Table Relationship Diagram
Short Description	SYB: Table related data (performace/IO only)

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	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
2	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
3	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
4	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
5	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
6	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
7	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
8	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
9	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
10	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
11	TIME_PERIOD	☐			INT4	10	0
12	ROWSWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	ROWSINSERTED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
14	ROWSUPDATED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	ROWSDELETED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	OPERATIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	LOCKREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	LOCKWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	LASTUSEDDATE	☐			STRG	0	0
20	LASTOPTSELECTDATE	☐			STRG	0	0
21	USEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	OPTSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
27	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
28	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
29	HKGCOVERFLOWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	HKGCPENDING_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	HKGCREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
33	TOTALLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	SHAREDLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	UPDATELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	EXCLUSIVELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	HKGCOVERFLOWSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	HKGCPENDINGDCOMP_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	HKGCREQUESTSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	IOSIZE1PAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	IOSIZE2PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
42	IOSIZE4PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	IOSIZE8PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	LASTPRSREWRITEDATE	☐			STRG	0	0
45	LASTPRSSELECTDATE	☐			STRG	0	0
46	PRSREWRITECOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	PRSSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	LEVEL0WAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	TOTALLEVEL0WAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
50	CACHE_HIT_RATIO	☐			DEC	6	2

History

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