René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

dbms_resource_manager

Procedures/Functions

clear_pending_area

procedure clear_pending_area (
);

create_consumer_group

procedure create_consumer_group (
 consumer_group                     in                 varchar2        ,
 comment                            in                 varchar2        ,
 cpu_mth                            in                 varchar2 default
);

create_pending_area

procedure create_pending_area (
);

create_plan

procedure create_plan (
 plan                               in                 varchar2        ,
 comment                            in                 varchar2        ,
 cpu_mth                            in                 varchar2 default,
 active_sess_pool_mth               in                 varchar2 default,
 parallel_degree_limit_mth          in                 varchar2 default,
 queueing_mth                       in                 varchar2 default
);

create_plan_directive

procedure create_plan_directive (
 plan                               in                 varchar2        ,
 group_or_subplan                   in                 varchar2        ,
 comment                            in                 varchar2        ,
 cpu_p1                             in                   number default,
 cpu_p2                             in                   number default,
 cpu_p3                             in                   number default,
 cpu_p4                             in                   number default,
 cpu_p5                             in                   number default,
 cpu_p6                             in                   number default,
 cpu_p7                             in                   number default,
 cpu_p8                             in                   number default,
 active_sess_pool_p1                in                   number default,
 queueing_p1                        in                   number default,
 parallel_degree_limit_p1           in                   number default,
 switch_group                       in                 varchar2 default,
 switch_time                        in                   number default,
 switch_estimate                    in                  boolean default,
 max_est_exec_time                  in                   number default,
 undo_pool                          in                   number default,
 max_idle_time                      in                   number default,
 max_idle_blocker_time              in                   number default,
 switch_time_in_call                in                   number default
);

create_simple_plan

procedure create_simple_plan (
 simple_plan                        in                 varchar2 default,
 consumer_group1                    in                 varchar2 default,
 group1_cpu                         in                   number default,
 consumer_group2                    in                 varchar2 default,
 group2_cpu                         in                   number default,
 consumer_group3                    in                 varchar2 default,
 group3_cpu                         in                   number default,
 consumer_group4                    in                 varchar2 default,
 group4_cpu                         in                   number default,
 consumer_group5                    in                 varchar2 default,
 group5_cpu                         in                   number default,
 consumer_group6                    in                 varchar2 default,
 group6_cpu                         in                   number default,
 consumer_group7                    in                 varchar2 default,
 group7_cpu                         in                   number default,
 consumer_group8                    in                 varchar2 default,
 group8_cpu                         in                   number default
);

delete_consumer_group

procedure delete_consumer_group (
 consumer_group                     in                 varchar2        
);

delete_plan

procedure delete_plan (
 plan                               in                 varchar2        
);

delete_plan_cascade

procedure delete_plan_cascade (
 plan                               in                 varchar2        
);

delete_plan_directive

procedure delete_plan_directive (
 plan                               in                 varchar2        ,
 group_or_subplan                   in                 varchar2        
);

set_consumer_group_mapping

procedure set_consumer_group_mapping (
 attribute                          in                 varchar2        ,
 value                              in                 varchar2        ,
 consumer_group                     in                 varchar2 default
);

set_consumer_group_mapping_pri

procedure set_consumer_group_mapping_pri (
 explicit                           in                   number        ,
 oracle_user                        in                   number        ,
 service_name                       in                   number        ,
 client_os_user                     in                   number        ,
 client_program                     in                   number        ,
 client_machine                     in                   number        ,
 module_name                        in                   number        ,
 module_name_action                 in                   number        ,
 service_module                     in                   number        ,
 service_module_action              in                   number        
);

set_initial_consumer_group

procedure set_initial_consumer_group (
 user                               in                 varchar2        ,
 consumer_group                     in                 varchar2        
);

submit_pending_area

procedure submit_pending_area (
);

switch_consumer_group_for_sess

procedure switch_consumer_group_for_sess (
 session_id                         in                   number        ,
 session_serial                     in                   number        ,
 consumer_group                     in                 varchar2        
);

switch_consumer_group_for_user

procedure switch_consumer_group_for_user (
 user                               in                 varchar2        ,
 consumer_group                     in                 varchar2        
);

switch_plan

procedure switch_plan (
 plan_name                          in                 varchar2        ,
 sid                                in                 varchar2 default
);

update_consumer_group

procedure update_consumer_group (
 consumer_group                     in                 varchar2        ,
 new_comment                        in                 varchar2 default,
 new_cpu_mth                        in                 varchar2 default
);

update_plan

procedure update_plan (
 plan                               in                 varchar2        ,
 new_comment                        in                 varchar2 default,
 new_cpu_mth                        in                 varchar2 default,
 new_active_sess_pool_mth           in                 varchar2 default,
 new_parallel_degree_limit_mth      in                 varchar2 default,
 new_queueing_mth                   in                 varchar2 default
);

update_plan_directive

procedure update_plan_directive (
 plan                               in                 varchar2        ,
 group_or_subplan                   in                 varchar2        ,
 new_comment                        in                 varchar2 default,
 new_cpu_p1                         in                   number default,
 new_cpu_p2                         in                   number default,
 new_cpu_p3                         in                   number default,
 new_cpu_p4                         in                   number default,
 new_cpu_p5                         in                   number default,
 new_cpu_p6                         in                   number default,
 new_cpu_p7                         in                   number default,
 new_cpu_p8                         in                   number default,
 new_active_sess_pool_p1            in                   number default,
 new_queueing_p1                    in                   number default,
 new_parallel_degree_limit_p1       in                   number default,
 new_switch_group                   in                 varchar2 default,
 new_switch_time                    in                   number default,
 new_switch_estimate                in                  boolean default,
 new_max_est_exec_time              in                   number default,
 new_undo_pool                      in                   number default,
 new_max_idle_time                  in                   number default,
 new_max_idle_blocker_time          in                   number default,
 new_switch_time_in_call            in                   number default
);

validate_pending_area

procedure validate_pending_area (
);

Links