| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
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:
  |