Category: Hana Administration

SAP HANA – SQL command To Check Blocked Transactions

SQL command To Check Hana Blocked Transactions   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, …