Re: streams capture performance
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: "Madhu Sreeram" <madhusreeram@xxxxxxxxx>
- Date: Wed, 15 Oct 2008 20:01:43 -0700
Madhu
Here are a few more. Is there a separate ARCH process for
switching the logs to arch or is the LGWR over burdened? Do you
have any table with > 125 columns?
Recommended Patches for Streams 437838.1
Bug 6017440 - Streams capture / CDC / apply slow mining DMLs for
tables with REFRESH ON COMMIT Materialized Views
Doc ID: Note:6017440.8
Bug 5881229 - AV capture is slow Doc ID: Note:5881229.8
Bug 5370578 - Capture process slow on startup on 'control file
sequential read'
Doc ID: Note:5370578.8
Bug 5135907 - Streams capture slow when object definition is not
in dictionary
Doc ID: Note:5135907.8
Streams Capture Process Takes a Long Time To Start With State
'Dictionary Initialization' and Wait Event 'Control File
Sequential Read'
Doc ID: Note:406673.1
Streams Capture Process Running Extremely Slowly With 'CPU Time'
as the Top Wait Event
Doc ID: Note:458214.1
HTH
GovindanK
On Wed, 15 Oct 2008 17:38:54 -0500, "Madhu Sreeram" <[1]madhusreeram@gmai
l.com> said:
Yes the note#335516.1 as well as many other documents in
metalink under the "streams" knowledge browser.
Note#365648.1 seems to be relevant only for apply. I have looked
at the output of Health check specified in #273674.1 but nothing
obvious.
I have only one capture process running (there is just one
capture queue), however I set the parallelism to 4 (using:
dbms_capture_adm.set_parameter) but found no improvement with the
default (=1) .
The latency has stayed mostly the same and I do see that log
miner is processing archives constantly.
-Madhu S
On Wed, Oct 15, 2008 at 7:23 PM, GovindanK
<[2]gkatteri@xxxxxxxxxxx> wrote:
When you said Best Practice Docs did you mean Metalink Note #
335516.1 ?
Did you look at Note:365648.1 , 273674.1 ; How many capture
process are running? Does the difference always stay at 12 hrs or
it picks up sometime?
GovindanK
References
1. mailto:madhusreeram@xxxxxxxxx
2. mailto:gkatteri@xxxxxxxxxxx
Other related posts:
