Streams Capture Process Takes a Long Time To Start With State 'Dictionary Initialization' and Wait Event 'Control File Sequential Read'
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.
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.
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