What is the reason for this?

The Database Resource Manager is automatically enabled in the maintenance window that
runs the Automated Maintenance Task. What is the reason for this?

The Database Resource Manager is automatically enabled in the maintenance window that
runs the Automated Maintenance Task. What is the reason for this?

A.
to prevent the creation of an excessive number of scheduler job classes

B.
to allow the Automated Maintenance Tasks to use system resources without any
restriction

C.
to allow resource sharing only among the Automated Maintenance Tasks in the
maintenance window

D.
to prevent the Automated Maintenance Tasks from consuming excessive amounts of
system resources

Explanation:
Oracle Database Resource Manager (the Resource Manager) is an infrastructure that
provides granular control of database resources allocated to users, applications, and
services. The Resource Manager solves many resource allocation problems that an
operating system does not manage well, including:
Excessive overhead
Inefficient scheduling
Inappropriate allocation of resources
Inability to manage database-specific resources
The Resource Manager helps overcome these problems by giving the database more
control over allocation of hardware resources and enabling you to prioritize work within the
database. You can classify sessions into groups based on session attributes, and then
allocate resources to these groups to optimize hardware utilization.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

D is correct:

http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm

What Problems Does the Database Resource Manager Address?
When database resource allocation decisions are left to the operating system, you may encounter the following problems:

Excessive overhead

Excessive overhead results from operating system context switching between Oracle Database server processes when the number of server processes is high.

Inefficient scheduling

The operating system deschedules database servers while they hold latches, which is inefficient.

Inappropriate allocation of resources

The operating system distributes resources equally among all active processes and is unable to prioritize one task over another.

Inability to manage database-specific resources, such as parallel execution servers and active sessions