The Hunger Site

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.



No comments:


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