Published by : Obay Salah , November 19, 2024

 To configure the Resource Manager, we will use two packages:

  1. DBMS_RESOURCE_MANAGER: This package is used to create plans, directives, and consumer groups. It is also utilized to create the pending area, which is a space allocated in the SGA memory. This memory is used to work with Resource Manager objects, allowing the storage of entities during their configuration. Additionally, this package creates directives, where a single plan can contain a set of directives, and these directives are created individually.
  2. DBMS_RESOURCE_MANAGER.PRIVS: This package is used to assign users to consumer groups and to grant the necessary privileges for managing the Resource Manager.


Tags : Database

You May Also Like

Comments

no comment yet!