| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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 ADDRcolumn in theV$LATCH_CHLDRENview | 
| STATE | VARCHAR2(6) | State of the Latch: 
 |