Resource manager determines how resources are shared amongst multiple competing tasks within oracle. Resource Management in a CDB environment has two components: CDB level – Manage resources amongst multiple PDBs and has the ability to allocate/limit resources to specific PDB. PDB level – Manages resources within a single PDB. Through using the package DBMS_RESOURCE MANGER, the administrator is able to create Plans, Groups, and Allocations of resources.
Resource Allocation:
- Create Resource Plans.
- Create Consumer Groups.
- Assign PDBs to Groups.
- Each PDB is allocated a portion of the total system resources in the CDB.
- Inside a PDB resources are allocated to individual sessions in the PDB.
- Specify which PDBs shares of resources based on their importance.
- Limit CPU usage of individual PDB.
- Limit number of parallel servers a PDB can use.
- Limit resource usage of different sessions in a single PDB.
- Monitor resource usage of PDBs.
Larry Catt
OCP