Resource Manager Plans
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:
- 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.
- 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.
- 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
.
Comments
no comment yet!