Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER, 10 of 19
This procedure lets you create resource plan directives.For release 8.2 new_max_active_sess_target_mth was renamed new_active_sess_pool_mth and several new parameters added.
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE ( plan IN VARCHAR2, group_or_subplan IN VARCHAR2, comment IN VARCHAR2, cpu_p1 IN NUMBER DEFAULT NULL, cpu_p2 IN NUMBER DEFAULT NULL, cpu_p3 IN NUMBER DEFAULT NULL, cpu_p4 IN NUMBER DEFAULT NULL, cpu_p5 IN NUMBER DEFAULT NULL, cpu_p6 IN NUMBER DEFAULT NULL, cpu_p7 IN NUMBER DEFAULT NULL, cpu_p8 IN NUMBER DEFAULT NULL, active_sess_pool_p1 IN NUMBER DEFAULT UNLIMITED, queueing_p1 IN NUMBER DEFAULT UNLIMITED, switch_group IN VARCHAR2 DEFAULT NULL, switch_time IN NUMBER DEFAULT UNLIMITED, switch_estimate IN BOOLEAN DEFAULT FALSE, max_est_exec_time IN NUMBER DEFAULT UNLIMITED, undo_pool IN NUMBER DEFAULT UNLIMITED, parallel_degree_limit_p1 IN NUMBER DEFAULT UNLIMITED);
All parameters default to NULL
. However, for the EMPHASIS
CPU
resource allocation method, this case would starve all the users.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|