In the Performance user menu, you can find, among other things, a display of information about events of the OMS intermediate layer and SAP liveCache basis layer for each database procedure since the last start of the liveCache Monitoring.
The user has been assigned a role in accordance with the authorization concept.
The SAP liveCache database is in the ONLINE operational state.
In the user menu, choose liveCache Assistant (transaction LC10).
Enter the name of the database connection. You can select the name from the list of existing names. You can restrict the search for the required name.
Choose
.Choose
.or
Open the DBA Cockpit (transaction DBACOCKPIT) and choose .
Memory Analysis: If this status display is green, the memory analysis is running (more information: liveCache Alert Monitor, Monitor).
liveCache Monitor: If this status display is green, liveCache monitoring is activated.
The following displays are available for the database procedures:
Runtime
Object Accesses
Import/Export Streams
Memory Analysis
Transaction Counters
Cost Overview
Overall View
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 |
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 SAP liveCache basis layer |
Deleted objects (OMS) |
Number of deleted OMS objects |
Deleted objects (Basis) |
Number of objects that were deleted from the SAP liveCache basis layer |
Lock operations |
Number of lock operations that were performed by the SAP 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 |
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.
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 |
Display of information about the transactions such as exceptions and timeouts. The information includes the following analysis data:
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 |
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.