Using the onstat Utility to Monitor Transactions

If the throughput of transactions is not very high, you can use the following onstat options to identify which transaction might be a bottleneck.

Option

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