Oracle DBMS_STREAMS_ADVISOR_ADM
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Analyzes performance on a given system, including calculating the bottleneck components of each streams, the rate of each component on that
streams, and, if specified, recommendations on how to improve performance.

NOTE: component_name, component_type, and component_db MUST all be specified or NULL.
AUTHID CURRENT_USER
Constants and Variables
Name Data Type Value
Bottleneck Thresholds (Variables)
bottleneck_flowctrl_threshold NUMBER 50
bottleneck_idle_threshold NUMBER 50
Stats Retention Time (Variable)
retention_time NUMBER 24
Advisor Types (Constants)
capture_type NUMBER 1
propagation_sender_type NUMBER 2
propagation_receiver_type NUMBER 3
apply_type NUMBER 4
queue_type NUMBER 5
extract_type NUMBER 6
replicat_type NUMBER 7
Data Types  
Dependencies
DBMS_LOGREP_UTIL DBMS_STREAMS_ADV_ADM_UTL DBMS_STREAMS_ADV_ADM_UTL_INVOK
DBMS_STREAMS_ADM    
Documented No
First Available 10gR2
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
 
ANALYZE_CURRENT_PERFORMANCE
Analyze Streams Performance dbms_streams_advisor_adm.analyze_current_performance(
component_name IN VARCHAR2 DEFAULT NULL,
component_db   IN VARCHAR2 DEFAULT NULL,
component_type IN NUMBER   DEFAULT NULL);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved