Snap Cloning Databases on Exadata using Enterprise Manager

By Subhadeep Sengupta (Oracle)
Historically, Exadata has mostly been deployed for heavy, production workloads, leaving cheap commodity hardware and third-party storage to perform as infrastructure for Development and Testing. From the viewpoint of Enterprise Manager, we have seen customers clone production databases running on Exadata to secondary storage such as ZFS Storage Appliance or even third-party NAS or SAN for the purpose of testing. Customers mainly used RMAN (with or without Enterprise Manager) to (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XVI


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we were exploring the Activity tab in the Performance Hub of Enterprise Manager Database Express 12c. Let us move to the Monitored SQL Tab.
This is the Real-time SQL Monitoring feature of the Diagnostics pack. This screen shows all the long running SQL statements (that have consumed 5 seconds or more of combined (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XV

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 into the Performance Hub of Enterprise Manager Database Express 12c. Let us move to the Activity tab.
The red line shows the CPU cores used by this VBOX image, and obviously at a point of time this line has been exceeded. The total CPU wait class can be seen (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XIV


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we discussed the new Enterprise Manager Database Express 12c, which is the replacement for the earlier Database Control (used in previous versions of the Oracle database such as 11g and 10g, to manage a single database).
One of the menu options in Database Express 12c is the Database Performance Hub. This gives (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XIII – Database Express 12c


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we briefly looked at the changes for Metering and Chargeback. We will now look at the new Database Express 12c.
Oracle Database 12c introduces “Enterprise Manager Database Express 12c” instead of Enterprise Manager Database Control that was available with previous versions of the database, such as 11g and 10g. The important (more...)

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