Book Image

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

By : PORUS HOMI HAVEWALA
Book Image

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

By: PORUS HOMI HAVEWALA

Overview of this book

Data centers around the world are experiencing an unprecedented era of growth due to expanding data volumes. There is also a corresponding increase in the number of databases and applications. In such rapid-growth centers, it is inevitable that fighting fires daily becomes a common occurrence. There is often no controlled method of performance management, neither is rapidly changing configuration information collected. With the lack of automation and control, Data Centers do not often realize their intended cost-effectiveness and regress into a chaotic and uncontrolled day-to-day type of existence. This was the case until Oracle Enterprise Manager started being used as an Enterprise-wide central management solution, changing the whole game in the process. In this brand new book by Porus Homi Havewala, one of the leading experts in the Oracle space, you will be introduced to the all-encompassing world of Oracle Enterprise Manager Cloud Control 12c, Oracle's premier product for managing and monitoring the Enterprise space. Drawing from the author's many years of experience in the real world, the book brings together the major capabilities of the latest Enterprise Manager software and demonstrates how to ease the growing pains of Data Centers. The book takes you on a descriptive journey of what issues are normally experienced in the Data Center, and how Oracle Enterprise Manager Cloud Control 12c manages to address and resolve many of the issues. The book introduces the reader to the typical chaos in Data Centers and discusses the way these common issues are normally resolved, by manual labor or manual scripting using extensive human resources. Then it will show you how Cloud Control 12c aids in Database Performance Management, Configuration Management, Security Compliance, Automated Provisioning, Automated Patching and Database Change Management. You will learn how Cloud Control 12c allows Exadata Database Machine Monitoring and Management, Test Data Management for data subsetting of large databases, as well as Sensitive Data De-identification using Data Masking. The book includes various real life examples and case studies of actual Oracle customers to show how they have benefited from using Oracle Enterprise Manager. It explores the strong standing of Oracle in the Enterprise Management game, now also strengthened by the new Enterprise Manager Cloud Control 12c.
Table of Contents (19 chapters)
Oracle Enterprise Manager Cloud Control 12: Managing Data Center Chaos
Credits
About the Author
Acknowledgements
About the Reviewers
www.PacktPub.com
Preface
Index

Benefits and capabilities


When you create a data subset, you can define subset criteria (such as a where condition), which will limit the amount of data that will be extracted for the subset. As a result, the storage requirements in the target database are reduced. This is one of the most important benefits of data subsetting, since it helps to reduce expensive storage costs.

You can select multiple applications, that is, schemas (in the case of multi-tenanted databases) for the subset. The definition of tables associated with these applications and the relationships between them will be extracted from the Application Data Model into the subset definition, along with additional metadata of the constraints and indexes. You can totally avoid the manual labor normally associated with collecting this information and writing appropriate scripts.

Table rules can be defined with where clauses and bind variables that limit the data that is extracted. Table statistics are then analyzed to get an estimate...