Managing Oracle Database 12c with Enterprise Manager – Part IX

We are discussing the management of Oracle Database 12c via Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at how easy it was to set up Oracle Data Redaction for a 12c database using Enterprise Manager - this capability being used to hide confidential data on the fly as it is being displayed.

We will now look at the Database Resource Manager and its new capabilities to handle PDBs in Database 12c, and how it can be set up via Enterprise Manager.

Drill down to the 12c Database target in Enterprise Manager. From the home page of the database, open the Administration menu and choose Resource Manager. The Resource Manager Home page is displayed.

As can be seen, the Database Resource Manager is now CDB aware and allows you to create CDB Resource plans. This will control resources to Pluggable databases inside the CDB. Drill down to the CDB resource plans, this displays the following screen.

Click on “Edit” to define the CDB Resource Plan.

In the Resource Plan, by default, all the PDBs have a “share” of one (1) . There are three PDBs in this container database, as displayed on this page - “PDB(3)”. Therefore, each PDB has a share of 33%. 

You can add a separate Resource Allocation by clicking on the “Add/Remove” button.

Here we have added PDB3 as a separate entry with 2 shares to the Resource Allocation. The remaining PDBs have 1 share each.  This means 50% is the Resource Allocation of PDB3, and the other two PDBs have 25% each. This can be used to cover a scenario where PDB3 is an important application’s pluggable database, and more resources are required to be allocated to this pluggable database.

We are also activating this plan with a simple tick mark on this page. Click on Apply. And we haven’t written a single line of PL/SQL code (which is normally required to define a resource plan if not using Enterprise Manager).

For more detailed information on the powerful capabilities of the Oracle Database Resource Manager, please refer to the chapter “Managing Resources with Oracle Database Resource Manager” in the 12c Database Admin guide.

In the next blog post, we will look at more management aspects of Oracle database 12c using Enterprise Manager, in particular the ability to self-service the creation of PDBs using “Pluggable database (PDB) as a Service (PDBaaS)” – a form of Database as a Service.

This blog post was originally posted at this link.