NOTE
As part of acceptance testing, all interfaces to the application should
be tested and their input and output verified.
136 Oracle Database 11g DBA Handbook
Resource Management and Stored Outlines
You can use stored outlines to migrate execution paths between databases, and you can use the
Database Resource Manager to control the allocation of system resources among database users.
Stored outlines and resource management are important components in a managed development
environment. The Database Resource Manager gives DBAs more control over the allocation of
system resources than is possible with operating system controls alone.
NOTE
As of Oracle 10g, you can use SQL profiles to further refine the
execution path selected.
Implementing the Database Resource Manager
You can use the Database Resource Manager to allocate percentages of system resources to
classes of users and jobs. For example, you could allocate 75 percent of the available CPU
resources to your online users, leaving 25 percent to your batch users. To use the Database
Resource Manager, you will need to create resource plans, resource consumer groups, and
resource plan directives.
Prior to using the Database Resource Manager commands, you must create a ???pending area??? for
your work. To create a pending area, use the CREATE_PENDING_AREA procedure of the DBMS_
RESOURCE_MANAGER package. When you have completed your changes, use the VALIDATE_
PENDING_AREA procedure to check the validity of the new set of plans, subplans, and directives.
Pages:
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252