Streams Capture Process Running Extremely Slowly With 'CPU Time' as the Top Wait Event (Doc ID 458214.1)

Last updated on JUNE 26, 2014

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

The Streams capture process is observed to be running extremely slowly in 10.1 and 10.2 Streams.  An AWR report reveals that the top wait event for the instance is 'CPU time'.  When investigating the SQL that is the biggest contributor to the CPU time, execution of a procedure called SYS.LOGMNR_GTLO3 is the top contributor to both CPU time and elapsed time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms