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

UTL_SPADV

The DBA's time is precious. So, automate and stop wasting it on mundane and tedious tasks. That is what UTL_SPADV does; it automates the collection of statistics related to Streams performance. UTL_SPADV is simple to use and once configured, you can forget about it. Then take it to the next level and automated custom reports against the data collected.

UTL_SPADV has six subprograms. Following are their names along with their definitions:

  • UTL_SPADV.COLLECT_STATS
    UTL_SPADV.COLLECT_STATS( interval IN NUMBER DEFAULT 60, num_runs IN NUMBER DEFAULT 10, comp_stat_table IN VARCHAR2 DEFAULT 'STREAMS$_ADVISOR_COMP_STAT', path_stat_table IN VARCHAR2 DEFAULT 'STREAMS$_ADVISOR_PATH_STAT', top_event_threshold IN NUMBER DEFAULT 15, bottleneck_idle_threshold ...

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