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

Copyright© 2018 HCL Technologies Limited