CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [59 users online]    © 2010 psoug.org