| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/utlspadv.sql |
| First Availability |
11.1 |
| Dependencies |
| DBA_STREAMS_TP_COMPONENT_STAT |
DBMS_OUTPUT |
| DBA_STREAMS_TP_PATH_BOTTLENECK |
DBMS_STREAMS_ADVISOR_ADM |
| DBMS_ASSERT |
USER_TABLES |
| DBMS_LOCK |
USER_TAB_COLUMNS |
|
| Security Model |
None: The package is not installed by
default during database creation. |
| |
| COLLECT_STATS |
Uses the Oracle Streams Performance Advisor to gather statistics about the Oracle Streams components and subcomponents in a distributed database environment. |
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 IN NUMBER DEFAULT 50,
bottleneck_flowctrl_threshold IN NUMBER DEFAULT 50); |
| exec utl_spadv.collect_stats(num_runs=>2); |
| |
| SHOW_STATS |
Generates output that includes the statistics gathered by the COLLECT_STATS procedure. |
utl_spadv.show_stats(
path_stat_table IN VARCHAR2 DEFAULT 'STREAMS$_ADVISOR_PATH_STAT',
path_id IN NUMBER DEFAULT NULL,
bgn_run_id IN NUMBER DEFAULT -1,
end_run_id IN NUMBER DEFAULT -10,
show_path_id IN BOOLEAN DEFAULT TRUE,
show_run_id IN BOOLEAN DEFAULT TRUE,
show_run_time IN BOOLEAN DEFAULT TRUE,
show_setting IN BOOLEAN DEFAULT FALSE,
show_stat IN BOOLEAN DEFAULT TRUE,
show_sess IN BOOLEAN DEFAULT FALSE,
show_legend IN BOOLEAN DEFAULT TRUE); |
set serveroutput on
exec utl_spadv.show_stats; |
