V$LOGMNR_PROCESS

V$LOGMNR_PROCESS identifies all processes attached to an active LogMiner persistent session. (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 Streams capture.) This view can be joined with either the V$SESSION view or the V$PROCESS view to gather process-specific information.

Column Datatype Description
SESSION_ID NUMBER Unique identifier for the LogMiner persistent session
PID NUMBER Oracle process identifier for the SQL Apply or Streams capture process (same as the V$PROCESS.PID)
SPID VARCHAR2(12) Operating system process identifier (same as the V$PROCESS.SPID)
ROLE VARCHAR2(32) Identifies the role of the active LogMiner process: READER, PREPARER, BUILDER, COORDINATOR, or APPLY SERVER
USERNAME VARCHAR2(15) Operating system process user name that is connected to the database
SID NUMBER Session identifier for the V$SESSION.SID process
SERIAL# NUMBER Session serial number associated with the V$SESSION.SERIAL process
LATCHWAIT VARCHAR2(8) Address of the latch the process is waiting for; NULL if none
LATCHSPIN VARCHAR2(8) This column is obsolete
WORK_MICROSEC VARCHAR2(21) Microseconds spent by the process doing useful work
OVERHEAD_MICROSEC VARCHAR2(21) Microseconds spent by the process doing overhead tasks or simply waiting/idling