Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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) Address of the latch the process is spinning on; NULL if none
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