The HDB_DBCC_OLOCK event is used in SAP to provide an overview of the acquired locks on Hana Database objects.
Potential Use Cases
This event could be used in the following scenarios:
Determine overview of locked objects(tables) i.e. lock types, object type, object name, etc.
Monitor to determine if critical objects(tables) are locked and send alerts
Determine how frequently the critical objects are locked
Can be used to find which Transactions lock critical objects and schedule the execution of such transactions accordingly
The event will look like this in Splunk:
Log in to the SAP system (having a HANA database) and execute the transaction DB01. Navigate to Diagnostics->Locks->Object Locks and currently locked objects will be displayed.
Unit of Measure
Not Applicable for this Event Type (always blank)
The date time stamp when the information was collected
Transaction object ID owning the lock
Write transaction ID owning the lock
Lock acquisition time
Lock mode: EXCLUSIVE, INTENTIONAL EXCLUSIVE
The UTC OFFSSET in HHMMSS that the data was collected in
The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.
+ | -