Search This Blog

2009-09-11

Known CDC bug in Oracle 10.2.0.3.0

In Oracle Database 10.2.0.3.0 Enterprise edition, when there are more than 7 days of archive logs to catch up for CDC, it will takes forever to start

select EVENT,TOTAL_WAITS,TIME_WAITED from v$session_event where sid=&sid order by TIME_WAITED desc;
Enter value for sid: 520
old 1: select EVENT,TOTAL_WAITS,TIME_WAITED from v$session_event where sid=&sid order by TIME_WAITED desc
new 1: select EVENT,TOTAL_WAITS,TIME_WAITED from v$session_event where sid=520 order by TIME_WAITED desc

EVENT TOTAL_WAITS TIME_WAITED
------------------------------ ----------- -----------
control file sequential read 89028000000 80819836
events in waitclass Other 878085 9161229
db file sequential read 35551 2192
db file scattered read 8814 422
log file switch completion 32 51
latch: cache buffers chains 6 0
buffer busy waits 4 0

5370578: CAPTURE PROCESS SLOW ON STARTUP ON 'CONTROL FILE SEQUENTIAL READ'

No comments: