Managing Resource Plans and Consumer Groups

The primary goal of the Database Resource Manager is to give the Oracle Server more control over resource management decisions. In this way, Oracle can circumvent any problems that may otherwise arise from inefficient operating system management.

Your database may encounter many problems when the database resource allocation decisions are allowed to be managed only at the operating system level as follows:

  • Excessive overhead can result from operating systems that constantly switch between Oracle processes, particularly when the number of server processes is high.

  • Inefficient scheduling can occur when the operating system unschedules services when it is inefficient to the database to do so.

  • Inefficient ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.