SAP HANA – How to check long serializable transactions

Check long serializable transactions

Long serializable transaction also can block Garbage collection. You can find a long serializable transaction by the following query.

And You can also  see the alert message on HANA studio.

SELECT T.HOST, T.PORT, C.LOGICAL_CONNECTION_ID, C.CLIENT_HOST, C.CLIENT_PID, T.TRANSACTION_ID, T.UPDATE_TRANSACTION_ID, SECONDS_BETWEEN(T.START_TIME, CURRENT_TIMESTAMP) TOTAL_TIME, T.MIN_MVCC_SNAPSHOT_TIMESTAMP 
   FROM M_TRANSACTIONS T, M_CONNECTIONS C
WHERE T.TRANSACTION_STATUS = 'ACTIVE' AND T.TRANSACTION_TYPE = 'USER TRANSACTION' AND T.CONNECTION_ID = C.CONNECTION_ID
   AND T.ISOLATION_LEVEL <> 'READ COMMITTED' AND SECONDS_BETWEEN(T.START_TIME, CURRENT_TIMESTAMP) > 0

Leave a Reply