Published by : Obay Salah , November 19, 2024

 This is to define and allocate resources among groups, and these plans control a set of resources, primarily the CPU resources and others that we will discuss.

A single database may have multiple Resource Manager Plans, but only one plan is active at a time, which controls the resources and applies to all databases.

Any plan includes several directives, each specifying resource allocation to a specific group at a defined priority level.

Upon the creation of a database, three plans are created:

  1. INTERNAL_PLAN: This plan allows the group OTHER_GROUPS to access 100% of the CPU resources at the first level. This means all users within this group have equal priority for resources, as it targets the OTHER_GROUPS that include all users.
  2. SYSTEM_PLAN: This plan has three directives. At level 1, it allocates 100% of resources to the SYS_GROUP, meaning it has the highest priority. At level 2, it allocates 100% of resources to the OTHER_GROUPS, and at level 3, it allocates 100% of resources to the LOW_GROUP. This plan ensures that the SYS user or the SYSTEM user has priority in resources, followed by the OTHER_GROUPS and then the LOW_GROUP.
  3. INTERNAL_QUIESCE: This plan freezes all sessions that do not belong to the SYS_GROUP. This means that the database administrator can halt operations for all users except those in the SYS_GROUP.

This plan sets the Active Session Pool to zero for all groups except SYS_GROUP. Therefore, activating this plan will suspend all sessions, and it can be enabled using the command ALTER SYSTEM QUIESCE RESTRICTED, and it can be canceled with ALTER SESSION UNQUIESCE.

Tags : Database

You May Also Like

Comments

no comment yet!