Monitoring latches with onstat -p

Run onstat -p to obtain the values in the lchwaits field. This field stores the number of times that a thread was required to wait for a shared-memory latch.

Figure 1 shows an excerpt of sample onstat -p output that shows the lchwaits field.
Figure 1. Partial onstat -p output showing the lchwaits field
ixda-RA  idx-RA   da-RA   logrec-RA    RA-pgsused  lchwaits 
5        0        204      0           148         12 

Copyright© 2020 HCL Technologies Limited