Streams Capture Process Running Extremely Slowly With 'CPU Time' as the Top Wait Event
Last updated on JUNE 26, 2014
Applies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 11.2]
Information in this document applies to any platform.
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.
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