Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 09, 2015 at 09:20 PM

    Practically there is not an easy way to see the same since i dont have any blocked transaction so i dont know what unit it is in?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Martin,

      Thanks a ton for info, you know what i want in spite of me not phrasing the question correctly 😊.

      I took the help of the existing sql and then used ADD_SECONDS(CURRENT_TIMESTAMP, -600)

      Thanks again.