There are several new features in Oracle Enterprise Manager Database Express (EM Express).

EM Express has the following new features:

• Resource Manager support for multitenant container databases (CDBs), pluggable databases (PDBs), and non-CDBs. You can create, edit, delete, activate, and deactivate resource plans to help you manage resources effectively in these databases.

  See "Managing Database Resources" for information about Resource Manager features in EM Express.

• SQL Performance Analyzer (SPA) and SQL Performance Analyzer Quick Check (SPA Quick Check) support, which enables you to assess the effects of database changes on SQL performance

  See "Analyzing the Impact of Database Changes on SQL Performance" for information about the SPA and SPA Quick Check features in EM Express.

• In the root of a CDB, you can configure a single port (known as the global port), which enables you to use EM Express to connect to all of the PDBs in the CDB using the HTTPS port for the CDB

  See "Starting EM Express for a PDB" for information about configuring the global port.

• Additional Performance Hub support for CDBs and PDBs

  See the table in "Monitoring Performance Using the Performance Hub" for a list of the tabs that are available for different databases (CDBs, PDBs, and non-CDBs).

• Support for managing new types of PDBs

  You can use EM Express to manage refreshable PDBs, proxy PDBs, application roots, and application PDBs. See "About PDBs That Can be Managed in EM Express" and "Accessing the Containers Page for an Application Root".

  EM Express supports management of proxy PDBs. A proxy PDB provides a context to execute SQL statements and perform operations in a remote PDB from the proxy PDB.

  All statements (except the ALTER DATABASE, CREATE PLUGGABLE DATABASE, ALTER PLUGGABLE DATABASE, and DROP PLUGGABLE DATABASE statements) that are executed in the proxy PDB will be executed in the remote PDB.

• Hot cloning a PDB in a remote CDB to another CDB

  See "Creating a PDB by Cloning a PDB from a Remote CDB Using EM Express" for information about cloning a PDB from a remote CDB to another CDB.

• Relocating a PDB from a remote CDB to another CDB with minimal downtime

  See "Relocating a Remote PDB" for information about relocating a PDB from a remote CDB to another CDB.

• Creating a refreshable PDB

  See "Creating a PDB by Cloning a PDB from a Remote CDB Using EM Express" for information about creating a refreshable PDB by using the Refresh Option field when you create a new PDB by cloning an existing PDB from a remote CDB.

• Refreshing a refreshable PDB on demand

  See "Refreshing a PDB on Demand" for information about refreshing a refreshable PDB.

• New EM Express features for managing Oracle Data Guard standby databases

  You can use EM Express to:

  • View real-time performance statistics for a standby database in the Performance Hub

    See "About Viewing Performance Statistics on a Standby Database" for information about viewing standby database performance statistics.

  • Tune SQL queries for a standby database with SQL Tuning Advisor

    See "About Tuning SQL Statements on a Standby Database" and "Tuning SQL Statements on a Standby Database" for information about tuning SQL statements for a standby database.