Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I XStream Concepts and Use Cases

1 XStream Concepts

• About XStream
  • Licensing XStream
  • XStream and Security
  • Other Ways to Share Information in a Heterogeneous Environment
• XStream Out
  • The Outbound Server
    • Outbound Servers and Apply Process Features
  • Considerations for XStream Outbound Servers
  • XStream Out and Distributed Transactions
• XStream In
  • The Inbound Server
  • Considerations for XStream Inbound Servers
• Position Order in an LCR Stream
  • About Position Order
  • Position of LCRs and XStream Out
    • Additional Logical Change Record (LCR) Attributes Related to Position
    • The Processed Low Position and Restartability for XStream Out
    • Streaming Network Transmission
  • Position of LCRs and XStream In
  • Summary of Position Use in XStream Out and XStream In
• XStream and SQL Generation
  • Interfaces for Performing SQL Generation
  • SQL Generation Formats
  • Data Types and Character Sets
  • SQL Generation Demo

2 XStream Use Cases

• Introduction to XStream Use Cases
  • Introduction to XStream Out Use Cases
  • Introduction to XStream In Use Cases
• Replicating Data Changes With Non-Oracle Databases
• Using Files to Store Data Changes
  • XStream Demo That Replicates Database Changes Using Files
• Sharing Data Changes With a Client-Side Memory Cache

Part II XStream Administration

3 Configuring XStream

• Configuring XStream Out
  • Preparing for XStream Out
    • Decide How to Configure the Oracle Streams Components
    • Tasks to Complete Before Configuring XStream Out
  • Configuring an XStream Outbound Server
    • Configuring an Outbound Server, Queue, and Capture Process
    • Configuring an Outbound Server
  • Adding an Additional Outbound Server to a Capture Process Stream
• Configuring XStream In
  • Tasks to Complete Before Configuring XStream In
    • Configure an Oracle Streams Administrator
    • Set Initialization Parameters Relevant to Oracle Streams
    • Configure the Oracle Streams Pool
  • Configuring an XStream Inbound Server
• Sample XStream Client Application
  • Sample XStream Client Application for the Oracle Call Interface API
  • Sample XStream Client Application for the Java API

4 Managing XStream

• Managing XStream Out
  • Checking Whether a Capture Process Can Be Managed Using DBMS_XSTREAM_ADM
  • Managing Rules for an XStream Out Configuration
    • Adding Rules to an XStream Out Configuration
    • Removing Rules from an XStream Out Configuration
  • Changing the Connect User for an Outbound Server
  • Changing the Capture User of the Capture Process for an Outbound Server
  • Dropping Oracle Streams Components in an XStream Out Configuration
• Managing XStream In
  • Changing the Apply User for an Inbound Server
  • Dropping Oracle Streams Components in an XStream In Configuration

5 Monitoring XStream

• Monitoring XStream Out
  • Displaying General Information About an Outbound Server
  • Displaying Detailed Information About an Outbound Server
  • Displaying the Processed Low Position for an Outbound Server
  • Determining the Oracle Process ID and Operating System ID of an Outbound Server
  • Monitoring XStream Out Components Using General Oracle Streams Views
• Monitoring XStream In
  • Displaying General Information About an Inbound Server
  • Displaying Detailed Information About an Inbound Server
  • Displaying the Position Information for an Inbound Server
  • Determining the Process ID and Operating System ID of a Propagation Receiver
• Monitoring XStream Rules
• XStream and the Oracle Streams Performance Advisor
  • XStream Components
  • Topology and Stream Paths
  • XStream and Component-Level Statistics
  • The UTL_SPADV Package
    • Sample Output When an Outbound Server Is the Last Component in a Path
    • Sample Output When an Inbound Server Is the Last Component in a Path

6 Troubleshooting XStream

• Is an OCI Client Application Unable to Attach to the Outbound Server?
• Are Changes Failing to Reach the Client Application in XStream Out?
  • Checking Whether the Capture Process Has Fallen Behind
  • Checking for Problems with Rules and Rule-Based Transformations
  • Tracking LCRs Through a Stream
• Are LCRs Streaming from an Outbound Server Missing Extra Attributes?
• Is the Client Application Unresponsive?
• Is XStream In Unable to Identify an Inbound Server?

Part III XStream PL/SQL Packages and Types Reference

7 DBMS_XSTREAM_ADM

• Using DBMS_XSTREAM_ADM
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_XSTREAM_ADM Subprograms
  • ADD_OUTBOUND Procedure
  • ADD_SUBSET_OUTBOUND_RULES Procedure
  • ALTER_INBOUND Procedure
  • ALTER_OUTBOUND Procedure
  • CREATE_INBOUND Procedure
  • CREATE_OUTBOUND Procedure
  • DROP_INBOUND Procedure
  • DROP_OUTBOUND Procedure
  • REMOVE_SUBSET_OUTBOUND_RULES Procedure

8 Addendum To DBMS_APPLY_ADM

• DBMS_APPLY_ADM Subprograms and Outbound Servers
• DBMS_APPLY_ADM Subprograms and Inbound Servers

9 Addendum To DBMS_STREAMS_ADM

• Inbound Server Creation and Apply User
• XStream Inbound Server Rules for LCRs
• XStream Outbound Server Rules for LCRs

10 Addendum To Logical Change Record Types

• Logical Change Record Constructors
  • DDL Logical Change Record Constructor
  • Row Logical Change Record Constructor
• Functions Related to XStream
  • GET_COMMIT_SCN_FROM_POSITION Static Function
    • Syntax
    • Parameters
  • GET_SCN_FROM_POSITION Static Function
    • Syntax
    • Parameters
  • GET_POSITION Member Function
    • Syntax

Part IV XStream OCI API Reference

11 Introduction to the OCI Interface for XStream

• Using the XStream Interface
  • XStream Out
    • LCR Streams
    • The Processed Low Position and Restart Considerations
  • XStream In
    • Processed Low Position and Restart Ability
    • Stream Position
  • Security of XStream
  • XStream and Character Sets
• Handler and Descriptor Attributes
  • Conventions
  • Server Handle Attributes
    • OCI_ATTR_XSTREAM_ACK_INTERVAL
    • OCI_ATTR_XSTREAM_IDLE_TIMEOUT

12 OCI XStream Functions

• Introduction to XStream Functions
  • Conventions for OCI Functions
  • Purpose
  • Syntax
  • Parameters
  • Comments
• OCI XStream Functions
  • OCILCRAttributesGet()
  • OCILCRAttributesSet()
  • OCILCRFree()
  • OCILCRDDLInfoGet()
  • OCILCRHeaderGet()
  • OCILCRRowStmtGet()
  • OCILCRRowStmtWithBindVarGet()
  • OCILCRNew()
  • OCILCRRowColumnInfoGet()
  • OCILCRRowColumnInfoSet()
  • OCILCRDDLInfoSet()
  • OCILCRHeaderSet()
  • OCILCRLobInfoGet()
  • OCILCRLobInfoSet()
  • OCILCRSCNsFromPosition()
  • OCILCRSCNToPosition()
  • OCILCRWhereClauseGet()
  • OCILCRWhereClauseWithBindVarGet()
  • OCIXStreamInAttach()
  • OCIXStreamInDetach()
  • OCIXStreamInLCRSend()
  • OCIXStreamInLCRCallbackSend()
  • OCIXStreamInProcessedLWMGet()
  • OCIXStreamInFlush()
  • OCIXStreamInChunkSend()
  • OCIXStreamOutAttach()
  • OCIXStreamOutDetach()
  • OCIXStreamOutLCRReceive()
  • OCIXStreamOutLCRCallbackReceive()
  • OCIXStreamOutProcessedLWMSet()
  • OCIXStreamOutChunkReceive()

Part V XStream Data Dictionary Views

13 XStream Static Data Dictionary Views

• 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

14 XStream Dynamic Performance (V$) Views

• V$STREAMS_APPLY_READER
• V$STREAMS_APPLY_SERVER
• V$STREAMS_CAPTURE
• V$STREAMS_MESSAGE_TRACKING
• V$STREAMS_TRANSACTION

Index