From being lost without a map to using DBMS_STREAMS_ADVISOR_ADM and UTL_SPADV to map out the Streams environment, this was a quick ride on how to be a cartographer for your Streams environment.

We used DBMS_STREAMS_ADVISOR_ADM for mapping out Streams and immediate troubleshooting. Then we moved on to setting up UTL_SPADV for the automated collection of Advisor Runs. Some of the minor concerns relating to UTL_SPADV were also covered. Those issues will most likely go away with the usage and maturity of UTL_SPADV.