'Active Transactions (all nodes)' dynamically creates a list of transactions from all nodes. Every time you hit refresh, the same thread will get a new sys_id. With this in mind, I want a script that will identify long-running transactions to alert our platform support team, but a script can't see transactions on all nodes. It will only see transactions on the current node. Does anyone know how to script getting active transactions from all nodes?
