With the acquisition of GoldenGate, Oracle 11gR2 incorporates GoldenGate XSTREAMS technology providing client applications with the ability to insert and extract LCR datatypes directly into an implicit or explicit Stream.
To use the XSTREAMS API's, you must purchase an Oracle GoldenGate product license. See the Oracle GoldenGate documentation at http://download.oracle.com/docs/cd/E15881_01/index.htm.
The following lists views that supply helpful information for XSTREAMS:
ALL_APPLY
ALL_APPLY_ERROR
ALL_XSTREAM_INBOUND
ALL_XSTREAM_INBOUND_PROGRESS
ALL_XSTREAM_OUTBOUND
ALL_XSTREAM_OUTBOUND_PROGRESS
ALL_XSTREAM_RULES
DBA_APPLY
DBA_APPLY_ERROR
DBA_APPLY_SPILL_TXN
DBA_XSTREAM_INBOUND
DBA_XSTREAM_INBOUND_PROGRESS
DBA_XSTREAM_OUTBOUND
DBA_XSTREAM_OUTBOUND_PROGRESS
DBA_XSTREAM_RULES
XTREAMS is built on Oracle Streams infrastructure and thus can take advantage of Oracle Streams' functionality and flexibility.
The Oracle database is configured to support XSTREAMS using the DBMS_XSTREAMS_ADM
package subprograms. Specialized server processes are configured to handle inbound and outbound traffic to standard Oracle Streams queues. Outbound server processes can be created to dequeue from an existing Streams queue, or its own queue. Inbound server processes are created with their own Streams queue which can then be configured for use via normal Streams apply rule creation. These server processes are accessed via the OCI or Java API function interfaces.
XSTREAMS provides the ability to share information across a heterogeneous environment with excellent flexibility, usability, and performance. This functionality can be used as an alternative to replicating with Oracle Heterogeneous Gateways, and Java Messaging Service(JMS) clients.
For more information on XSTREAMS, please reference the Oracle Database XSTREAMS Guide.
Special Documentation Notes:
The DBMS_XSTREAM_ADM
package is documented in the Oracle Database XSTREAMS Guide rather than the Oracle PL/SQL Packages and Types Reference.
XSTREAM OCI interfaces are found in the Oracle Database XSTREAMS Guide.
XSTREAM Java API's are found in the XSTREAM Java API Reference.