Skip to end of metadata
Go to start of metadata

HANA_Locks_Transactional_Current

 Display current locks, this can also be viewed in the performance tab of HANA Studio.

Input Parameters

HOST
PORT
SCHEMA_NAME
OBJECT_NAME
OBJECT_TYPE
LOCK_TYPE
MIN_LOCK_WAIT_TIME_S
ORDER_BY

Output Parameters

HOST:            Host name
PORT:            Port
OBJECT_TYPE:     Object type
OBJECT_NAME:     Object name
LOCK_TYPE:       Lock type (RECORD for row level lock, OBJECT for object level lock)
LOCKING_TID:     Transaction ID responsible for lock
LOCKING_UTID:    Update transaction ID responsible for lock
LOCK_START_TIME: Time since when the lock is held
LOCK_DURATION_S: Total duration the lock is already held
LOCK_MODE:       Lock mode

  • No labels