Monitoring latches with onstat -s

Run onstat -s to obtain general latch information. The output includes the userthread column, which lists the address of any user thread that is waiting for a latch.

You can compare this address with the user addresses in the onstat -u output to obtain the user-process identification number.

Figure 1 shows sample onstat -s output.
Figure 1. onstat -s output
Latches with lock or userthread set
name     address  lock wait userthread
LRU1     402e90   0    0        6b29d8
bf[34]   4467c0   0    0        6b29d8

Copyright© 2018 HCL Technologies Limited