Question:
What is the Combined Capture and Apply (CCA)
Oracle Streams process?
Answer:
The
combined capture and apply (CCA) is new in Oracle 11g
and it optimized the capture and apply processes by
combining the steps.
The CCA is implemented by default whenever possible.
In CCA, a propagation is configured, Streams does not use
the propagation..
Instead, Streams passes the replicated information
directly from capture to a epply server.
Here is a test to see if CCA is implemented in your
Streams configuration:
column capture_name heading
'Capture Name' format a30
column optimization heading 'CCA
Mode?' format a10
select
capture_name,
decode(optimization,
0,
'No',
'Yes') optimization
from
v$streams_capture;
See MOSC
Document # 827473.1 for more details on closed capture
and apply.
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|