Monitor transactions to track open transactions and the locks that those transactions hold. You can use ISA to monitor transactions and user sessions. ISA uses information that the following onstat command-line options generate to display session information, as the following table shows. Click the Refresh button to rerun the onstat command and display fresh information.
| To Monitor | Select on ISA | Displays the Output of | See |
|---|---|---|---|
| Transaction statistics | Users > Transaction | onstat -x | Displaying Transactions with onstat -x |
| User session statistics | Users > Threads | onstat -u | Displaying User Sessions with onstat -u |
| Lock statistics | Performance > Locks | onstat -k | Displaying Locks with onstat -k |
| Sessions running SQL statements | Users > Connections > session-id | onstat -g sql session-id | Displaying Sessions Executing SQL Statements |