MONITOR_OMS
The system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_OMS
describes the activities of DB procedures (OMS procedures) since the last restart.
|
CHAR(40) |
Interface Identification of component to which the database procedure belongs |
|
CHAR(32) |
Name of the database procedure = name of the C++ method that implements the database procedure |
|
FIXED(20) |
Number of database procedure calls |
|
FIXED(10) |
Minimum runtime per database procedure call (ms) |
|
FIXED(10) |
Maximum runtime per database procedure call (ms) |
|
FIXED(10) |
Average runtime per database procedure call (ms) |
|
FIXED(20) |
Total runtime of all database procedure calls |
|
FIXED(10) |
Average stream communication runtime per database procedure call (ms) |
|
FIXED(20) |
Total stream communication runtime per database procedure call (ms) |
|
FIXED(20) |
Number of read accesses to the object via the OMS cache |
|
FIXED(20) |
Number of read accesses to the object not satisfied by the OMS cache |
|
FIXED(20) |
Number of key accesses to the object |
|
FIXED(20) |
Number of key accesses within an OMS version |
|
FIXED(20) |
Number of object change notices in the OMS cache |
|
FIXED(20) |
Number of changed objects |
|
FIXED(20) |
Number of object delete notices in the OMS cache |
|
FIXED(20) |
Number of deleted objects |
|
FIXED(20) |
Number of object lock requests |
|
FIXED(20) |
Number of container scans |
|
FIXED(20) |
Number of explicitly released objects in the OMS cache |
|
FIXED(20) |
Number of object releases actually executed in the OMS cache |
|
FIXED(20) |
Number of history accesses triggered by read accesses to objects |
|
FIXED(20) |
Number of history accesses triggered by container scans |
|
FIXED(20) |
Number of C++ exceptions |
|
FIXED(20) |
Number of exceptions triggered by lock requests for non-current objects |
|
FIXED(20) |
Number of timeouts with lock requests |
|
FIXED(20) |
Number of occurrences of insufficient memory |
|
FIXED(20) |
Number of subtransactions rolled back |
|
FIXED(20) |
Number of successfully completed subtransactions |
|
FIXED(5) |
Maximum subtransaction depth |
|
FIXED(20) |
Number of variable-length objects |
|
FIXED(20) |
Number of changed variable-length objects |
|
FIXED(5) |
Average length of an object of variable length |
|
FIXED(20) |
Memory consumption of the component instance |
|
FIXED(20) |
Maximum wait time for a new consistent view (s) |
|
FIXED(20) |
Minimum wait time for a new consistent view (s) |
|
FIXED(20) |
Average wait time for a new consistent view (s) |
|
FIXED(10) |
Number of lock requests |
|
FIXED(10) |
Smallest requested memory block (bytes) |
|
FIXED(10) |
Largest requested memory block (bytes) |
|
FIXED(10) |
Average size of a requested memory block (bytes) |
|
FIXED(10) |
Number of memory releases |
|
FIXED(10) |
Smallest released memory block (bytes) |
|
FIXED(10) |
Largest released memory block (bytes) |
|
FIXED(10) |
Average size of a released memory block (bytes) |
|
FIXED(20) |
Minimum memory requirement change for a procedure call |
|
FIXED(20) |
Maximum memory requirement change for a procedure call |
|
FIXED(20) |
Average memory requirement change per procedure call |
|
FIXED(20) |
Number of transaction failures due to unforeseen errors |
|
FIXED(20) |
Minimum number of communications for reading ABAP tables |
|
FIXED(20) |
Maximum number of communications for reading ABAP tables |
|
FIXED(20) |
Average number of communications for reading ABAP tables |
|
FIXED(20) |
Minimum number of rows read from ABAP tables |
|
FIXED(20) |
Maximum number of rows read from ABAP tables |
|
FIXED(20) |
Average number of rows read from ABAP tables |
|
FIXED(20) |
Minimum number of communications for writing ABAP tables |
|
FIXED(20) |
Maximum number of communications for writing ABAP tables |
|
FIXED(20) |
Average number of communications for writing ABAP tables |
|
FIXED(20) |
Minimum number of rows written to ABAP tables |
|
FIXED(20) |
Maximum number of rows written to ABAP tables |
|
FIXED(20) |
Average number of rows written to ABAP tables |
|
FIXED(20) |
Number of key accesses not satisfied by the key cache |
|
FIXED(20) |
Number of key accesses not satisfied by the key cache |
|
FIXED(20) |
Number of key accesses generated within an OMS version |
|
FIXED(20) |
Maximum list length of the OMS cache data structure |
|
FIXED(5) |
Average number of list elements of the OMS cache data structure searched for dereferencing an object |
|
FIXED(5) |
Number of resizings of the OMS cache data structure |
|
FIXED(20) |
Number of lock collisions |
|
FIXED(20) |
Average wait time for the release of locks (s) |
|
FIXED(20) |
Number of created OMS versions |
|
FIXED(20) |
Number of open operations on OMS versions |
|
FIXED(20) |
Number of close operations on OMS versions |
|
FIXED(20) |
Number of deleted OMS versions |
|
FIXED(20) |
Number of objects altered within an OMS version |
|
FIXED(20) |
Number of objects deleted within an OMS version |
|
FIXED(5) |
Identification of the partition |
Database Administration in CCMS, DB Procedures, OMS Monitor, Class Containers