V$LOGMNR_LATCH can be joined with the V$LATCH and the V$LATCH_CHILDREN views to obtain statistics about different latches used by active LogMiner persistent sessions. A persistent LogMiner session is created either by starting Data Guard SQL Apply on a logical standby database for the first time or by creating a Streams capture.
| Column | Datatype | Description |
|---|---|---|
SESSION_ID |
NUMBER |
Unique identifier of the LogMiner persistent session |
NAME |
VARCHAR2(32) |
Name of the Latch:
|
CHILD_ADDR |
RAW(4) |
Address of the child latch object. This column matches the corresponding ADDR column in the V$LATCH_CHLDREN view |
STATE |
VARCHAR2(6) |
State of the Latch:
|