My Oracle Support Banner

Streams Configuration Report and Health Check Script (Doc ID 273674.1)

Last updated on OCTOBER 27, 2023

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 9.2 to 12.1]
Information in this document applies to any platform.
Streams Health Check scripts provided are from 9iR2 to 12C.

How to interpret the Health Check script has been created mainly for 10GR2 and 12C outputs, but most of the information is applicable for previous releases.


To provide useful scripts that quickly retrieve all the information related to the Streams configuration in an Oracle database.

In addition, this note provides some notes and pointers that will help to better understand the output generated. To analyze properly an Streams issue it will be necessary to retrieve the Health Check output for all the databases involved in the Streams environment.

For Change Data Capture setups you use the scripts in this document, but you also have the option to run <Note 983443.1> - Change Data Capture CDC Healthcheck.


This note is intended for anyone interest on retrieving information about current status of Streams environment in the database.

The Streams Configuration Report provides key information of the Oracle Streams environment specified in an individual Oracle database. This report is useful to confirm that the pre-requisites for Streams are met as well as to identify the database objects of interest for Streams.

These scripts do not modify the Streams configuration. Each script reports important information on the setup and operation of Streams. This will provide a consistent basis upon which to understand what is happening in the environment and aid to diagnose issues.

Also note that alternatively and in newer releases of RDA you can get using similar information that Streams Health Check retrieve by using Oracle Streams Configuration Information module (STC).  So you can get this information by running



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
 Download Scripts
 How to run the script
 Interpreting the Streams Health Check script output
 Other information

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