SAP HANA – SQL command To Check Blocked Transactions

SQL command To Check Hana Blocked Transactions

 

[box type=”shadow” align=”” class=”” width=””]SELECT b.host, b.port, b.blocked_transaction_id AS blocked_transaction_id, t.connection_id AS lock_owner_connection_id, b.lock_owner_transaction_id AS lock_owner_transaction_id, b.blocked_time AS blocked_time, b.waiting_record_id AS waiting_record_id, b.waiting_schema_name AS waiting_schema_name, b.waiting_table_name AS waiting_table_name, b.lock_type AS lock_type, b.lock_mode AS lock_mode, c.client_host AS lock_owner_host, c.client_pid AS lock_owner_pid, c.user_name AS lock_owner_user_name, c.last_action AS lock_owner_last_action, p.statement_string AS blocked_statement_string FROM m_blocked_transactions b,m_transactions t,m_connections c,m_transactions tb, m_connections cb LEFT OUTER JOIN m_prepared_statements p ON cb.current_statement_id = p.statement_id WHERE b.lock_owner_transaction_id = t.transaction_id AND t.connection_id = c.connection_id AND b.blocked_transaction_id = tb.transaction_id AND tb.connection_id = cb.connection_id;[/box]

Leave a Reply