Streams Capture Process Takes a Long Time To Start With State 'Dictionary Initialization' and Wait Event 'Control File Sequential Read' (Doc ID 406673.1)

Last updated on SEPTEMBER 07, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Checked for relevance on 03-Aug-2011

On a 10.2 database it is observed that when starting Streams capture (either for the first time or a restart) the capture process hangs for a long time before beginning to process records. 

From v$streams_capture,the stateof the process is 'DICTIONARY INITIALIZATION' and the wait event for the session is 'CONTROL FILE SEQUENTIAL READ'.  Also, there are a large number of rows in in the DBA_REGISTERED_ARCHIVED_LOG view.

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