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) |