Databases Reference
In-Depth Information
Oracle Enterprise Manager 12
c
Many Oracle Database generations ago, Oracle Enterprise Manager (EM) was intro‐
duced as an Oracle Database manager framework. Today, Enterprise Manager 12
c
con‐
tinues to be a framework used for managing the database, but it is also used for managing
Fusion Middleware, Oracle's Applications, Oracle's engineered systems, Cloud-based
infrastructure, and more. The framework consists of management services, monitoring,
configuration management, task automation, security, and plug-ins for the managed
platforms supported. Later in this topic, we'll focus our discussion on managing the
database deployed to a traditional infrastructure and also to a Cloud-based infrastruc‐
ture. We'll also discuss the added capabilities provided by Enterprise Manager when
managing the Oracle Exadata Database Machine including the monitoring of hardware
alerts, configuration management, and proactive support.
Enterprise Manager is accessed via a browser or mobile device (e.g., iOS devices were
supported when this edition of the topic was published). Enterprise Manager provides
a basic interface for monitoring and management of Oracle Database users and user
privileges, database schema, and database configuration, status, and backup and recov‐
ery. The optional Enterprise Manager Packs that Oracle offers extend the management
capabilities:
Oracle Diagnostic Pack for Oracle Database
The Oracle Diagnostic Pack for the Database provides an automatic and real-time
performance interface to the Automatic Database Diagnostic Monitor (ADDM),
an automatic workload capture interface to the Database Automatic Workload
Repository (AWR), performance comparisons versus ASR baselines, active session
history, system monitoring and notification, and Exadata-specific lights-out mon‐
itoring and management of nodes, Exadata Storage Server cells, and InfiniBand
switches.
Oracle Tuning Pack for Oracle Database
The Oracle Tuning Pack for the Database provides real-time SQL monitoring used
in identifying long-running SQL, a SQL Tuning Advisor that provides recommen‐
dations to administrators or that can be run in automatic mode, and a SQL Access
Advisor that provides advice on schema design.
Oracle Database Lifecycle Management Pack
The Oracle Database Lifecycle Management Pack automatically discovers database
and application physical servers, enables deployment procedures for provisioning
and patching of databases, provides capability to perform patching lifecycle change
management, configuration management, and compliance management, and pro‐
vides Site Guard to manage disaster recovery through integration with Data Guard
and filesystem data storage.
