SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedQuery-Based Questionsm3 concurrency isolation deadlocks

Find Long-Running Open Transactions

Write SQL to list transaction_id and started_at for open transactions running more than 15 minutes.

Schema Context

tx_monitor(transaction_id, state, started_at)