Using the onstat utility to monitor transactions

If the throughput of transactions is not very high, you can use some onstat utility commands to identify a transaction that might be a bottleneck.

Use the following onstat utility commands to monitor transactions.

onstat command	Description
onstat -x	Displays transaction information such as number of locks held and isolation level.
onstat -u	Displays information about each user thread
onstat -k	Displays locks held by each session
onstat -g sql	Displays last SQL statement this session executed