Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$LOGMNR_STATS

V$LOGMNR_STATS shows the activity currently being performed by the active LogMiner persistent sessions.

Column Datatype Description
SESSION_ID NUMBER Unique identifier for the LogMiner persistent sessions
NAME VARCHAR2(32) Name of the LogMiner statistic, state, or status, including:
  • Bytes of Redo Processed - Cumulative count of bytes processed by SQL Apply

  • Redo Records Processed - Count of redo records processed by SQL Apply

  • Txns Delivered to Client - Count of SQL transactions processed by SQL Apply

  • DML txns delivered - Count of DML transactions processed by SQL Apply

  • DDL txns delivered - Count of DDL transactions processed by SQL Apply

  • CTAS txns delivered - Count of CREATE TABLE AS SELECT (CTAS) transactions processed by SQL Apply

  • Recursive txns delivered - Count of recursive transactions processed by SQL Apply

  • Rolled back txns seen

  • LCRs delivered to client - Number of logical change records (LCRs) processed by SQL Apply

  • Bytes paged out - Cumulative count of bytes that have been paged out. LogMiner pages out memory from the LCR cache to accommodate certain ill-behaved workloads or under-configured systems. The ratio of bytes paged out to bytes of redo processed should be low. If this ratio is high (10% or higher), try increasing the MAX_SGA allocated to SQL Apply.

  • Microsecs spent in pageout - Time spent by LogMiner paging out memory from the LCR cache

  • Bytes checkpointed - Keeps track of the amount of bytes checkpointed. The mining engine takes periodic checkpoints, whereby it writes out logical change records (LCRs) pertaining to long-running transactions. The ratio of Bytes Checkpointed to Bytes of Redo Processed should be low. A high ratio (10% or higher) indicates an ill-behaved workload.

  • Microsecs spent in checkpoint - Time spent by the mining engine taking checkpoints, whereby it writes out logical change records (LCRs) pertaining to long-running transactions.

  • Bytes rolled back - Cumulative value of the number of bytes rolled back by LogMiner. There are times that LogMiner needs to backtrack and reprocess a section of the redo stream. In this case, it will roll back work it has already done. The ratio of Bytes Rolled Back to Bytes of Redo Processed should be low. If this ratio is high (10% or higher), reduce the number of PREPARER processes allocated to SQL Apply.

  • Microsecs spent in rollback - Time spent rolling back transactions already applied to the logical standby database

VALUE VARCHAR2(21) The corresponding metric value