Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Create Simple Plan
Published by :
Obay Salah , November 19, 2024
The Resource Manager is one of the strongest features of the database; however, it is not necessarily the case that strong features are easy to use, a... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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