APPENDIX CStreams Health Check Report
The Oracle-provided Streams Health Check script produces a comprehensive report of the Streams environment in the database. The script for your version of the database can be downloaded from the My Oracle Support website. MOS note 27367.1 has links to download the script.
Oracle Support will ask for the Health Check (HC) report from all Streams databases when you open a service request for any Streams-related issue. Depending on your Streams environment, the generated report may be very detailed. It may also take some time to run the script.
The HC report provides complete information about the Streams environment in the database. You can use this information to confirm that the Streams setup has been done ...