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 ge.tt on the internet.