Object documentationOMSPROCEDURESTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.OMSPROCEDURESTATISTICS describes the activities of OMS database procedures (DB procedures) since the database system was started.

Structure

OMSPROCEDURESTATISTICS

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)