Introduction to Oracle Enterprise Manager Database Express

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.

Using EM Express, you can perform administrative tasks such as managing user security and managing database memory and storage. You can also view performance and information about your database.

Note:

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.

Configuration:

  • Initialization parameters (init.ora) management

  • Memory management

  • Database Feature Usage

  • Database Properties

Storage:

  • Tablespace management

  • Undo management

  • Redo management1

  • Archive log management1

  • Control files management1

Performance:

  • 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".

Navigation

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.

Description of the illustration exp_menus.gif follows
Description of the illustration exp_menus.gif

See Also:

Oracle Database Administrator's Guide for more information about Oracle Enterprise Manager Cloud Control

1

In a CDB, this feature is available for the CDB only, not for individual PDBs.