The Library is currently in the process of being upgraded from Oracle Database Version 188.8.131.52 to
184.108.40.206. 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.
Also important ... there are rumors on the web about SPARC and Solaris being
discontinued. Welcome to the age of fake news. There is absolutely not a
byte of truth to these irresponsible rumors.
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);