Delete Resource Manager Plans
Published by : Obay Salah , November 19, 2024
You can also delete the Plan using the DELETE_PLAN procedure available in the DBMS_RESOURCE_MANAGER package.DECLARE PLAN VARCHAR2(200) ; BEGIN PLAN... Continue Reading
Update Resource Manager Plan Directives
Published by : Obay Salah , November 19, 2024
You can also modify the Directive using the procedure UPDATE_PLAN_DIRECTIVE found in the DBMS_RESOURCE_MANAGER package.DECLARE PLAN VARCH... Continue Reading
Update Resource Manager Plans
Published by : Obay Salah , November 19, 2024
You can also make modifications to the Plan using the UPDATE procedure available in the DBMS_RESOURCE_MANAGER package.DECLARE PLAN VARCHA... Continue Reading
Create Resource Manager Plans & Directive
Published by : Obay Salah , November 19, 2024
In the previous steps, we noted that users in the database are organized into several Consumer Groups. But how are resources distributed among these g... Continue Reading
Move Active User To Other Consumer Group
Published by : Obay Salah , November 19, 2024
Let's assume that the user OBAY has connected to the database through the group NEW_GROUP, and now we want to switch the CONSUMER GROUP from NEW_GROUP... Continue Reading
Join To Consumer Group
Published by : Obay Salah , November 19, 2024
We mentioned in the previous step that the user is granted the privilege to join a Consumer Group via the procedure GRANT_SWITCH_CONSUMER_G... Continue Reading
Privileges & Resource Manager
Published by : Obay Salah , November 19, 2024
Here, we will use the package DBMS_RESOURCE_MANAGER_PRIVS, which contains four procedures, namely:DESC DBMS_RESOURCE_MANAGER_PRIVS; 1- GRAN... Continue Reading
Delete Consumer Group
Published by : Obay Salah , November 19, 2024
This is done using the procedure DELETE_CONSUMER_GROUP.DECLARE CONSUMER_GROUP VARCHAR2(200); NEW_COMMENT VARCHAR2(200); BEGIN CONSUMER_GROUP... Continue Reading
Update Consumer Group
Published by : Obay Salah , November 19, 2024
This is done using the procedure UPDATE_CONSUMER_GROUP.Let’s assume we want to modify the Consumer Group that we created in the previous step, wh... Continue Reading
Create Consumer Group
Published by : Obay Salah , November 19, 2024
The database administrator creates the Consumer Group using the package DBMS_RESOURCE_MANAGER. The fact is that this package contains a number of proc... Continue Reading