My Oracle Support Banner

Streams Complete Reference FAQ (Doc ID 752871.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 9.2 to 11.1


Purpose

This document is intended to answer Frequently Asked Questions about Streams.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 
 STREAMS CONCEPTS
 What is streams ?
 Architecture / Components of streams
 What are Rules & Rulesets ?
 What are transformations ?
 Why we need streams ?
 What are the advantages of streams over Advanced Replication ?
 What are Streams Queue Buffers ?
 What are the different types of Streams Configuration ?
 What is Spilling ?
 CanOracleStreams be used between different hardware platforms and OS versions?
 New Streams features with different versions oforacle?
 What is the significance of AQ_TM_PROCESS with respect toOracleStreams ?
 Why we need instantiation under streams environment ?
 What is streams conflict resolution ?
 What is Streams tags ?
 What is Streams Flow control ?
 What are the different states of Streams processes ?
 Streams Heterogeneous services
 What are the different SCN's with respect to Streams ?
 
 STREAMS CONFIGURATION / ADMINISTRATION
 How to set up streams ?
 How to perform Instantiation?
 How to stop/start streams components ?
 Streams Best practices
 Streams performance best practices
 How to minimize the Performance Impact of Batch Processing?
 How to convert current existing Advanced replication set up to Streams ?
 How are LOBs queued and propagated? What happens when there is an update/insert operation involving 1GB sized LOB?
 When does Streams read the Oracle on-line Redo Logs? Does the presence of Stream replication affect log-switching/archiving mechanism?
 When using Streams, how can I tell which archived logs can be removed from disk? How can I tell which archivelogs are needed by Streams capture?
 Can I still use Streams if I can't set the init.ora parameter GLOBAL_NAMES to TRUE?
 Can Streams be used to maintain availability during migrations between platforms or database upgrades?
 Backup considerations in Streams environment
 Streams Specific Patches
 How to recreate the capture process ?
 How to remove the Streams configuration ?
 Minimum Archive Log Necessary To Restart Capture Process
 Streams Idle Wait events
 Streams Configuration views
 How to Determining Latency for Streams Processes at Different States?
 Initialization Parameters Relevant to Streams
 How to Purge Apply Spill ?
 How to skip/ignore a Transaction at Apply site ?
 Upgrading the Database with Streams in place.
 Supplied PL/SQL packages for administering Streams.
 
 STREAMS TROUBLESHOOTING
 How to trace Streams components ?
 How to troubleshoot Streams components ?
 Streams Healthcheck
 Streams Monitor
 Is Streams replication certified with PeopleSoft tables? Any restrictions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.