Procedure documentationOMS Monitor Locate this document in the navigation structure

 

In the Performance user menu of the DBA Cockpit, you can find, among other things, a display of information about events of the OMS intermediate layer and liveCache basis layer for each database procedure since the last start of the liveCache Monitoring.

Procedure

Open the DBA Cockpit (transaction DBACOCKPIT) and choose   Performance   OMS Monitor  .

Result

Memory Analysis: If this status display is green, the memory analysis is running (see also: liveCache Alert Monitor, Monitor).

liveCache Monitor: If this status display is green, liveCache monitoring is activated.

Displays

The following displays are available for the database procedures:

  • Runtime

  • Object Accesses

  • Import/Export Streams

  • Memory Analysis

  • Transaction Counters

  • Cost Overview

  • Overall View

Runtime

The system displays, among other things, the following analysis data about the runtime of a database procedure:

Column

Explanation

Max./Min./Ø Runtime

Maximum, minimum, and average runtime in milliseconds

GUID

GUID of the object that defines the methods

Max./Min./Ø Wait time

Maximum, minimum and average wait time for omsNewConsistentV

Object Accesses

The information includes the following analysis data:

Column

Explanation

OMS object accesses

Number of OMS accesses to objects using OID (OMS dereferences)

Basis object accesses

Number of accesses to objects that only had to be delivered by the liveCache basis layer; that is, that did not have to be met from the OMS

Basis key accesses

Number of basis object accesses using keys

Basis iterator accesses

Number of basis object accesses using iteration from an object container

OMS memory operations

Number of OMS memory operations of objects

Basis memory operations

Number of memory operations that were performed by the liveCache basis layer

Deleted objects (OMS)

Number of deleted OMS objects

Deleted objects (Basis)

Number of objects that were deleted from the liveCache basis layer

Lock operations

Number of lock operations that were performed by the liveCache basis layer

History accesses

Number of object accesses (in pages) that required access to the log

Iterator history accesses

Number of object accesses (in pages) that required access to the log using the iterator

Loaded objects

Number of loaded objects of variable length

Stored objects

Number of stored objects of variable length

Ø Object size

Average length of an object of variable length

Import/Export Streams

Minimal/maximum/average number of communications with the buffer that were performed for the import/export of stream parameters of a database procedure and of application tables.

Minimum/maximum/average number of imported/exported lines into/out of streams and application tables.

Memory Analysis

If memory analysis is switched on, the status display memory analysis is green. The information includes the following analysis data:

Column

Explanation

Cache Size

Size of the OMS cache in bytes

MIN-/MAX-/Ø -Memory usage

Minimum, maximum and average number of bytes that were occupied using omsMalloc

MIN/MAX/Ø Memory release

Minimum, maximum and average number of bytes that were released using omsFree

Transaction Counters

Display of information about the transactions such as exceptions and timeouts. The information includes the following analysis data:

Transaction Counters

Column

Explanation

C++ Exceptions

Number of C++ exceptions that occurred

OutOfDate Exceptions

Number of OutOfDateExceptions that occurred. These occur when a lock is requested for an instance that was already changed in the meantime.

Timeouts

Number of timeouts that occurred while waiting for locks

Rollback

Number of subtransactions that were rolled back

Commit

Number of subtransactions that were ended with COMMIT

Nesting

Maximum nesting of subtransactions

OutOfMemory Exceptions

Number of OutOfMemoryExceptions that occurred

Cost Overview

To be able to evaluate the access to objects using the methods specified, average values are calculated for some of the analysis data relevant for cost determination.

More Information

Class Container