MONITOR_OMS

Definition

The system table MONITOR_OMS describes the activities of DB procedures (OMS procedures) since the last restart.

Structure

MONITOR_OMS

IID

CHAR(40)

Interface ID of the component to which the DB procedure belongs

Methodname

CHAR(32)

Name of the DB procedure = name of the C++ method that implements the DB procedure

CallCnt

FIXED(10)

Number of DB procedure calls

MinRuntime

FIXED(10)

Minimum runtime per DB procedure call (ms)

MaxRuntime

FIXED(10)

Maximum runtime per DB procedure call (ms)

AvgRuntime

FIXED(38.28)

Average runtime per DB procedure call (ms)

SumRuntime

FIXED(10)

Total runtime of all DB procedure calls

OMS_Deref

FIXED(20)

Number of read accesses to the object via the OMS cache

LC_Deref

FIXED(20)

Number of read accesses to the object not satisfied by the OMS cache

KeyDeref

FIXED(20)

Number of key accesses to the object

KeyDerefInVersion

FIXED(20)

Number of key accesses within an OMS version

OMS_Store

FIXED(20)

Number of object change notices in the OMS cache

Lc_Store

FIXED(20)

Number of changed objects

OMS_Delete

FIXED(20)

Number of object delete notices in the OMS cache

LC_Delete

FIXED(20)

Number of deleted objects

LC_Lock

FIXED(20)

Number of object lock requests

DerefIter

FIXED(20)

Number of container scans

OMS_Release

FIXED(20)

Number of explicitly released objects in the OMS cache

OMS_ReleaseExecuted

FIXED(20)

Number of object releases actually executed in the OMS cache

LC_LogHops

FIXED(20)

Number of history accesses triggered by read accesses to objects

LC_LogHopsIter

FIXED(20)

Number of history accesses triggered by container scans

Exceptions

FIXED(20)

Number of C++ exceptions

OutOfDateExceptions

FIXED(20)

Number of exceptions triggered by lock requests for non-current objects

Timeouts

FIXED(20)

Number of timeouts with lock requests

OutOfMemoryExceptions

FIXED(20)

Number of occurrences of insufficient memory

SubtransRollbacks

FIXED(20)

Number of subtransactions rolled back

SubtransCommits

FIXED(20)

Number of successfully completed subtransactions

MaxSubtransLevel

FIXED(20)

Maximum subtransaction depth

VarObjectLoad  

FIXED(20)

Number of variable-length objects

VarObjectStore

FIXED(20)

Number of changed variable-length objects

AvgVarObjectSize

FIXED(20)

Average length of an object of variable length

OmsCacheSize

FIXED(20)

Memory consumption of the component instance

MaxWaitForNewConsView

FIXED(20)

Maximum wait time for a new consistent view

MinWaitForNewConsView

FIXED(20)

Minimum wait time for a new consistent view

AvgWaitForNewConsView

FIXED(20)

Average wait time for a new consistent view

MallocCnt

FIXED(20)

Number of lock requests

MallocMin

FIXED(20)

Smallest requested memory block (bytes)

MallocMax

FIXED(20)

Largest requested memory block (bytes)

MallocAvg

FIXED(20)

Average size of a requested memory block (bytes)

FreeCnt

FIXED(20)

Number of memory releases

FreeMin

FIXED(20)

Smallest released memory block (bytes)

FreeMax

FIXED(20)

Largest released memory block (bytes)

FreeAvg

FIXED(20)

Average size of a released memory block (bytes)

DeltaAllocMin

FIXED(20)

Minimum memory requirement change for a procedure call

DeltaAllocMax

FIXED(20)

Maximum memory requirement change for a procedure call

DeltaAllocAvg

FIXED(20)

Average memory requirement change per procedure call

OMS_Terminate

FIXED(20)

Number of transaction failures due to unforeseen errors

MinStreamBufferReadReq

FIXED(20)

Minimum number of communications for reading ABAP tables

MaxStreamBufferReadReq

FIXED(20)

Maximum number of communications for reading ABAP tables

AvgStreamBufferReadReq

FIXED(20)

Average number of communications for reading ABAP tables

MinStreamRowReads

FIXED(20)

Minimum number of rows read from ABAP tables

MaxStreamRowReads

FIXED(20)

Maximum number of rows read from ABAP tables

AvgStreamRowReads

FIXED(20)

Average number of rows read from ABAP tables

MinStreamBufferWriteReq

FIXED(20)

Minimum number of communications for writing ABAP tables

MaxStreamBufferWriteReq

FIXED(20)

Maximum number of communications for writing ABAP tables

AvgStreamBufferWriteReq

FIXED(20)

Average number of communications for writing ABAP tables

MinStreamRowWrites

FIXED(20)

Minimum number of rows written to ABAP tables

MaxStreamRowWrites

FIXED(20)

Maximum number of rows written to ABAP tables

AvgStreamRowWrites

FIXED(20)

Average number of rows written to ABAP tables

OmsKeyCacheHit

FIXED(20)

Number of key accesses satisfied by the key cache

OmsKeyCacheMiss

FIXED(20)

Number of key accesses not satisfied by the key cache

OmsKeyVersion

FIXED(20)

Number of key objects generated within an OMS version

OmsMaxChainLen

FIXED(20)

Maximum list length of the OMS cache data structure

OmsAvgChainLenSearched

FIXED(10.2)

Average number of list elements of the OMS cache data structure searched for dereferencing an object

OmsRehash

FIXED(20)

Number of resizings of the OMS cache data structure

OmsLockObjWaits

FIXED(20)

Number of lock collisions

OmsLockObjAvgWaitDelay

FIXED(20)

Average wait time for the release of locks (µs)

See also:

Database Administration  in CCMS: SAP liveCache Technology, DB Procedures, OMS Monitor, Class Container