You can then either submit the changes (via SUBMIT_PENDING_AREA) or clear the changes (via
CLEAR_PENDING_AREA). The procedures that manage the pending area do not have any input
variables, so a sample creation of a pending area uses the following syntax:
execute DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();
If the pending area is not created, you will receive an error message when you try to create a
resource plan.
To create a resource plan, use the CREATE_PLAN procedure of the DBMS_RESOURCE_
MANAGER package. The syntax for the CREATE_PLAN procedure is shown in the following listing:
CREATE_PLAN
(plan IN VARCHAR2,
comment IN VARCHAR2,
cpu_mth IN VARCHAR2 DEFAULT 'EMPHASIS',
active_sess_pool_mth IN VARCHAR2 DEFAULT
'ACTIVE_SESS_POOL_ABSOLUTE',
parallel_degree_limit_mth IN VARCHAR2 DEFAULT
'PARALLEL_DEGREE_LIMIT_ABSOLUTE',
queueing_mth IN VARCHAR2 DEFAULT 'FIFO_TIMEOUT')
When you create a plan, give the plan a name (in the plan variable) and a comment. By
default, the CPU allocation method will use the ???emphasis??? method, allocating CPU resources
based on percentage. The following example shows the creation of a plan called DEVELOPERS:
execute DBMS_RESOURCE_MANAGER.CREATE_PLAN -
(Plan => 'DEVELOPERS', -
Comment => 'Developers, in Development database');
Chapter 5: Developing and Implementing Applications 137
NOTE
The hyphen (-) character is a continuation character in SQL*Plus,
allowing a single command to span multiple lines.
Pages:
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253