Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-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:
|