O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DBMS_STREAMS_ADVISOR_ADM

DBMS_STREAMS_ADVISOR_ADM has only one package and it is ANALYZE_CURRENT_PERFORMANCE. Using 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.

Note

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required