Conclusion
In this chapter, information has been
presented on various dynamic and static views that help the DBA
understand the configuration details and the statistics of the
Streams processes.
The main points of this chapter include:
-
With the help of the dictionary
views provided, a variety of useful reports can be developed
using SQL statements. These reports show the progress and
performance load of the Streams processes.
-
Many useful queries have been
included along with sample results.
-
As part of the troubleshooting
methods, many error conditions which can abort or slow down the
Streams processes were included.
In the next chapter, details about Down
Streams capture configuration will be examined.