| General Information |
| Note |
Likely related to Workload Load Management but that is just a guess. Related to Work Request Classes. |
| Source |
$ORACLE_HOME/rdbms/admin/dbmswlm.sql |
| First Available |
11gR1 |
| Data Types |
CREATE OR REPLACE TYPE wlm_capability_object FORCE AS OBJECT (
capability VARCHAR2(30),
value VARCHAR2(30));
/
CREATE OR REPLACE TYPE wlm_capability_array AS
VARRAY(50) OF wlm_capability_object; |
| Dependencies |
| DBA_RSRC_PLANS |
DBMS_UTILITY |
V$LICENSE |
| DBA_RSRC_PLAN_DIRECTIVES |
DBMS_WLM_LIB |
V$OSSTAT |
| DBMS_ASSERT |
GV$PARAMETER |
V$PARAMETER |
| DBMS_RESOURCE_MANAGER |
GV$RSRC_PLAN |
WLM_CAPABILITY_ARRAY |
| DBMS_RMIN |
PLITBLM |
WLM_CAPABILITY_OBJECT |
| DBMS_SYS_ERROR |
V$ACTIVE_INSTANCES |
|
|
| Exceptions |
| Exception |
Description |
| ORA-44800 |
err_null_num_classifier |
| ORA-44801 |
err_null_wlm_classifiers |
| ORA-44802 |
err_no_new_cls_list |
| ORA-44803 |
err_plan_in_transition |
| ORA-44804 |
err_plan_not_created |
| ORA-44805 |
err_no_classifier |
| ORA-44806 |
err_extra_classifiers |
| ORA-44807 |
err_large_pcname |
| ORA-44808 |
err_large_wrcname |
| ORA-44809 |
err_no_expr_for_classifier |
| ORA-44810 |
err_no_param_for_expr |
| ORA-44811 |
err_large_service_name |
| ORA-44812 |
err_large_module_name |
| ORA-44813 |
err_large_action_name |
| ORA-44814 |
err_large_prog_name |
| ORA-44815 |
err_large_user_name |
| ORA-44816 |
err_zero_pcs |
| ORA-44817 |
err_large_list |
| ORA-44818 |
err_general_failure |
| ORA-44819 |
err_no_enq |
| ORA-44820 |
err_zero_wcs |
| ORA-44821 |
err_lrg_cls |
| ORA-44822 |
err_rm_plan_not_created |
| ORA-44823 |
err_rm_plan_not_inuse |
| ORA-44824 |
err_rm_is_off |
| ORA-44825 |
err_plan_unmatched |
| ORA-44826 |
err_extra_pcs |
| ORA-44827 |
err_lrg_pcs |
|
| Security Model |
Execute is granted to the DBA role |
| |
ABORT_WLMPLAN (new in 11.2.0.1)  |
| Undocumented |
dbms_wlm.abort_wlmplan; |
| exec dbms_wlm.abort_wlmplan; |
| |
| ADD_WLMCLASSIFIERS (new 11.2.0.1 parameter) |
| Undocumented |
dbms_wlm.add_wlmclassifiers(
num_clsfrs IN NUMBER,
clsfrs IN VARCHAR2,
order_seq IN NUMBER DEFAULT NULL); |
| TBD |
| |
| CHECK_RM_PLAN (new in 11.2.0.1) |
| Undocumented |
dbms_wlm.check_rm_plan(inst_name IN VARCHAR2) RETURN NUMBER; |
SQL> SELECT dbms_wlm.check_rm_plan('ORABETA') from dual;
SELECT dbms_wlm.check_rm_plan('ORABETA') from dual
*
ERROR at line 1:
ORA-44823: The QoS Resource Manager plan is not in use
ORA-06512: at "SYS.DBMS_WLM", line 351
ORA-06512: at "SYS.DBMS_WLM", line 276 |
| |
| CHECK_WLMPLAN (new in 11.2.0.1) |
| Undocumented |
dbms_wlm.check_wlmplan; |
| exec dbms_wlm.check_wlmplan; |
| |
| CREATE_WLMPLAN |
| Undocumented |
dbms_wlm.create_wlmplan(num_classifiers IN NUMBER); |
| exec dbms_wlm.create_wlmplan(111); |
| |
| DELETE_WLMPLAN |
| Undocumented |
dbms_wlm.delete_wlmplan; |
| exec dbms_wlm.delete_wlmplan; |
| |
| GET_CAPABILITIES (new in 11.2.0.3) |
| Undocumented |
dbms_wlm.get_capabilities(cap_version OUT NUMBER) RETURN wlm_capability_array; |
set serveroutput on
DECLARE
capv NUMBER;
cap_t sys.wlm_capability_array;
BEGIN
cap_t := dbms_wlm.get_capabilities(capv);
dbms_output.put_line(capv);
FOR i IN 1..cap_t.count LOOP
dbms_output.put_line('--------------------');
dbms_output.put_line(cap_t(i).capability);
dbms_output.put_line(cap_t(i).value);
END LOOP;
END;
/ |
| |
| GET_CPU_COUNT (new in 11.2.0.3) |
|
Undocumented but appears to return the number of CPU cores available for workload management under the current resource plan |
dbms_wlm.get_cpu_count(cpu_physical OUT NUMBER, cpu_count OUT NUMBER); |
set serveroutput on
DECLARE
phys NUMBER;
plan NUMBER;
BEGIN
dbms_wlm.get_cpu_count(phys, plan);
dbms_output.put_line(phys);
dbms_output.put_line(plan);
END;
/ |
| |
| SET_CPU_COUNT (new in 11.2.0.3) |
|
Undocumented but appears to set the number of CPU cores available for workload management under the current resource plan |
dbms_wlm.get_cpu_count(cpu_physical OUT NUMBER,
cpu_count OUT NUMBER,
cpu_count_value IN NUMBER); |
set serveroutput on
DECLARE
phys NUMBER;
plan NUMBER;
BEGIN
dbms_wlm.set_cpu_count(phys, plan, 1);
dbms_output.put_line(phys);
dbms_output.put_line(plan);
END;
/ |
| |
| SUBMIT_WLMPCS |
| Undocumented |
dbms_wlm.submit_wlmpcs(num_pcs IN NUMBER, pcs IN VARCHAR2); |
| TBD |
| |
| SUBMIT_WLMPLAN |
| Undocumented |
dbms_wlm.submit_wlmplan; |
| exec dbms_wlm.submit_wlmplan; |
