Databases Reference
In-Depth Information
Application quality management
Application test management, functional testing, load testing, Real Application
Testing (RAT), and test data management for Oracle applications and custom web-
based applications running on the Oracle Database
Since the focus of this topic is on the Oracle Database, we'll focus the remainder of this
chapter on capabilities in EM for managing the database infrastructure. For database
management, in addition to basic management capabilities provided in EM, Oracle
offers a number of optional packs, including:
Diagnostic Pack for Oracle Database
Provides automatic performance diagnostics, flexible system monitoring and no‐
tification, extended Exadata management, and database problem root cause anal‐
ysis and baseline comparison interfaces, leveraging ADDM and the AWR in the
Oracle Database
Tuning Pack for Oracle Database
Provides a real-time SQL monitor useful in identifying long-running queries, the
SQL Tuning Advisor for analysis and automatic implementation of improved SQL
profile recommendations, the SQL Access Advisor for recommending schema re‐
design, and an object reorganization wizard for removing wasted space
Lifecycle Management Pack for Oracle Database
Provides database discovery and inventory tracking, initial database provisioning,
ongoing change management of patches, upgrades, and schema and data changes,
configuration and compliance management, and site-level disaster protection au‐
tomation (also called Site Guard)
Oracle Data Masking Pack
Provides search for sensitive data capability, common data masking formats, and
supports condition-based masking, compound masking, deterministic masking,
and key-based reversible masking
Oracle Test Data Management Pack
Detects and stores data relationships from a production Oracle Database in an
Application Data Model which is then used to generate a subset of data useful in
nonproduction Oracle Database testing
Cloud Management Pack for Oracle Database
Provides a Consolidation Planner for determining how to redistribute workloads
and meet service level agreements (SLAs), a self-service portal through which new
instances can be requested for single instance and Real Application Clusters (RAC)
Oracle Databases and then started and monitored, and also provides a metering
and chargeback interface
