This discussion is archived
0 Replies Latest reply: Apr 5, 2013 10:35 AM by kenkrug RSS

Hi streams latency with high logminer waits.

kenkrug Newbie
Currently Being Moderated
I'm running 11.2.0.3 DB, Local capture. Capture has a latencey 201070 seconds. It is slowely processing archive logs, but just barely. You can see from below that I have a lot of logminer waits. What can be done about high logminer waits? I'm not seeing any spill.

From the Health Check Report
++ LOGMINER READER PROCESSES ++ 


LOGMINER_READER_NAME  EVENT_COUNT  TOTAL_COUNT  PERCENTAGE  BUSY  Wait Event  
ATLPSQA$CAP - reader  1  1786  .1  YES  control file sequential read  
   10  1786  .6  YES     
   1774  1786  99.3  YES  LogMiner reader: buffer  
******************************        ----------        
TOTAL        99.9        



++ LOGMINER PREPARER PROCESSES ++ 


LOGMINER_PREPARER_NAME  EVENT_COUNT  TOTAL_COUNT  PERCENTAGE  BUSY  Wait Event  
ATLPSQA$CAP - preparer15380  50  1786  2.8  YES     
   1734  1786  97.1  YES  LogMiner preparer: memory  
******************************        ----------        
TOTAL        99.9        



++ LOGMINER BUILDER PROCESSES ++ 


LOGMINER_BUILDER_NAME  EVENT_COUNT  TOTAL_COUNT  PERCENTAGE  BUSY  Wait Event  
ATLPSQA$CAP - builder  14  1786  .8  YES     
   1685  1786  94.3  YES  LogMiner builder: memory  
******************************        ----------        
TOTAL        95.1        

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points