New features for Streams in Oracle 11g R2

There are a variety of new features for Streams in Oracle Database 11g R2 (11.2):

  • XStream
  • Statement DML Handlers
  • Ability to record table changes with Oracle Streams
  • SQL generation
  • Support for compressed tables
  • Support for SecureFile LOBS
  • Automatic split and merge
  • New Apply process parameters
  • Monitoring jobs
  • New Streams Views

XStream

XStream provides you with a set of Application Programming Interfaces (APIs) for information sharing between Oracle databases and other systems. For example, developers can use the XStream API to develop interfaces in their programs to access third-party databases, filesystems, and applications.

Statement DML Handlers

Oracle 11g R2 Streams now comes with a new type of apply handler called ...

Get Oracle 11g R1/R2 Real Application Clusters Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.