This screenshot shows the Overview subpage of the Streams page. The top of the page has the following subpage links: Overview, Capture, Propagation, Apply, and Messaging. Below the subpage links is a Refresh button and a View Data list. Below the list are the Capture, Propagation, Apply, and Messaging sections:
The Capture section includes:
Capture Processes with an associated number link
Capture Processes Having Errors with an associated number
The Propagation section includes:
Propagation Jobs with an associated number link
Propagation Errors with an associated number
The Apply section includes:
Apply Processes with an associated number link
Apply Processes Having Errors with an associated number
The Messaging section includes:
Queue Tables with an associated number link
Queues with an associated number link
Total Propagation Errors with an associated number
On the right side of the page is an Overview section with the following text:
"Oracle Streams enables information sharing. Oracle Streams can share database changes and other information in a stream, which can propagate events within a database or from one database to another. The specified information is routed to specified destinations. The result is a feature that provides greater functionality and flexibility than traditional solutions for capturing and managing information, and sharing the information with other databases and applications.
- A capture process is an Oracle background process that scans the database redo log to capture DML and DDL changes made to database objects. It formats these changes into events called logical change records (LCRs) and enqueues them into a queue.
- Propagations send events from one queue to another, and these queues can be in the same database or in different databases.
- An apply process is an Oracle background process that dequeues events from a queue and applies each event directly to a database object or sends events to apply handlers for custom processing.
- Oracle Streams Messaging, also called as Oracle Streams Advanced Queuing, provides database-integrated message queuing functionality."