Creating Queues and Queue tables
The CNUM_MSGS column shows the cumulative
total number of messages enqueued into the buffered queue since
the buffered queue was created. This information is useful for
monitoring the Capture process activity and to examine the load
patterns etc.
Configuration Flow
In general, a simple Streams configuration
of Capture, Propagation and Apply involves the creation of
certain entities, as shown below:
At the Source database:
-
A SYS.AnyData queue
-
Supplemental Logging specifications to the
objects
-
Capture process
-
Propagation process and schedule
-
Rule sets for the Capture process and the
propagation
-
Each shared object prepared for
instantiation
At the Destination Database:
-
A SYS.AnyData queue
-
Instantiation SCN set for each shared
object
-
An Apply process for the source database
-
Rule sets for the Apply process
Next, the configuration details on how to create the Capture,
Propagation and Apply Process and how to manage them will be
presented. As the process details are introduced, a simple
example will also be provided. The example will cover scenarios
where the goal is to replicate data:
