What is the Combined Capture and Apply (CCA)
Oracle Streams process?
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
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
column capture_name heading
'Capture Name' format a30
column optimization heading 'CCA
Mode?' format a10
Document # 827473.1 for more details on closed capture
Get the Complete
Oracle SQL Tuning Information
The landmark book
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
for 30% off directly from the publisher.