DBA Data[Home] [Help]

PACKAGE: SYS.DBMS_WLM

Source


1 PACKAGE dbms_wlm as
2 
3 procedure create_wlmplan (num_classifiers IN number);
4 
5 procedure add_wlmclassifiers (num_clsfrs  IN number,
6                               clsfrs      IN varchar2,
7                               order_seq   IN number default null);
8 
9 procedure submit_wlmplan;
10 
11 procedure submit_wlmpcs (num_pcs IN number, pcs IN varchar2);
12 
13 procedure delete_wlmplan;
14 
15 procedure abort_wlmplan;
16 
17 procedure check_wlmplan;
18 
19 function check_rm_plan (inst_name IN varchar2) return number;
20 
21 function check_rm_enable return number;
22 
23 procedure set_rm_plan;
24 
25 procedure set_pdb_rm_plan;
26 
27 procedure set_dbi_rm_plan;
28 
29 procedure delete_cg_mappings;
30 
31 procedure update_cg_mappings(attributes IN dbms_rmin.upcgm_table_type,
32                              attribute_values IN dbms_rmin.upcgm_table_type,
33                              consumer_groups IN dbms_rmin.upcgm_table_type);
34 
35 procedure up_cg_maps;
36 
37 procedure get_pdb_info(pdb_count out number);
38 
39 function get_cdb_setting return number;
40 
41 procedure set_cdb_setting (optionmask IN number);
42 
43 procedure get_cpu_count (cpu_physical out number,
44                          cpu_count out number);
45 
46 procedure set_cpu_count (cpu_physical out number,
47                          cpu_count out number,
48                          cpu_count_value in number);
49 
50 function get_capabilities (cap_version out number) return WLM_CAPABILITY_ARRAY;
51 
52 procedure submit_wlmpcinfo (num_pcs IN number, pcinfo IN varchar2);
53 
54 function get_po_multiplier return number;
55 
56 procedure set_po_multiplier (multiplier IN number);
57 
58   -------------
59   --  CONSTANTS
60   --
61   --  Constants for use in calling arguments.
62 
63 
64   -------------------------
65   --  ERRORS AND EXCEPTIONS
66   --
67   --  When adding errors remember to add a corresponding exception below.
68 
69 
70   err_null_num_classifiers            constant number := -44800;
71   err_null_wlm_classifiers            constant number := -44801;
72   err_no_new_cls_list                 constant number := -44802;
73   err_plan_in_transition              constant number := -44803;
74   err_plan_not_created                constant number := -44804;
75   err_no_classifier                   constant number := -44805;
76   err_extra_classifiers               constant number := -44806;
77   err_large_pcname                    constant number := -44807;
78   err_large_wrcname                   constant number := -44808;
79   err_no_expr_for_classifier          constant number := -44809;
80   err_no_param_for_expr               constant number := -44810;
81   err_large_service_name              constant number := -44811;
82   err_large_module_name               constant number := -44812;
83   err_large_action_name               constant number := -44813;
84   err_large_prog_name                 constant number := -44814;
85   err_large_user_name                 constant number := -44815;
86   err_zero_pcs                        constant number := -44816;
87   err_large_list                      constant number := -44817;
88   err_general_failure                 constant number := -44818;
89   err_no_enq                          constant number := -44819;
90   err_zero_wcs                        constant number := -44820;
91   err_lrg_cls                         constant number := -44821;
92   err_rm_plan_not_created             constant number := -44822;
93   err_rm_plan_not_inuse               constant number := -44823;
94   err_rm_is_off                       constant number := -44824;
95   err_plan_unmatched                  constant number := -44825;
96   err_extra_pcs                       constant number := -44826;
97   err_lrg_pcs                         constant number := -44827;
98 
99   null_num_classifiers         EXCEPTION;
100   PRAGMA EXCEPTION_INIT(null_num_classifiers, -44800);
101   null_wlm_classifiers         EXCEPTION;
102   PRAGMA EXCEPTION_INIT(null_wlm_classifiers, -44801);
103   no_new_cls_list              EXCEPTION;
104   PRAGMA EXCEPTION_INIT(no_new_cls_list, -44802);
105   plan_in_transition           EXCEPTION;
106   PRAGMA EXCEPTION_INIT(plan_in_transition, -44803);
107   plan_not_created             EXCEPTION;
108   PRAGMA EXCEPTION_INIT(plan_not_created, -44804);
109   no_classifier                EXCEPTION;
110   PRAGMA EXCEPTION_INIT(no_classifier, -44805);
111   extra_classifiers            EXCEPTION;
112   PRAGMA EXCEPTION_INIT(extra_classifiers, -44806);
113   large_pcname                 EXCEPTION;
114   PRAGMA EXCEPTION_INIT(large_pcname, -44807);
115   large_wrcname                EXCEPTION;
116   PRAGMA EXCEPTION_INIT(large_wrcname, -44808);
117   no_expr_for_classifier       EXCEPTION;
118   PRAGMA EXCEPTION_INIT(no_expr_for_classifier, -44809);
119   no_param_for_expr            EXCEPTION;
120   PRAGMA EXCEPTION_INIT(no_param_for_expr, -44810);
121   large_service_name           EXCEPTION;
122   PRAGMA EXCEPTION_INIT(large_service_name, -44811);
123   large_module_name            EXCEPTION;
124   PRAGMA EXCEPTION_INIT(large_module_name, -44812);
125   large_action_name            EXCEPTION;
126   PRAGMA EXCEPTION_INIT(large_action_name, -44813);
127   large_prog_name              EXCEPTION;
128   PRAGMA EXCEPTION_INIT(large_prog_name, -44814);
129   large_user_name              EXCEPTION;
130   PRAGMA EXCEPTION_INIT(large_user_name, -44815);
131   zero_pcs                     EXCEPTION;
132   PRAGMA EXCEPTION_INIT(zero_pcs, -44816);
133   large_list                    EXCEPTION;
134   PRAGMA EXCEPTION_INIT(large_list, -44817);
135   general_failure              EXCEPTION;
136   PRAGMA EXCEPTION_INIT(general_failure, -44818);
137   no_enq                       EXCEPTION;
138   PRAGMA EXCEPTION_INIT(no_enq, -44819);
139   zero_wcs                     EXCEPTION;
140   PRAGMA EXCEPTION_INIT(zero_wcs, -44820);
141   lrg_cls                    EXCEPTION;
142   PRAGMA EXCEPTION_INIT(lrg_cls, -44821);
143   rm_plan_not_created        EXCEPTION;
144   PRAGMA EXCEPTION_INIT(rm_plan_not_created, -44822);
145   rm_plan_not_inuse          EXCEPTION;
146   PRAGMA EXCEPTION_INIT(rm_plan_not_inuse, -44823);
147   rm_is_off                  EXCEPTION;
148   PRAGMA EXCEPTION_INIT(rm_is_off, -44824);
149   plan_unmatched             EXCEPTION;
150   PRAGMA EXCEPTION_INIT(plan_unmatched, -44825);
151   extra_pcs                  EXCEPTION;
152   PRAGMA EXCEPTION_INIT(extra_pcs, -44826);
153   lrg_pcs                    EXCEPTION;
154   PRAGMA EXCEPTION_INIT(lrg_pcs, -44827);
155 end dbms_wlm;