V$LATCH

This view displays aggregate latch statistics.

Fields

The most relevant view fields are as follows:

• LATCH#: The latch number

• NAME: The latch name

• GETS: The number of times the latch is requested in the willing-to-wait mode

• MISSES: The number of times the latch is requested in willing-to-wait mode and the requestor had to wait

• SLEEPS: The number of times a willing-to-wait latch request resulted in a session sleeping

• SPIN_GETS: The number of times a willing-to-wait latch request was satisfied only after a spin

• WAIT_TIME: The elapsed time spent waiting for the latch in microseconds

• IMMEDIATE_GETS: The number of times the latch is requested in no-wait mode

• IMMEDIATE_MISSES: The number of times a no-wait latch request was unsatisfied

See also

• The V$LATCH_CHILDREN recipe in this appendix