DBA_HIST_LATCH_CHILDREN displays historical statistics about child latches. This view includes all columns of DBA_HIST_LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other. This view contains snapshots of V$LATCH_CHILDREN.
Unique snapshot ID
Database ID for the snapshot
Instance number for the snapshot
Child latch number (unique only to each parent latch)
Number of times the latch was requested in willing-to-wait mode
Number of times the latch was requested in willing-to-wait mode and the requestor had to wait
Number of times a willing-to-wait latch request resulted in a session sleeping while waiting for the latch
Number of times a latch was requested in no-wait mode
Number of times a no-wait latch request did not succeed (that is, missed)
Number of willing-to-wait latch requests which missed the first try but succeeded while spinning
SLEEP[1 | 2 | 3 | 4]
These columns have been deprecated and are present only for compatibility with previous releases of Oracle. No data is accumulated for these columns; they will always have a value of zero.
Elapsed time spent waiting for the latch (in microseconds)