Review of Book


Friends,
My new book has been reviewed by popular Oracle ACE Director Gokhan Atil, please see http://www.gokhanatil.com/2016/08/book-review-oracle-database-cloud-cookbook-with-oracle-enterprise-manager-cloud-control-13c.html for the detailed review. Thanks Gokhan.

Regards,


Porus.

Oracle Database Cloud Cookbook published

Friends,

If you want to know more about the Oracle Private/Hybrid Database Cloud using
the latest Enterprise Manager Cloud Control 13c, then this is the book.

Just published on August 5th 2016, and achieved Amazon Best Sellers Rank: #11 in all Oracle Books.  Read more about the book in my LinkediIn Pulse post:

https://www.linkedin.com/pulse/oracle-database-cloud-cookbook-porus-homi-havewala-ocm-

This book will also be available in Oracle Open World.

Regards,

Porus Homi Havewala
(Oracle Certified Master)
(Oracle ACE Director Alumni)

My New Udemy course "Oracle Private Database Cloud"


Friends,


Happy to announce that I have created and published my very first Udemy course on the "Oracle Private Database cloud" as an Udemy Premium Instructor. I hope you find this course beneficial.

About This Course:

Published 6/2016 English
https://www.udemy.com/oracle-private-database-cloud/



Course Description:

This course will introduce you to the concepts of the Oracle Private Database cloud. You will be taught techniques for building, configuring, and managing a private database cloud with Oracle Enterprise (more...)

Announcing my new Oracle Database Cloud Cookbook from Oracle Press

Dear Friends,

I am pleased to announce my new book "Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control" to be published by Oracle Press, and is now available as a pre-order from Amazon. The Amazon link is:

http://www.amazon.com/Database-Cookbook-Enterprise-Manager-Control/dp/0071833536

This practical Oracle Press guide Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control teaches cutting-edge techniques for building, configuring, and managing a secure private database cloud with Oracle Enterprise (more...)

Oracle Enterprise Manager 13c: New and Exciting Features

Oracle Enterprise Manager 13c: New and Exciting Features

Oracle Enterprise Manager 13c: What’s New
We just announced the release of Oracle Enterprise Manager 13c. Well, if the number 13 makes you jittery, rest assured that this new release is an improvement on Oracle Enterprise Manager 12c which has witnessed unprecedented adoption among customers worldwide. Oracle Enterprise Manager 12c rests on the key themes of (more...)

How to check for Database Option and Management Pack usage

How do you check for Database Option and Management Pack usage? There are two scripts available from Oracle for this purpose. They are :
1. option_usage.sql
This script outputs database option usage and management pack usage by a database target
2.  used_options_details.sql
This script will output the features used by each database option and management pack.
You can get these two scripts from Document ID 1317265.1 in My Oracle Support. The (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XXI


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 tablespace level Heat Map in Database 12c, showing which objects were accessed with a full table scan. We now move to the Policy tab.
Information about the Compression and Storage policies is displayed. There are 2 storage policies present. Only one object has a policy enabled.  Drill down (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XX


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we used Enterprise Manager and added Automatic Data Optimization (ADO) policies that enforceInformation Lifecycle Management (ILM) in Database 12c.
To view all the ADO policies and the Heat Map, select Administration.. Storage.. Information Lifecycle Managementfrom the 12c Database (non-CDB) Home Page in Enterprise Manager:
This displays the Information Lifecycle Management page. (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XIX


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 how Enterprise Manager helps with Information Lifecycle Management (ILM)in Database 12c. We changed the database initialization parameter heat_map to ON.
As the next step, we can add an Automatic Data Optimization (ADO) Policy by editing an Existing Tablespace as shown in the following screenshot.
In this case, (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XVIII


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 Information Lifecycle Management (ILM) in Database 12c, and we will now see how Enterprise Manager helps with that.
Enterprise Manager Cloud Control 12c allows the management of ILM in Database 12c. This was enabled via the DB Plug-in release 12.1.0.5 released 4 months after Enterprise Manager PS2  (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XVII – Information Lifecycle Management (ILM)


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 different tabs in the Performance Hub of Enterprise Manager Database Express 12c. Let us now look at Information Lifecycle Management (ILM) in Database 12c, and how Enterprise Manager helps with that.
Oracle Database 12c has an excellent feature known as Information Lifecycle Management (ILM) which is now fully (more...)

Separate or one Enterprise Manager environment for managing prod and non-prod targets


A friend wrote:
I know we can manage all targets using one single Enterprise Manager 12c environment but I know there are advantages of having two separate environments, one for Prod targets and the other for non-Prod targets.  Please explain pros and cons of both architectures, so that we can decide one over the other.
My answer:
Mate, the benefits of a single Enterprise Manager install for Prod and non-prod are manifold:
  1. Single pane (more...)

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

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