SAP ABAP Table HDB_PROCEDURE_STATISTICS (OMS Monitor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ HAN-DB (Application Component) SAP HANA Database
     ⤷ SDBA_HDB (Package) DBACOCKPIT for NewDB (HDB)

Basic Data

Table Category	INTTAB	Structure
Structure	HDB_PROCEDURE_STATISTICS	Table Relationship Diagram
Short Description	OMS Monitor

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	HOST	☐			CHAR	64	0
2	PORT	☐			NUMC	10	0
3	OBJECT_NAME	☐	LC_IID	CHAR40	CHAR	40	0	GUID of interface that define the methods
4	METHOD_NAME	☐	LC_METHODE	CHAR32	CHAR	32	0	Name of database procedure called
5	CALL_COUNT	☐	LC_CALLCNT		DEC	20	0	Number of database procedure calls
6	SUM_RUN_TIME	☐	LCSUMRTIME	DEC20	DEC	20	0	Total Runtime for All Calls (AvgRuntime * CallCnt)
7	MAX_RUN_TIME	☐			DEC	20	0
8	MIN_RUN_TIME	☐			DEC	20	0
9	AVERAGE_RUN_TIME	☐	LCAVGRTIME	DEC20_D3	DEC	20	3	Average runtime in milliseconds
10	DEREF_COUNT	☐	LCOMSDEREF	DEC20	DEC	20	0	Number of dereferencings (accesses to object instances)
11	DEREF_BASE_COUNT	☐	LC_DEREF	DEC20	DEC	20	0	No. of dereferencings with liveCache basis layer
12	DEREF_BASE_IN_VERSION_COUNT	☐			DEC	20	0
13	DEREF_KEYED_OBJECT_COUNT	☐	LCKEYDEREF	DEC20	DEC	20	0	Number of dereferencings with key
14	DEREF_KEYED_OBJECT_BASE_COUNT	☐			DEC	20	0
15	DEREF_KEYED_OBJECT_BASE_IN_VER	☐			DEC	20	0
16	ITER_BASE_COUNT	☐			DEC	20	0
17	ITER_KEYED_OBJECT_BASE_COUNT	☐			DEC	20	0
18	ITER_BASE_IN_VERSION_COUNT	☐			DEC	20	0
19	ITER_IN_VERSION_COUNT	☐			DEC	20	0
20	ITER_KEYED_OBJECT_BASE_IN_VERS	☐			DEC	20	0
21	ITER_KEYED_OBJECT_IN_VERSION_C	☐			DEC	20	0
22	DEREF_VAR_OBJECT_COUNT	☐			DEC	20	0
23	DEREF_VAR_OBJECT_BASE_COUNT	☐			DEC	20	0
24	DEREF_VAR_OBJECT_BASE_SIZE	☐			DEC	20	0
25	DEREF_VAR_OBJECT_BASE_VERS_CNT	☐			DEC	20	0
26	DEREF_BAR_OBJECT_BASE_VER_SIZE	☐			DEC	20	0
27	NEW_OBJECT_COUNT	☐			DEC	20	0
28	NEW_KEYED_OBJECT_COUNT	☐			DEC	20	0
29	NEW_VAR_OBJECT_COUNT	☐			DEC	20	0
30	NEW_OBJECT_IN_VERSION_COUNT	☐			DEC	20	0
31	NEW_KEYED_OBJECT_IN_VERSION_CO	☐			DEC	20	0
32	NEW_VAR_OBJECT_IN_VERSION_COUN	☐			DEC	20	0
33	STORE_COUNT	☐			DEC	20	0
34	STORE_IN_VERSION_COUNT	☐			DEC	20	0
35	STORE_KEYED_OBJECT_COUNT	☐			DEC	20	0
36	STORE_KEYED_OBJECT_IN_VERSIONC	☐			DEC	20	0
37	STORE_VAR_OBJECT_COUNT	☐	LCVAROBJST	DEC20	DEC	20	0	Number of variable length object instances stored
38	STORE_VAR_OBJECT_SIZE	☐			DEC	20	0
39	STORE_VAR_OBJECT_IN_VERSION_CO	☐			DEC	20	0
40	STORE_VAR_OBJECT_IN_VERSION_SI	☐			DEC	20	0
41	STORE_BASE_COUNT	☐			DEC	20	0
42	STORE_KEYED_OBJECT_BASE_COUNT	☐			DEC	20	0
43	STORE_VAR_OBJECT_BASE_COUNT	☐			DEC	20	0
44	STORE_VAR_OBJECT_BASE_SIZE	☐			DEC	20	0
45	DELETE_COUNT	☐			DEC	20	0
46	DELETE_KEYED_OBJECT_COUNT	☐			DEC	20	0
47	DELETE_VAR_OBJECT_COUNT	☐			DEC	20	0
48	DELETE_IN_VERSION_COUNT	☐			DEC	20	0
49	DELETE_KEYED_OBJECT_IN_VERSION	☐			DEC	20	0
50	DELETE_VAR_OBJECT_IN_VERSION_C	☐			DEC	20	0
51	DELETE_BASE_COUNT	☐			DEC	20	0
52	DELETE_KEYED_OBJECT_BASE_COUNT	☐			DEC	20	0
53	DELETE_VAR_OBJECT_BASE_COUNT	☐			DEC	20	0
54	LOCK_EXCLUSIVE_BASE_COUNT	☐	LC_LOCK	DEC20	DEC	20	0	Number of lock operations
55	LOCK_SHARE_BASE_COUNT	☐			DEC	20	0
56	LOCK_EXCLUSIVE_KEYED_OBJECT_BA	☐			DEC	20	0
57	LOCK_SHARE_KEYED_OBJECT_BASE_C	☐			DEC	20	0
58	LOCK_EXCLUSIVE_VAR_OBJECT_BASE	☐			DEC	20	0
59	LOCK_SHARE_VAR_OBJECT_BASE_COU	☐			DEC	20	0
60	RELEASE_CALLED_COUNT	☐			DEC	20	0
61	RELEASE_EXECUTED_COUNT	☐			DEC	20	0
62	RELEASE_EXECUTED_KEYED_OBJECTC	☐			DEC	20	0
63	RELEASE_EXECUTED_VAR_OBJECT_CO	☐			DEC	20	0
64	HISTORY_HOP_COUNT	☐	LC_LOGHOPS	DEC20	DEC	20	0	Number of dereferencings with log access
65	ITER_HISTORY_HOP_COUNT	☐	LCLOGHOPSI	DEC20	DEC	20	0	No. of Log Accesses for Dereferences via Container Iterator
66	EXCEPTION_COUNT	☐	LC_EXCEPT	DEC20	DEC	20	0	Number of C++ exceptions
67	OUT_OF_DATE_EXCEPTION_COUNT	☐	LCOUTOFDAT	DEC20	DEC	20	0	Number of out-of-date exceptions
68	OUT_OF_MEMORY_EXCEPTION_COUNT	☐	LCOUTOFMEM	DEC20	DEC	20	0	Out Of Memory Exceptions
69	TIMEOUT_EXCEPTION_COUNT	☐	LC_TIMEOUT	DEC20	DEC	20	0	Number of timeouts during lockwaits
70	OMS_TERMINATE_COUNT	☐			DEC	20	0
71	SUBTRANSACTION_ROLLBACK_COUNT	☐	LC_STROLLB	DEC20	DEC	20	0	Number of subtransactions that were rolled back
72	SUBTRANSACTION_COMMIT_COUNT	☐	LCSTCOMMIT	DEC20	DEC	20	0	Number of subtransactions that were committed
73	MAX_SUBTRANSACTION_LEVEL	☐	LCMAXSUBTL	DEC20	DEC	20	0	Maximum levels of subtransactions
74	NEW_CONSISTENT_VIEW_COUNT	☐			DEC	20	0
75	AVERAGE_NEW_CONSISTENT_VIEW_WA	☐	LCAVGWNCV	DEC20	DEC	20	0	Average wait time for omsNewConsistentView
76	NEW_CONSISTENT_VIEW_MAX_WAIT_T	☐	LCMAXWNCV	DEC20	DEC	20	0	Maximum wait time for omsNewConistentView
77	KEY_CACHE_HIT_COUNT	☐			DEC	20	0
78	KEY_MISS_CACHE_HIT_COUNT	☐			DEC	20	0
79	DEREF_VERSION_KEYED_OBJECT_COU	☐			DEC	20	0
80	OMS_REHASH_COUNT	☐			DEC	20	0
81	AVERAGE_HASH_CHAIN_SEARCH_LENG	☐			DEC	20	0
82	MAX_HASH_CHAIN_LENGTH	☐			DEC	20	0
83	VERSION_CREATE_COUNT	☐			DEC	20	0
84	VERSION_OPEN_COUNT	☐			DEC	20	0
85	VERSION_CLOSE_COUNT	☐			DEC	20	0
86	VERSION_DROP_COUNT	☐			DEC	20	0
87	USER_ALLOC_COUNT	☐			DEC	20	0
88	USER_MAX_CHUNK_ALLOCATED_SIZE	☐	LCMALLOMAX	DEC20	DEC	20	0	Maximum Number of Bytes Allocated Using omsMalloc
89	USER_MIN_CHUNK_ALLOCATED_SIZE	☐	LCMALLOMIN	DEC20	DEC	20	0	Minimum Number of Bytes Allocated Using omsMalloc
90	USER_AVERAGE_CHUNK_ALLOCATED_S	☐	LCMALLOCAV	DEC20	DEC	20	0	Average Number of Bytes Allocated Using omsMalloc
91	USER_DELETE_COUNT	☐			DEC	20	0
92	USER_MAX_CHUNK_DELETED_SIZE	☐	LCFREEMAX	DEC20	DEC	20	0	Maximum Number of Bytes Released Using omsFree
93	USER_MIN_CHUNK_DELETED_SIZE	☐	LCFREEMIN	DEC20	DEC	20	0	Minimum Number of Bytes Released Using omsFree
94	USER_AVERAGE_CHUNK_DELETED_SIZ	☐	LCFREEAVG	DEC20	DEC	20	0	Average Number of Bytes Released Using omsFree
95	USER_DELTA_MAX_SIZE	☐			DEC	20	0
96	OMS_ALLOC_COUNT	☐			DEC	20	0
97	OMS_MAX_CHUNK_ALLOCATED_SIZE	☐			DEC	20	0
98	OMS_MIN_CHUNK_ALLOCATED_SIZE	☐			DEC	20	0
99	OMS_AVERAGE_CHUNK_ALLOCATED_SI	☐			DEC	20	0
100	OMS_DELETE_COUNT	☐			DEC	20	0
101	OMS_MAX_CHUNK_DELETED_SIZE	☐			DEC	20	0
102	OMS_MIN_CHUNK_DELETED_SIZE	☐			DEC	20	0
103	OMS_AVERAGE_CHUNK_DELETED_SIZE	☐			DEC	20	0
104	OMS_DELTA_MAX_SIZE	☐			DEC	20	0
105	STREAM_COMMUNICATION_TIME	☐			DEC	20	0
106	STREAM_READ_COUNT	☐			DEC	20	0
107	STREAM_WRITE_COUNT	☐			DEC	20	0
108	STREAM_READ_ROW_COUNT	☐			DEC	20	0
109	STREAM_WRITE_ROW_COUNT	☐			DEC	20	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	732