Monitor transactions
You can monitor transactions to track open transactions and the locks that those transactions hold. You can use several onstat utility options to view transaction, lock, and session statistics.
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.
The following onstat command-line options display
session information.
| To monitor | Displays the output of | See |
|---|---|---|
| Transaction statistics | onstat -x | Display information about transactions |
| User session statistics | onstat -u | Display statistics on user sessions |
| Lock statistics | onstat -k | Display information about transaction locks |
| Sessions running SQL statements | onstat -g sql session-id | Display statistics on sessions executing SQL statements |