The Library is currently in the process of being upgraded from Oracle Database Version 18.104.22.168 to
22.214.171.124. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain
references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Interested in Oracle GoldenGate? Check out the IGGOUG website.
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.
Constants and Variables
Bottleneck Thresholds (Variables)
Stats Retention Time (Variable)
Advisor Types (Constants)
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Analyze Streams Performance
component_name IN VARCHAR2 DEFAULT NULL,
component_db IN VARCHAR2 DEFAULT NULL,
component_type IN NUMBER DEFAULT NULL);