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 10.2.0.1 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