1 PACKAGE dbms_streams_advisor_adm AUTHID CURRENT_USER AS
2
3 -- Retention time for keeping statistics collected. Default 24 hours.
4 retention_time NUMBER := 24;
5
6 -------------------------------------------------------------
7 -- PACKAGE VARIABLES
8 -------------------------------------------------------------
9 -- A streams component is eligible for bottleneck analysis only if its
10 -- busiest session has statistic IDLE (in percentage) not greater than
11 -- the specified "bottleneck_idle_threshold" and statistic FLOW CONTROL
12 -- (in percentage) not greater than "bottleneck_flowctrl_threshold".
13 --
14 -- By default, a component cannot be bottleneck if its busiest session
15 -- is idle or in flow control for more than 50 percent of the measured
16 -- time period.
17 bottleneck_idle_threshold NUMBER := 50;
18 bottleneck_flowctrl_threshold NUMBER := 50;
19
20 -------------------------------------------------------------
21 -- CONSTANTS
22 -------------------------------------------------------------
23 -- component type constant, should be consistent with constants defined
24 -- for _DBA_STREAMS_COMPONENT in drep.bsq
25 capture_type CONSTANT NUMBER := 1;
26 propagation_sender_type CONSTANT NUMBER := 2;
27 propagation_receiver_type CONSTANT NUMBER := 3;
28 apply_type CONSTANT NUMBER := 4;
29 queue_type CONSTANT NUMBER := 5;
30 extract_type CONSTANT NUMBER := 6;
31 replicat_type CONSTANT NUMBER := 7;
32
33 -- Analyzes performance on a given system, including calculating the
34 -- bottleneck components of each streams, the rate of each component on that
35 -- streams, and, if specified, recommendations on how to improve performance
36 -- Parameters
37 -- component_name: analyze streams containing the component with this name
38 -- component_db : analyze streams containing the component with this
39 -- database name
40 -- component_type: analyze streams containing the component of this type
41 -- NOTE: component_name, component_type, and component_db MUST all be
42 -- specified or NULL
43 --
44 PROCEDURE analyze_current_performance(
45 component_name IN VARCHAR2 DEFAULT NULL,
46 component_db IN VARCHAR2 DEFAULT NULL,
47 component_type IN NUMBER DEFAULT NULL);
48
49 END dbms_streams_advisor_adm;