Oracle Database 11gR2 Performance Tuning Cookbook

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 ...