Managing Oracle Database 12c with Enterprise Manager – Part XII


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at how the Self-Service console would appear to the Self-Service Application (SSA) user, with the ability to provision databases, schemas or PDBs on the fly.
Metering and Chargeback is an important feature of the cloud. Due to the agile self-service nature of the cloud, it is important to set up quotas (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XI


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at “Database as a Service” and “Schema-as-a-Service”, and also talked about “Pluggable database (PDB) as a Service (PDBaaS)”.
The “Schema as a Service” capability was introduced since the Cloud plug-in “Enterprise Manager for Oracle Cloud (SSA) 12.1.0.5”. The renamed plug-in “Oracle Cloud (more...)

Managing Oracle Database 12c with Enterprise Manager – Part X – Database as a Service

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at the Database Resource Manager and how it can be used to control resources at the PDB level in Database 12c.
Let us now look at how Enterprise Manager’s “Database as a Service (DBaaS)” capability works with Database 12c and its container and pluggable databases.
With Oracle Enterprise Manager (more...)

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 (more...)

Managing Oracle Database 12c with Enterprise Manager – Part VIII


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we started to look at Data Redaction, and created a Policy on the HR user and Salary column. We specified Full Redaction as seen below, to hide all the Salary column figures (a zero will be displayed).


Click on “Show SQL”, this displays the PL/SQL code that is generated to (more...)