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 onstat output | See |
|---|---|---|---|
| Transaction statistics, such as number of locks held and isolation level | 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 sessid | Displaying Sessions Executing SQL Statements |