0 Replies Latest reply: Apr 5, 2013 12:35 PM by kenkrug RSS

    Hi streams latency with high logminer waits.

    kenkrug
      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