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