$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle UTL_SPADV Version 11.1  
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;
 
Related Topics
DBMS_STREAMS
DBMS_STREAMS_ADM
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>