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 a Statement DML Handler that will process row LCRs in customizable ways by using a collection of SQL statements. These Statement DML Handlers usually provide you with better performance over procedure DML Handlers because they do not require any...
