V$LATCH_CHILDREN

This view displays statistics about child latches.

Fields

The most relevant view fields are:

• CHILD#: The child latch number

• LATCH#: The parent latch number

• NAME: The latch name

• GETS: The number of times the latch is requested in 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 section in this appendix