Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page