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 Active Session History Analytics


Active Session History (ASH) Analytics is a new built-in functionality in OEM 12c that can be used to monitor a database by providing an enhanced version of database top activity graphics.

The following recipe describes the steps to access Active Session History Analytics in 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, a sample database called as OEM12c is used to demonstrate ASH Analytics using OEM12c Cloud Control.

How to do it...

To access ASH Analytics of a database target, perform the following steps:

  1. Log in to Enterprise Manager Cloud Control.

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

  3. Select the database instance's name from the database's screen.

    The oem12C database instance is selected in this example.

  4. From the database instance's home page, select the Performance menu tab.

  5. Select ASH Analytics from the drop-down list.

  6. Populate the Database...