SAP ABAP Table SYB_VIEW_MEMORYUSAGE_DTL (SYB: View data structure for memory uage details)

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_MEMORYUSAGE_DTL	Table Relationship Diagram
Short Description	SYB: View data structure for memory uage details

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	MEMORYUSAGE	☐	SYBMON_MEMORYUSAGE		STRU	0	0
2	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
3	MEMORYPOOLCATEGORY	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
4	MEMORYPOOLNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
5	POOLTYPE	☐			CHAR	30	0
6	TOTALSIZE_KB	☐			INT4	10	0
7	TOTALSIZE_DELTA_KB	☐			INT4	10	0
8	USEDSIZE_KB	☐			INT4	10	0
9	USEDSIZE_DELTA_KB	☐			INT4	10	0
10	FREESIZE_KB	☐			INT4	10	0
11	FREESIZE_DELTA_KB	☐			INT4	10	0
12	NUMBLOCKS	☐			INT4	10	0
13	NUMBLOCKS_DELTA	☐			INT4	10	0
14	NUMSEARCHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	NUMRETRIES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	NUMALLOCS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	NUMFREES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	NUMSLEEPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
20	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
21	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
22	TIME_PERIOD	☐			INT4	10	0
23	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
24	HISTORY	☐	SYBMON_MEMORYUSAGE_TAB		TTYP	0	0

History

Last changed by/on	SAP	20140117
SAP Release Created in	740