Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Blocked transactions view in hana

Hi All,

M_BLOCKED_TRANSACTIONS view contains BLOCKED_TIME as one of the column, what is the unit it is in?

Is it seconds or minutes?

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/a8c51d75191014b6c0e177ae946724/content.htm

Message was edited by: Tom Flanagan

Tags:
Former Member
Former Member replied

BLOCKED_TIME is a timestamp (start of the blocking situation), so it doesn't have a dedicated unit. You may have a look at SQL: "HANA_Locks_Transactional_LockWaits" (SAP Note 1969700) to understand how to display the timestamp and how to calculate the number of seconds between the BLOCKED_TIME and the current timestamp:

  TO_CHAR(T.BLOCKED_TIME, 'YYYY/MM/DD HH24:MI:SS') WAIT_SINCE,

  LPAD(SECONDS_BETWEEN(T.BLOCKED_TIME, CURRENT_TIMESTAMP), 7) WAIT_S,

If you want to substract 10 minutes from the current timestamp, you can use:

ADD_SECONDS(CURRENT_TIMESTAMP, -600)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question