O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Basic XSTREAMS Configuration

As discussed in Chapter 1, GoldenGate XSTREAMS is new in 11gR2 and provides an alternative to the above traditional Heterogeneous methods. XSTREAMS technology can be used to build LCRs from Non-Oracle database log files, that can then be enqueued into an Oracle Streams queue. While much of the XSTREAM OCI and Java API usage is beyond the scope of this book, we briefly discuss the Oracle database configuration and Specialized Server processes that support XSTREAMS OCI and Java API.

The following views provide XSTREAMS configuration and performance information:

  • DBA/ALL_XSTREAM_OUTBOUND
  • DBA/ALL_XSTREAM_OUTBOUND_PROGRESS
  • DBA/ALL_XSTREAM_INBOUND
  • DBA/ALL_XSTREAM_INBOUND_PROGRESS
  • DBA/ALL_XSTREAM_RULES
  • V$STREAMS_APPLY_READER
  • V$STREAMS_APPLY_SERVER ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required