CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_WLM
Version 11.1
 
General
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
Dependencies
DBMS_WLM_LIB

Exceptions
Name Data Type Value
err_null_num_classifier NUMBER -44800
err_null_wlm_classifiers NUMBER -44801
err_no_new_cls_list NUMBER -44802
err_plan_in_transition NUMBER -44803
err_plan_not_created NUMBER -44804
err_no_classifier NUMBER -44805
err_extra_classifiers NUMBER -44806
err_large_pcname NUMBER -44807
err_large_wrcname NUMBER -44808
err_no_expr_for_classifier NUMBER -44809
err_no_param_for_expr NUMBER -44810
err_large_service_name NUMBER -44811
err_large_module_name NUMBER -44812
err_large_action_name NUMBER -44813
err_large_prog_name NUMBER -44814
err_large_user_name NUMBER -44815
err_zero_pcs NUMBER -44816
err_large_list NUMBER -44817
err_general_failure NUMBER -44818
err_no_enq NUMBER -44819
err_zero_wcs NUMBER -44820
err_lrg_cls NUMBER -44821
Security Model Execute is granted to the DBA role
 
ADD_WLMCLASSIFIERS

Undocumented
dbms_wlm.add_wlmclassifiers(
num_clsfrs IN NUMBER,
clsfrs     IN VARCHAR2);
TBD
 
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;
 
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;
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [270 users online]    © 2010 psoug.org