SAP ABAP Table SYB_VIEW_TABLES_PERF_DTL (SYB: View data for Table Details (IO/Performance))

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_VIEW_TABLES_PERF_DTL	Table Relationship Diagram
Short Description	SYB: View data for Table Details (IO/Performance)

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