Data Description
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
Splunk Event
The event will look like this in Splunk:
SAP Navigation
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.
