O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calls

PROCEDURE DBMS_RESOURCE_MANAGER.CREATE_PLAN (plan IN VARCHAR2, comment IN VARCHAR2, cpu_mth IN VARCHAR DEFAULT 'EMPHASIS', active_sess_pool_mth | max_active_sess_target IN VARCHAR2 DEFAULT 'ACTIVE_SESSION_POOL_ABSOLUTE', parallel_degree_limit_mth IN VARCHAR2 DEFAULT 'PARALLEL_DEGREE_LIMIT_ABSOLUTE', queueing_mth IN VARCHAR2 DEFAULT 'FIFO_TIMEOUT');

Creates a resource plan plan with methods indicated in the parameters. In Oracle 8.2, max_active_sess_target was renamed to active_sess_pool_mth and queueing_mth was added.

PROCEDURE DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (simple_plan IN VARCHAR2, consumer_group1 in VARCHAR2, group1_cpu IN VARCHAR2, consumer_group2 in VARCHAR2, group2_cpu IN VARCHAR2, consumer_group3 in VARCHAR2, group3_cpu IN VARCHAR2, consumer_group4 in VARCHAR2, group4_cpu IN VARCHAR2, consumer_group5 in VARCHAR2, group5_cpu IN VARCHAR2, consumer_group6 in VARCHAR2, group6_cpu IN VARCHAR2, consumer_group7 in VARCHAR2, group7_cpu IN VARCHAR2, consumer_group8 in VARCHAR2, group8_cpu IN VARCHAR2);

Creates simple_plan resource plan with up to eight consumer groups in one call. New with Oracle9i.

PROCEDURE DBMS_RESOURCE_MANAGER.UPDATE_PLAN (plan IN VARCHAR2, new_comment IN VARCHAR2, new_cpu_mth IN VARCHAR DEFAULT NULL, new_active_sess_pool_mth | new_max_active_sess_target IN VARCHAR2 DEFAULT NULL, new_parallel_degree_limit_mth IN VARCHAR2 DEFAULT NULL, new_queueing_mth IN VARCHAR2 DEFAULT NULL [,new_group_switch_mth IN VARCHAR2 DEFAULT NULL)]#;

Updates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required