My Oracle Support Banner

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 AUGUST 04, 2018

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.