Book Image

Oracle Enterprise Manager 12c Administration Cookbook

By : Dhananjay Papde, Tushar Nath, Vipul Patel
Book Image

Oracle Enterprise Manager 12c Administration Cookbook

By: Dhananjay Papde, Tushar Nath, Vipul Patel

Overview of this book

<p>Oracle Enterprise Manager is a key tool for any Oracle Administrator, allowing them to manage their Oracle installations and selected other applications, providing a one stop place to manage and maintain the entire infrastructure in any organization.<br /><br />The Oracle Enterprise Manager 12c Cookbook will give administrators a head start towards implementing OEM in their organizations, by taking you through all the aspects of installation, upgrade, configuration, and monitoring of various servers, databases, and various Oracle Fusion Middleware components.<br /><br />Starting with the installation and upgrade of your OEM installation, this book then takes you through the process of using OEM12c to configure and monitor your Oracle application and database servers, including the various supported Oracle Fusion Middleware products.<br /><br />This book will uncover various installations options (with simple advanced options) and various upgrade options.<br /><br />The book will also cover monitoring the infrastructure using Active Session History Analytics. There are recipes on creating, cloning databases, and creating templates. <br /><br />Additionally there are recipes on Configuration of Oracle Business Intelligence, Oracle Golden Gate, Oracle Business Intelligence Publisher, and Oracle Weblogic using OEM12c.</p>
Table of Contents (16 chapters)
Oracle Enterprise Manager 12c Administration Cookbook
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Using the Compare Period AutomaticDatabase Diagnostics Monitor (ADDM) feature


The Compare Period ADDM feature performs an analysis of two AWR snapshot periods and detects causes, measures effects, and correlates them. It also makes actionable recommendations, and provides a quantified impact.

The following recipe describes the steps to use the Compare Period ADDM feature by using the OEM 12C Cloud Control console.

Getting ready

The agent needs to be up and running on a host where a database is installed.

In this example, the database instance called OEM12c is used to demonstrate the Compare Period ADDM feature using OEM12C Cloud Control.

How to do it...

To access Compare Period ADDM, perform the following steps:

  1. Login to Enterprise Manager Cloud Control.

  2. From the Targets option, select Databases from the drop-down menu.

    Select the database instance's name of interest.

    Select AWR under the Performance tab.

  3. Select the Compare Period ADDM option from the drop-down menu of AWR.

  4. Connect as sys privileged...