Skip to end of metadata
Go to start of metadata

HANA_Locks_Transactional_Total

 Show all the locks since system startup.  E.G BW jobs sometimes report multiple locks, the history of these can be seen.

Input Parameters

HOST
PORT
SCHEMA_NAME
OBJECT_NAME
OBJECT_TYPE
LOCK_TYPE
ONLY_LOCK_FAILURES
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)
LOCK_WAITS:      Number of lock waits
TOTAL_TIME_S:    Total lock wait time (in s)
AVG_TIME_S:      Average time per lock wait (in s)
LOCK_FAILURES:   Number of lock failures

 

  • No labels