HDB_PROCEDURE_STATISTICS SAP (OMS Monitor) Structure details

Dictionary Type: Structure
Description: OMS Monitor




ABAP Code to SELECT data from HDB_PROCEDURE_STATISTICS
Related tables to HDB_PROCEDURE_STATISTICS
Access table HDB_PROCEDURE_STATISTICS




Structure field list including key, data, relationships and ABAP select examples

HDB_PROCEDURE_STATISTICS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "OMS Monitor" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_HDB_PROCEDURE_STATISTICS TYPE HDB_PROCEDURE_STATISTICS.

The HDB_PROCEDURE_STATISTICS table consists of various fields, each holding specific information or linking keys about OMS Monitor data available in SAP. These include PORT (Port), OBJECT_NAME (GUID of interface that define the methods), METHOD_NAME (Name of database procedure called), CALL_COUNT (Number of database procedure calls).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP HDB_PROCEDURE_STATISTICS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
HOST Host0
PORT Port0
OBJECT_NAMEGUID of interface that define the methods LC_IIDCHAR40CHAR40
METHOD_NAMEName of database procedure called LC_METHODECHAR32CHAR32
CALL_COUNTNumber of database procedure calls LC_CALLCNTDEC20
SUM_RUN_TIMETotal Runtime for All Calls (AvgRuntime * CallCnt) LCSUMRTIMEDEC20DEC20
MAX_RUN_TIME 0
MIN_RUN_TIME 0
AVERAGE_RUN_TIMEAverage runtime in milliseconds LCAVGRTIMEDEC20(3) DEC20_D3
DEREF_COUNTNumber of dereferencings (accesses to object instances) LCOMSDEREFDEC20DEC20
DEREF_BASE_COUNTNo. of dereferencings with liveCache basis layer LC_DEREFDEC20DEC20
DEREF_BASE_IN_VERSION_COUNT 0
DEREF_KEYED_OBJECT_COUNTNumber of dereferencings with key LCKEYDEREFDEC20DEC20
DEREF_KEYED_OBJECT_BASE_COUNT 0
DEREF_KEYED_OBJECT_BASE_IN_VER 0
ITER_BASE_COUNT 0
ITER_KEYED_OBJECT_BASE_COUNT 0
ITER_BASE_IN_VERSION_COUNT 0
ITER_IN_VERSION_COUNT 0
ITER_KEYED_OBJECT_BASE_IN_VERS 0
ITER_KEYED_OBJECT_IN_VERSION_C 0
DEREF_VAR_OBJECT_COUNT 0
DEREF_VAR_OBJECT_BASE_COUNT 0
DEREF_VAR_OBJECT_BASE_SIZE 0
DEREF_VAR_OBJECT_BASE_VERS_CNT 0
DEREF_BAR_OBJECT_BASE_VER_SIZE 0
NEW_OBJECT_COUNT 0
NEW_KEYED_OBJECT_COUNT 0
NEW_VAR_OBJECT_COUNT 0
NEW_OBJECT_IN_VERSION_COUNT 0
NEW_KEYED_OBJECT_IN_VERSION_CO 0
NEW_VAR_OBJECT_IN_VERSION_COUN 0
STORE_COUNT 0
STORE_IN_VERSION_COUNT 0
STORE_KEYED_OBJECT_COUNT 0
STORE_KEYED_OBJECT_IN_VERSIONC 0
STORE_VAR_OBJECT_COUNTNumber of variable length object instances stored LCVAROBJSTDEC20DEC20
STORE_VAR_OBJECT_SIZE 0
STORE_VAR_OBJECT_IN_VERSION_CO 0
STORE_VAR_OBJECT_IN_VERSION_SI 0
STORE_BASE_COUNT 0
STORE_KEYED_OBJECT_BASE_COUNT 0
STORE_VAR_OBJECT_BASE_COUNT 0
STORE_VAR_OBJECT_BASE_SIZE 0
DELETE_COUNT 0
DELETE_KEYED_OBJECT_COUNT 0
DELETE_VAR_OBJECT_COUNT 0
DELETE_IN_VERSION_COUNT 0
DELETE_KEYED_OBJECT_IN_VERSION 0
DELETE_VAR_OBJECT_IN_VERSION_C 0
DELETE_BASE_COUNT 0
DELETE_KEYED_OBJECT_BASE_COUNT 0
DELETE_VAR_OBJECT_BASE_COUNT 0
LOCK_EXCLUSIVE_BASE_COUNTNumber of lock operations LC_LOCKDEC20DEC20
LOCK_SHARE_BASE_COUNT 0
LOCK_EXCLUSIVE_KEYED_OBJECT_BA 0
LOCK_SHARE_KEYED_OBJECT_BASE_C 0
LOCK_EXCLUSIVE_VAR_OBJECT_BASE 0
LOCK_SHARE_VAR_OBJECT_BASE_COU 0
RELEASE_CALLED_COUNT 0
RELEASE_EXECUTED_COUNT 0
RELEASE_EXECUTED_KEYED_OBJECTC 0
RELEASE_EXECUTED_VAR_OBJECT_CO 0
HISTORY_HOP_COUNTNumber of dereferencings with log access LC_LOGHOPSDEC20DEC20
ITER_HISTORY_HOP_COUNTNo. of Log Accesses for Dereferences via Container Iterator LCLOGHOPSIDEC20DEC20
EXCEPTION_COUNTNumber of C++ exceptions LC_EXCEPTDEC20DEC20
OUT_OF_DATE_EXCEPTION_COUNTNumber of out-of-date exceptions LCOUTOFDATDEC20DEC20
OUT_OF_MEMORY_EXCEPTION_COUNTOut Of Memory Exceptions LCOUTOFMEMDEC20DEC20
TIMEOUT_EXCEPTION_COUNTNumber of timeouts during lockwaits LC_TIMEOUTDEC20DEC20
OMS_TERMINATE_COUNT Procedure Calls that ended with oms_terminate0
SUBTRANSACTION_ROLLBACK_COUNTNumber of subtransactions that were rolled back LC_STROLLBDEC20DEC20
SUBTRANSACTION_COMMIT_COUNTNumber of subtransactions that were committed LCSTCOMMITDEC20DEC20
MAX_SUBTRANSACTION_LEVELMaximum levels of subtransactions LCMAXSUBTLDEC20DEC20
NEW_CONSISTENT_VIEW_COUNT 0
AVERAGE_NEW_CONSISTENT_VIEW_WAAverage wait time for omsNewConsistentView LCAVGWNCVDEC20DEC20
NEW_CONSISTENT_VIEW_MAX_WAIT_TMaximum wait time for omsNewConistentView LCMAXWNCVDEC20DEC20
KEY_CACHE_HIT_COUNT Hits in Cache Key Tree0
KEY_MISS_CACHE_HIT_COUNT Hits in Cache Miss Tree0
DEREF_VERSION_KEYED_OBJECT_COU Hits in Version Key Tree0
OMS_REHASH_COUNT Rehash Operations in OMS Cache0
AVERAGE_HASH_CHAIN_SEARCH_LENG 0
MAX_HASH_CHAIN_LENGTH Maximum Hash Key Length0
VERSION_CREATE_COUNT 0
VERSION_OPEN_COUNT 0
VERSION_CLOSE_COUNT 0
VERSION_DROP_COUNT 0
USER_ALLOC_COUNT Number of Memory Requests0
USER_MAX_CHUNK_ALLOCATED_SIZEMaximum Number of Bytes Allocated Using omsMalloc LCMALLOMAXDEC20DEC20
USER_MIN_CHUNK_ALLOCATED_SIZEMinimum Number of Bytes Allocated Using omsMalloc LCMALLOMINDEC20DEC20
USER_AVERAGE_CHUNK_ALLOCATED_SAverage Number of Bytes Allocated Using omsMalloc LCMALLOCAVDEC20DEC20
USER_DELETE_COUNT Number of Memory Releases0
USER_MAX_CHUNK_DELETED_SIZEMaximum Number of Bytes Released Using omsFree LCFREEMAXDEC20DEC20
USER_MIN_CHUNK_DELETED_SIZEMinimum Number of Bytes Released Using omsFree LCFREEMINDEC20DEC20
USER_AVERAGE_CHUNK_DELETED_SIZAverage Number of Bytes Released Using omsFree LCFREEAVGDEC20DEC20
USER_DELTA_MAX_SIZE 0
OMS_ALLOC_COUNT 0
OMS_MAX_CHUNK_ALLOCATED_SIZE 0
OMS_MIN_CHUNK_ALLOCATED_SIZE 0
OMS_AVERAGE_CHUNK_ALLOCATED_SI 0
OMS_DELETE_COUNT 0
OMS_MAX_CHUNK_DELETED_SIZE 0
OMS_MIN_CHUNK_DELETED_SIZE 0
OMS_AVERAGE_CHUNK_DELETED_SIZE 0
OMS_DELTA_MAX_SIZE 0
STREAM_COMMUNICATION_TIME 0
STREAM_READ_COUNT 0
STREAM_WRITE_COUNT 0
STREAM_READ_ROW_COUNT 0
STREAM_WRITE_ROW_COUNT 0

Key field Non-key field



How do I retrieve data from SAP structure HDB_PROCEDURE_STATISTICS using ABAP code?

As HDB_PROCEDURE_STATISTICS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on HDB_PROCEDURE_STATISTICS as there is no data to select.

How to access SAP table HDB_PROCEDURE_STATISTICS

Within an ECC or HANA version of SAP you can also view further information about HDB_PROCEDURE_STATISTICS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!