8.28 V$LATCH_CHILDREN
V$LATCH_CHILDREN
displays statistics about child latches.
This view includes all columns of V$LATCH
plus the CHILD#
column. Note that child latches have the same parent if their LATCH#
columns match each other.
Column | Datatype | Description |
---|---|---|
|
|
Address of the latch object |
|
|
Latch number of the parent latch |
|
|
Child latch number (unique only to each parent latch) |
|
|
Latch level |
|
|
Latch name |
|
|
Latch hash |
|
|
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 requester 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) |
|
|
This column has been deprecated and is present only for compatibility with previous releases of Oracle. No data is accumulated for this column; it will always have a value of zero. |
|
|
This column has been deprecated and is present only for compatibility with previous releases of Oracle. No data is accumulated for this column; it will always have a value of zero. |
|
|
Willing-to-wait latch requests which missed the first try but succeeded while spinning |
|
|
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. As a substitute for these columns you can query the appropriate rows of the |
|
|
Elapsed time spent waiting for the latch (in microseconds) |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
"V$LATCH"