Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Enterprise Manager Database Control is no longer available in Oracle Database 12c. You can use Enterprise Manager Cloud Control 12c or EM Express 12c to manage your Oracle Database 12c databases.
Enterprise Manager Cloud Control supports Oracle Database 12c targets, including multitenant container databases (CDBs), pluggable databases (PDBs), non-CDBs, Oracle Real Application Clusters (Oracle RAC) databases, and Oracle Automatic Storage Management (Oracle ASM) databases.
See Oracle Database Concepts and Oracle Database Administrator's Guide for more information about CDBs and PDBs, Oracle Real Application Clusters Administration and Deployment Guide for more information about Oracle RAC databases, and Oracle Automatic Storage Management Administrator's Guide for more information about Oracle ASM databases.
These Enterprise Manager Database Express features described below can be used against non-CDBs, CDBs, PDBs, or Oracle RAC database instances.
Initialization parameters (init.ora) management
Database Feature Usage
Undo managementFoot 1
Redo managementFootref 1
Archive log managementFootref 1
Control files managementFootref 1
Performance Hub, which includes these features:
Real-time performance monitoring and tuning
Historical performance and tuning
SQL monitoring (real-time and historical)
Database operations monitoring
ADDM, including Real-Time ADDM
Active Session History (ASH) Analytics
Automatic and manual SQL Tuning Advisor
Database Home Page
The main page for database administration is the Database Home page. This is the page that loads when you log in to EM Express. See "Accessing the Database Home Page".
Menus at the top of the Database Home page organize database management tasks into distinct categories. Choosing a menu option takes you to the EM Express page for that database management task. For example, to view the Users page, from the Security menu, select Users.
Oracle Database Administrator's Guide for more information about Oracle Enterprise Manager Cloud Control
Footnote LegendFootnote 1:
In a CDB, this feature is available for the CDB only, not for individual PDBs.