|
|
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
|