DBMS_STREAMS_ADVISOR_ADM has only one package and it is
DBMS_STREAMS_ADVISOR_ADM is conceptually similar to using
DBMS_WORKLOAD_REPOSITORY PACKAGE. You create snapshots to gather data into data dictionary views. Then you can either query the related views directly or use other packages to produce a report.
Run all the scripts in the chapter as Streams Administrator. The Streams Administrator must have been granted all the necessary rights and permissions with
DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE. We also set line size 200; or you can use the
glogin.sql given in Chapter 5.
In Streams they did not call the gathering of data snapshots; that would be too easy. Instead, the Streams Administrator ...