OMSPROCEDURESTATISTICS
The system table SYSINFO.OMSPROCEDURESTATISTICS describes the activities of OMS database procedures (DB procedures) since the database system was started.
|
SCHEMANAME |
CHAR(32) |
Name of the schema to which the container belongs |
|
PROCEDURENAME |
CHAR(32) |
Name of the DB procedure = name of the C++ method that implements the DB procedure |
|
CALLCOUNT |
FIXED(20) |
Number of DB procedure calls |
|
AVGRUNTIME |
FIXED(10) |
Average execution time (ms) |
|
MINRUNTIME |
FIXED(10) |
Minimum execution time (ms) |
|
MAXRUNTIME |
FIXED(10) |
Average execution time (ms) |
|
AVGSTREAMCOMMUNICATIONTIME |
FIXED(10) |
Average stream communication time (ms) |
|
READCACHEDOBJECTCOUNT |
FIXED(20) |
Number of read accesses to the object via the OMS heap (contains READOBJECTCOUNT) |
|
READOBJECTCOUNT |
FIXED(20) |
Number of read accesses to the object that could not be performed via the OMS heap |
|
READOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of read accesses to the object within an OMS version |
|
READCACHEDOBJECTVIAKEYCOUNT |
FIXED(20) |
Number of key accesses to the object via the OMS heap (contains READOBJECTVIAKEYCOUNT) |
|
READOBJECTVIAKEYCOUNT |
FIXED(20) |
Number of key accesses to the object that could not be performed via the OMS heap |
|
UPDATECACHEDOBJECTCOUNT |
FIXED(20) |
Number of object change notices in the OMS heap |
|
UPDATEOBJECTCOUNT |
FIXED(20) |
Number of changed objects |
|
DELETECACHEDOBJECTCOUNT |
FIXED(20) |
Number of object delete notices in the OMS cache |
|
DELETEOBJECTCOUNT |
FIXED(20) |
Number of deleted objects |
|
LOCKOBJECTCOUNT |
FIXED(20) |
Number of object lock requests |
|
SCANOBJECTCOUNT |
FIXED(20) |
Number of container scans |
|
RELEASEOBJECTCOUNT |
FIXED(20) |
Number of explicitly released objects |
|
RELEASEOBJECTDONECOUNT |
FIXED(20) |
Number of explicitly released objects actually released by OMS |
|
READOBJECTHISTORYACCESSCOUNT |
FIXED(20) |
Number of history accesses triggered by read accesses to objects |
|
SCANOBJECTHISTORYACCESSCOUNT |
FIXED(20) |
Number of history accesses triggered by container scans |
|
CPPEXCEPTIONCOUNT |
FIXED(20) |
Number of C++ exceptions |
|
OUTOFDATAEXCEPTIONCOUNT |
FIXED(20) |
Number of exceptions triggered by lock requests for non-current objects |
|
TIMEOUTEXCEPTIONCOUNT |
FIXED(20) |
Number of timeouts with lock requests |
|
OUTOFMEMORYEXCEPTIONCOUNT |
FIXED(20) |
Number of occurrences of insufficient memory |
|
TERMINATECOUNT |
FIXED(20) |
Number of transaction terminations due to unforeseen errors |
|
ROLLBACKSUBTRANSCOUNT |
FIXED(20) |
Number of undone subtransactions |
|
COMMITSUBTRANSCOUNT |
FIXED(20) |
Number of successfully completed subtransactions |
|
SUBTRANSACTIONLEVEL |
FIXED(5) |
Maximum subtransaction depth |
|
READVAROBJECTCOUNT |
FIXED(20) |
Number of read variable-length objects |
|
UPDATEVAROBJECTCOUNT |
FIXED(20) |
Number of altered variable-length objects |
|
DELETEVAROBJECTCOUNT |
FIXED(20) |
Number of deleted variable-length objects |
|
AVGVAROBJECTLENGTH |
FIXED(5) |
Average length of an object of variable length |
|
CREATEVERSIONCOUNT |
FIXED(20) |
Number of created OMS versions |
|
OPENVERSIONCOUNT |
FIXED(20) |
Number of open operations on OMS versions |
|
CLOSEVERSIONCOUNT |
FIXED(20) |
Number of close operations on OMS versions |
|
DROPVERSIONCOUNT |
FIXED(20) |
Number of deleted OMS versions |
|
UPDATEOBJECTCOUNTINVERSION |
FIXED(20) |
Number of objects altered within an OMS version |
|
DELETEOBJECTCOUNTINVERSION |
FIXED(20) |
Number of objects deleted within an OMS version |
|
READOBJECTCOUNTINVERSION |
FIXED(20) |
Number of objects read within an OMS version |
|
READOBJECTVIAKEYCOUNTINVERSION |
FIXED(20) |
Number of key accesses to the object within an OMS version |
|
AVGWAITTIMEFORNEWCONSISTENTVIEW |
FIXED(20) |
Average wait time for a new consistent view (s) |
|
MINWAITTIMEFORNEWCONSISTENTVIEW |
FIXED(20) |
Minimum wait time for a new consistent view (s) |
|
MAXWAITTIMEFORNEWCONSISTENTVIEW |
FIXED(20) |
Maximum wait time for a new consistent view (s) |
|
AVGREADSTREAMBUFFERCOUNT |
FIXED(20) |
Average number of communications for reading ABAP tables |
|
MINREADSTREAMBUFFERCOUNT |
FIXED(20) |
Minimum number of communications for reading ABAP tables |
|
MAXREADSTREAMBUFFERCOUNT |
FIXED(20) |
Maximum number of communications for reading ABAP tables |
|
AVGWRITESTREAMBUFFERCOUNT |
FIXED(20) |
Average number of communications for writing ABAP tables |
|
MINWRITESTREAMBUFFERCOUNT |
FIXED(20) |
Minimum number of communications for writing ABAP tables |
|
MAXWRITESTREAMBUFFERCOUNT |
FIXED(20) |
Maximum number of communications for writing ABAP tables |
|
AVGREADSTREAMROWCOUNT |
FIXED(20) |
Average number of rows read from ABAP tables |
|
MINREADSTREAMROWCOUNT |
FIXED(20) |
Minimum number of rows read from ABAP tables |
|
MAXREADSTREAMROWCOUNT |
FIXED(20) |
Average number of rows read from ABAP tables |
|
AVGWRITESTREAMROWCOUNT |
FIXED(20) |
Average number of rows written from ABAP tables |
|
MINWRITESTREAMROWCOUNT |
FIXED(20) |
Minimum number of rows written from ABAP tables |
|
MAXWRITESTREAMROWCOUNT |
FIXED(20) |
Maximum number of rows written from ABAP tables |
|
MEMORYREQUESTCOUNT |
FIXED(10) |
Number of lock requests |
|
AVGREQUESTMEMORYCHUNKSIZE |
FIXED(10) |
Average size of a requested memory block (bytes) |
|
MINREQUESTMEMORYCHUNKSIZE |
FIXED(10) |
Smallest requested memory block (bytes) |
|
MAXREQUESTMEMORYCHUNKSIZE |
FIXED(10) |
Largest requested memory block (bytes) |
|
MEMORYRELEASECOUNT |
FIXED(10) |
Number of memory releases |
|
AVGRELEASEMEMORYCHUNKSIZE |
FIXED(10) |
Average size of a released memory block (bytes) |
|
MINRELEASEMEMORYCHUNKSIZE |
FIXED(10) |
Smallest released memory block (bytes) |
|
MAXRELEASEMEMORYCHUNKSIZE |
FIXED(10) |
Largest released memory block (bytes) |
|
AVGMEMORYDELTA |
FIXED(20) |
Average memory requirement change per procedure call |
|
MINMEMORYDELTA |
FIXED(20) |
Minimum memory requirement change for a procedure call |
|
MAXMEMORYDELTA |
FIXED(20) |
Maximum memory requirement change for a procedure call |
|
COMPONENTSIZE |
FIXED(20) |
Current size of the component instance the DB procedure belongs to (bytes) |
|
CACHEHITCOUNT |
FIXED(20) |
Number of read accesses to the object satisfied via the OMS cache |
|
CACHEMISSCOUNT |
FIXED(20) |
Number of read accesses to the object not satisfied via the OMS cache |
|
MAXCACHEHASHCHAINLENGTH |
FIXED(20) |
Maximum length of an OMS cache chain |
|
AVGHASHCHAINTRAVERSED |
FIXED(5.2) |
Average number of chain elements searched for in each object read access |
|
REHASHCOUNT |
FIXED(5) |
Number of resizings of the OMS cache |
|
LOCKOBJECTCOLLISIONCOUNT |
FIXED(20) |
Number of lock collisions |
|
AVGLOCKOBJECTWAITTIME |
FIXED(20) |
Average wait time for the release of locks (µs) |
|
SCANOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of container scans in OMS versions |
|
SCANOBJECTVIAKEYCOUNT |
FIXED(20) |
Number of key scans |
|
SCANOBJECTVIAKEYINVERSIONCOUNT |
FIXED(20) |
Number of key scans in OMS versions |
|
SCANVERSIONOBJECTCOUNT |
FIXED(20) |
Number of version object container scans |
|
SCANVERSIONOBJECTVIAKEXCOUNT |
FIXED(20) |
Number of version object key scans |
|
READCACHEDVAROBJECTCOUNT |
FIXED(20) |
Number of read variable-length objects via the OMS heap in OMS versions |
|
AVGREADVAROBJECTLENGTH |
FIXED(20) |
Average length of read variable-length objects that could not be performed via the OMS heap |
|
READVAROBJECTINVERSIONCOUNT |
FIXED(20) |
Number of read variable-length objects that could not be performed via the OMS heap in OMS versions |
|
AVGREADVAROBJECTINVERSIONLENGTH |
FIXED(20) |
Average length of read variable-length objects that could not be performed via OMS heap in OMS versions |
|
NEWOBJECTCOUNT |
FIXED(20) |
Number of new objects |
|
NEWKEYEDOBJECTCOUNT |
FIXED(20) |
Number of new keyed objects |
|
NEWVAROBJECTCOUNT |
FIXED(20) |
Number of variable-length objects |
|
NEWOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of new objects in OMS versions |
|
NEWKEYEDOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of new keyed objects in OMS versions |
|
NEWVAROBJECTINVERSIONCOUNT |
FIXED(20) |
Number of new variable-length objects in OMS versions |
|
UPDATECACHEDKEYEDOBJECTCOUNT |
FIXED(20) |
Number of keyed object change notices in the OMS heap |
|
UPDATECACHEDVAROBJECTCOUNT |
FIXED(20) |
Number of variable-length object change notices in the OMS heap |
|
AVGUPDATECACHEDVAROBJECTLENGTH |
FIXED(20) |
Average length of changed variable-length objects in the OMS heap |
|
UPDATEKEYEDOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of changed keyed objects in OMS versions |
|
UPDATEVAROBJECTINVERSIONCOUNT |
FIXED(20) |
Number of changed variable-length objects in OMS versions |
|
AVGUPDATEVAROBJECTINVERSIONLENGTH |
FIXED(20) |
Average length of changed variable-length objects in OMS versions |
|
UPDATEKEYEDOBJECTCOUNT |
FIXED(20) |
Number of changed keyed objects |
|
AVGUPDATEVAROBJECTLENGTH |
FIXED(20) |
Average length of changed variable-length objects |
|
DELETECACHEDKEYEDOBJECTCOUNT |
FIXED(20) |
Number of keyed object delete notices in the OMS cache |
|
DELETECACHEDVAROBJECTCOUNT |
FIXED(20) |
Number of variable-length object delete notices in the OMS cache |
|
DELETEKEYEDOBJECTCOUNT |
FIXED(20) |
Number of deleted keyed objects |
|
DELETEKEYEDOBJECTINVERSIONCOUNT |
FIXED(20) |
Number of deleted keyed objects in OMS versions |
|
DELETEVAROBJECTINVERSIONCOUNT |
FIXED(20) |
Number of deleted variable-length objects in OMS versions |
|
LOCKKEYEDOBJECTCOUNT |
FIXED(20) |
Number of keyed object exclusive lock requests |
|
LOCKVAROBJECTCOUNT |
FIXED(20) |
Number of variable-length object exclusive lock requests |
|
LOCKSHAREOBJECTCOUNT |
FIXED(20) |
Number of object share lock requests |
|
LOCKSHAREKEYEDOBJECTCOUNT |
FIXED(20) |
Number of keyed lock requests |
|
LOCKSHAREVAROBJECTCOUNT |
FIXED(20) |
Number of variable-length share lock requests |
|
RELEASEKEYEDOBJECTDONECOUNT |
FIXED(20) |
Number of explicitly released keyed objects actually released by OMS |
|
RELEASEVAROBJECTDONECOUNT |
FIXED(20) |
Number of explicitly released variable-length objects actually released by OMS |
|
AVGHEAPMEMORYSIZE |
FIXED(20) |
Average peak heap memory size of the component instance (bytes) |
|
MINHEAPMEMORYSIZE |
FIXED(20) |
Minimum peak heap memory size of the component instance (bytes) |
|
MAXHEAPMEMORYSIZE |
FIXED(20) |
Maximum peak heap memory size of the component instance (bytes) |
|
AVGOMSHEAPMEMORYSIZE |
FIXED(20) |
Average peak memory size of the component instance (bytes) |
|
MINOMSHEAPMEMORYSIZE |
FIXED(20) |
Minimum peak memory size of the component instance (bytes) |
|
MAXOMSHEAPMEMORYSIZE |
FIXED(20) |
Maximum peak memory size of the component instance (bytes) |
|
AVGAPPLICATIONHEAPMEMORYSIZE |
FIXED(20) |
Average peak memory size of the application component instance (bytes) |
|
MINAPPLICATIONHEAPMEMORYSIZE |
FIXED(20) |
Minimum peak memory size of the application component instance (bytes) |
|
MAXAPPLICATIONHEAPMEMORYSIZE |
FIXED(20) |
Maximum peak memory size of the application component instance (bytes) |
|
PARTITIONID |
FIXED(5) |
Identification of the partition |