The system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_OMS describes the activities of DB procedures (OMS procedures) since the last restart.
IID |
CHAR(40) |
Interface ID of component to which the DB procedure belongs |
Method name |
CHAR(32) |
Name of the DB procedure = name of the C++ method that implements the DB procedure |
CallCnt |
FIXED(20) |
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(10) |
Average runtime per DB procedure call (ms) |
SumRuntime |
FIXED(20) |
Total runtime of all DB procedure calls |
AvgStreamCommunicationTime |
FIXED(10) |
Average stream communication runtime per DB procedure call (ms) |
SumStreamCommunicationTime |
FIXED(20) |
Total stream communication runtime per DB procedure call (ms) |
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(5) |
Maximum subtransaction depth |
VarObjectLoad |
FIXED(20) |
Number of variable-length objects |
VarObjectStore |
FIXED(20) |
Number of changed variable-length objects |
AvgVarObjectSize |
FIXED(5) |
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 (s) |
MinWaitForNewConsView |
FIXED(20) |
Minimum wait time for a new consistent view (s) |
AvgWaitForNewConsView |
FIXED(20) |
Average wait time for a new consistent view (s) |
MallocCnt |
FIXED(10) |
Number of lock requests |
MallocMin |
FIXED(10) |
Smallest requested memory block (bytes) |
MallocMax |
FIXED(10) |
Largest requested memory block (bytes) |
MallocAvg |
FIXED(10) |
Average size of a requested memory block (bytes) |
FreeCnt |
FIXED(10) |
Number of memory releases |
FreeMin |
FIXED(10) |
Smallest released memory block (bytes) |
FreeMax |
FIXED(10) |
Largest released memory block (bytes) |
FreeAvg |
FIXED(10) |
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 not satisfied by the key cache |
OmsKeyCacheMiss |
FIXED(20) |
Number of key accesses not satisfied by the key cache |
OmsKeyVersion |
FIXED(20) |
Number of key accesses generated within an OMS version |
OmsMaxChainLen |
FIXED(20) |
Maximum list length of the OMS cache data structure |
OmsAvgChainLenSearched |
FIXED(5) |
Average number of list elements of the OMS cache data structure searched for dereferencing an object |
OmsRehash |
FIXED(5) |
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) |
CreateVersion |
FIXED(20) |
Number of created OMS versions |
OpenVersion |
FIXED(20) |
Number of open operations on OMS versions |
CloseVersion |
FIXED(20) |
Number of close operations on OMS versions |
DropVersion |
FIXED(20) |
Number of deleted OMS versions |
StoreInVersion |
FIXED(20) |
Number of objects altered within an OMS version |
DeleteInVersion |
FIXED(20) |
Number of objects deleted within an OMS version |
Database Administration in CCMS, DB Procedures, OMS Monitor, Class Containers