OMSPROCEDURESTATISTICS
The system table SYSINFO.OMSPROCEDURESTATISTICS
describes the activities of OMS database procedures (DB procedures) since the database system was started.
|
CHAR(32) |
Name of the schema to which the container belongs |
|
CHAR(32) |
Name of the DB procedure = name of the C++ method that implements the DB procedure |
|
FIXED(20) |
Number of DB procedure calls |
|
FIXED(10) |
Average execution time (ms) |
|
FIXED(10) |
Minimum execution time (ms) |
|
FIXED(10) |
Average execution time (ms) |
|
FIXED(10) |
Average stream communication time (ms) |
|
FIXED(20) |
Number of read accesses to the object via the OMS heap (contains READOBJECTCOUNT) |
|
FIXED(20) |
Number of read accesses to the object that could not be performed via the OMS heap |
|
FIXED(20) |
Number of read accesses to the object within an OMS version |
|
FIXED(20) |
Number of key accesses to the object via the OMS heap (contains READOBJECTVIAKEYCOUNT) |
|
FIXED(20) |
Number of key accesses to the object that could not be performed via the OMS heap |
|
FIXED(20) |
Number of object change notices in the OMS heap |
|
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 |
|
FIXED(20) |
Number of explicitly released objects actually released by OMS |
|
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 transaction terminations due to unforeseen errors |
|
FIXED(20) |
Number of undone subtransactions |
|
FIXED(20) |
Number of successfully completed subtransactions |
|
FIXED(5) |
Maximum subtransaction depth |
|
FIXED(20) |
Number of read variable-length objects |
|
FIXED(20) |
Number of altered variable-length objects |
|
FIXED(20) |
Number of deleted variable-length objects |
|
FIXED(5) |
Average length of an object of variable length |
|
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(20) |
Number of objects read within an OMS version |
|
FIXED(20) |
Number of key accesses to the object within an OMS version |
|
FIXED(20) |
Average wait time for a new consistent view (s) |
|
FIXED(20) |
Minimum wait time for a new consistent view (s) |
|
FIXED(20) |
Maximum wait time for a new consistent view (s) |
|
FIXED(20) |
Average number of communications for reading ABAP tables |
|
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 writing 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 rows read from ABAP tables |
|
FIXED(20) |
Minimum number of rows read from ABAP tables |
|
FIXED(20) |
Average number of rows read from ABAP tables |
|
FIXED(20) |
Average number of rows written from ABAP tables |
|
FIXED(20) |
Minimum number of rows written from ABAP tables |
|
FIXED(20) |
Maximum number of rows written from ABAP tables |
|
FIXED(10) |
Number of lock requests |
|
FIXED(10) |
Average size of a requested memory block (bytes) |
|
FIXED(10) |
Smallest requested memory block (bytes) |
|
FIXED(10) |
Largest requested memory block (bytes) |
|
FIXED(10) |
Number of memory releases |
|
FIXED(10) |
Average size of a released memory block (bytes) |
|
FIXED(10) |
Smallest released memory block (bytes) |
|
FIXED(10) |
Largest released memory block (bytes) |
|
FIXED(20) |
Average memory requirement change per procedure call |
|
FIXED(20) |
Minimum memory requirement change for a procedure call |
|
FIXED(20) |
Maximum memory requirement change for a procedure call |
|
FIXED(20) |
Current size of the component instance the DB procedure belongs to (bytes) |
|
FIXED(20) |
Number of read accesses to the object satisfied via the OMS cache |
|
FIXED(20) |
Number of read accesses to the object not satisfied via the OMS cache |
|
FIXED(20) |
Maximum length of an OMS cache chain |
|
FIXED(5.2) |
Average number of chain elements searched for in each object read access |
|
FIXED(5) |
Number of resizings of the OMS cache |
|
FIXED(20) |
Number of lock collisions |
|
FIXED(20) |
Average wait time for the release of locks (µs) |
|
FIXED(20) |
Number of container scans in OMS versions |
|
FIXED(20) |
Number of key scans |
|
FIXED(20) |
Number of key scans in OMS versions |
|
FIXED(20) |
Number of version object container scans |
|
FIXED(20) |
Number of version object key scans |
|
FIXED(20) |
Number of read variable-length objects via the OMS heap in OMS versions |
|
FIXED(20) |
Average length of read variable-length objects that could not be performed via the OMS heap |
|
FIXED(20) |
Number of read variable-length objects that could not be performed via the OMS heap in OMS versions |
|
FIXED(20) |
Average length of read variable-length objects that could not be performed via OMS heap in OMS versions |
|
FIXED(20) |
Number of new objects |
|
FIXED(20) |
Number of new keyed objects |
|
FIXED(20) |
Number of variable-length objects |
|
FIXED(20) |
Number of new objects in OMS versions |
|
FIXED(20) |
Number of new keyed objects in OMS versions |
|
FIXED(20) |
Number of new variable-length objects in OMS versions |
|
FIXED(20) |
Number of keyed object change notices in the OMS heap |
|
FIXED(20) |
Number of variable-length object change notices in the OMS heap |
|
FIXED(20) |
Average length of changed variable-length objects in the OMS heap |
|
FIXED(20) |
Number of changed keyed objects in OMS versions |
|
FIXED(20) |
Number of changed variable-length objects in OMS versions |
|
FIXED(20) |
Average length of changed variable-length objects in OMS versions |
|
FIXED(20) |
Number of changed keyed objects |
|
FIXED(20) |
Average length of changed variable-length objects |
|
FIXED(20) |
Number of keyed object delete notices in the OMS cache |
|
FIXED(20) |
Number of variable-length object delete notices in the OMS cache |
|
FIXED(20) |
Number of deleted keyed objects |
|
FIXED(20) |
Number of deleted keyed objects in OMS versions |
|
FIXED(20) |
Number of deleted variable-length objects in OMS versions |
|
FIXED(20) |
Number of keyed object exclusive lock requests |
|
FIXED(20) |
Number of variable-length object exclusive lock requests |
|
FIXED(20) |
Number of object share lock requests |
|
FIXED(20) |
Number of keyed lock requests |
|
FIXED(20) |
Number of variable-length share lock requests |
|
FIXED(20) |
Number of explicitly released keyed objects actually released by OMS |
|
FIXED(20) |
Number of explicitly released variable-length objects actually released by OMS |
|
FIXED(20) |
Average peak heap memory size of the component instance (bytes) |
|
FIXED(20) |
Minimum peak heap memory size of the component instance (bytes) |
|
FIXED(20) |
Maximum peak heap memory size of the component instance (bytes) |
|
FIXED(20) |
Average peak memory size of the component instance (bytes) |
|
FIXED(20) |
Minimum peak memory size of the component instance (bytes) |
|
FIXED(20) |
Maximum peak memory size of the component instance (bytes) |
|
FIXED(20) |
Average peak memory size of the application component instance (bytes) |
|
FIXED(20) |
Minimum peak memory size of the application component instance (bytes) |
|
FIXED(20) |
Maximum peak memory size of the application component instance (bytes) |
|
FIXED(5) |
Identification of the partition |