My Oracle Support Banner

Troubleshooting Queries in Streams (Doc ID 729860.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Purpose

This Notes explains what diagnostics are required when troubleshooting the Streams processes

SCOPE & APPLICATION
To be used by DBAs as a reference when troubleshooting the Streams

This article is applicable for any platform

Version:9.2.x -10.2.x.x.x

Troubleshooting Steps

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
Troubleshooting Steps
 To determine number of messages in buffered queue
 To determine number of messages in spill-over.
 To determine memory usage
 To determine queue flow control settings
 Verify process rulesets: 
 Checks for Error Queue,conflict resolution and objects instantiated
 Latency Queries
 Determining Redo Log Scanning Latency for Each Capture Process
 Determining Message Enqueuing Latency for Each Capture Process
 Determining Capture to Dequeue Latency for a Message
 Determining latency of the propagation job
 Determining the Capture to Apply Latency for a Message for Each Apply Process
References

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