Saturday, October 15, 2011

Latest Presentation: Managing Exadata with Enterprise Manager 12c


Please see the latest presentation I have uploaded on:

Managing Exadata with Enterprise Manager 12c

Alternative site for download:

I have updated this with the latest pack name changes and more slides as well so this is the most upto date presentation on this topic. Original presentation was by Deba Chatterjee and Mark Ramacher in Oracle Open World, October 2011.

Exadata DBAs will understand from this. that their machines can be managed very well with the latest Enterprise Manager 12c Cloud Control released recently by Oracle on October 3rd 2011.

Packs and Options included in this presentation:

Diagnostics/Tuning Packs
Lifecycle Management Pack (3 EM11g packs combined in EM12c)
Cloud Management Pack (Brand-new in EM12c)
Data Masking Pack
Test Data Management Pack (Brand-new in EM12c)
Real Application Testing (RAT) DB EE Option

Using Cloud Control 12c, the client will be able to see an integrated view of all the hardware and software in the Exadata machine, with a schematic of storage cells, compute nodes and switches, and a software/system view of database systems/clusters. The client can inspect performance/availability /usage by databases /services/clusters and get software alerts on the database, cluster and ASM, as well as alerts on all hardware components. The Infiniband network and switches, so important for Exadata can be fully monitored with alerts, performance metrics and configuration standards. Storage cells can be monitored and also administered via Cloud Control. All storage cells in a database are automatically placed in a group, and you can administer the cells at the group level.

The performance of the RAC databases on Exadata can be fine tuned using the Diagnostics and Tuning pack capabilities of Enterprise Manager, these include the AWR repository, the ADDM diagnostics engine, and the SQL Tuning and SQL Access advisors. The database performance page is now Exadata aware with the performance graphs showing cell offload efficiency and cell smart scan, which are extremely powerful Exadata specific features. IO activity of other databases sharing the same storage can be examined. Exadata “smart scan” relevant info is also displayed on Real-time SQL monitoring and other SQL pages. There is also a Exadata System health page for a quick overview of availability across different time periods.

The newly-combined Lifecycle Management pack has the very useful capabilities of Configuration Management, Provisioning and Patch Automation, and Change Management. The Configuration management inventory has the version summary of all Exadata components, with the ability to compare configurations – useful in trouble shooting and to enforce configuration standards. The Patch Automation capabilities can be used to patch the multiple RAC database nodes and also the OS – a real need for automation when there are so many nodes, and the Change Management capabilities of the Lifecycle Management pack can be used to seamlessly propagate database schema changes across development, test and production databases. And, optionally, the Cloud Management pack for database lets you set up an internal DbaaS (Database as a service) cloud, with full self-service, metering and chargeback capabilities. The Cloud capabilities also include IaaS (Infrastructure as a Service) if using Oracle VM server pools, or, if using Exalogic servers, the Cloud Management pack for Fusion Middleware lets you set up PaaS (Platform as a service).

In this presentation we also discuss the Test Data Management pack, brand new in Enterprise Manager 12c, that lets you create test or development databases with a relationally intact fraction of the production data. This reduces the storage overhead for multiple test and development copies of large databases, and is very useful in real life situations.

Enjoy the world of Managing Exadata with Oracle Enterprise Manager 12c Cloud Control!!

As of January 2012, this presentation has 1100+ downloads on mediafire and on the internet.



Wednesday, October 12, 2011

How Can You Capitalize on Oracle's New Database Solutions?

How Can You Capitalize on Oracle's New Database Solutions?

You’re invited to join senior Oracle Database leaders for a live chat explaining what the latest product innovations coming out of Oracle OpenWorld mean for you and your business.

Get real-time advice and answers to your top questions:

• In-Memory Databases or Big Data?
• Engineered or DIY Systems?
• Appliances or machines?
• Private or public clouds?
• SQL or NoSQL?

Bring your database questions and learn how you’ll benefit from new product advances. Join the conversation -- register now for one of the two live sessions.

Session 1: From Oracle OpenWorld to Your Enterprise—Capitalizing on the Vision
Tues, October 18, 10am US Pacific

Session 2: From Oracle OpenWorld to Your Enterprise—Capitalizing on the Vision
Wed, October 19, 7:30am in India, 10am in China, 1pm in Sydney
(NOTE: SESSION 2 is better for APAC time zone)

Space is limited so register today using the link below:



Tuesday, October 4, 2011

Oracle Unveils Oracle Enterprise Manager 12c Cloud Control

Friends, Oracle has unveiled Oracle Enterprise Manager 12c "Cloud Control", notice the title change of this blog as well to include "Cloud Control" instead of "Grid Control"!!

Cloud Control, on which I did Beta testing as well, is a complete cloud management solution for your enterprise cloud - #em12c #OOW11

The Oracle Enterprise Manager launch highlights can be viewed from

The link from the enterprise manager web page has the complete video that plays from (

The New EM12c page is at

Pricing for Enterprise Manager 12c "Cloud Control" will be announced soon on the Technology Price List, the link is Wait for the updates, some big suprises coming!!

You can also watch this new, interesting video -- The Enterprise Manager - Episode 7 : Cloud Management with Oracle Enterprise Manager 12c:

The EM 12c docs are available here:

(they’re not listed on the central documentation page. This link originates from the Readme)

You can also download the zip from:

Jenny Tsai-Smith (Oracle) has mentioned "We have also created over 60+ technical videos on how to put Oracle Enterprise Manager Cloud Control 12c to work, please encourage your subscribers to visit,RIR,CIR:P2_SEARCH:EM12c%20Solution ". Thanks Jenny.

We have full DbaaS capability for databases on Exadata in this release of Oracle Enterprise Manager 12c Cloud Control. This will involve self-service provisioning, metering and chargeback. This will require licences of the Lifecycle Management Pack for database and the Cloud Management pack for database.

Regarding the public cloud, this is a great video on Oracle's Cloud Offering -

Enterprise Manager is also used heavily in Oracle's public cloud.

Enjoy the new world of Enterprise Manager 12c Cloud Control.


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive