Another option to view/monitor opened transactions directly from System Management Portal is to use the System Dashboard (System Operation -> System Dashboard). No need to write code or SQL, just a few clicks.
In System Dashboard there is a line "Transactions":
In case one or more transactions is/are opened for more then 20 minutes (or so...) the System Dashboard shows a Troubled state.
In System Dashboard, if you click the "Transactions" label (regardless of Troubled state) then at the bottom of the page a link "Click here for more details" is displayed:
If/when "Click here for more details" is clicked a page with top 5 transactions (longer time) are displayed:

From there you can click the Process ID and go directly to the Process Details page.
- Log in to post comments