Changes in This Release for Oracle Database 2 Day DBA

Oracle Enterprise Manager Database Express (EM Express) can be used to manage multitenant container databases (CDBs) and pluggable databases (PDBs), in addition to managing non-CDBs:

• See "Starting EM Express for a CDB" for information about starting EM Express to manage a CDB.

• See "Starting EM Express for a PDB" for information about starting EM Express to manage a PDB.

• See Managing PDBs with EM Express for information on the features provided in EM Express for managing PDBs. Many of those features are available on the Containers page for a CDB.

EM Express provides support for in-memory database features introduced in Oracle Database 12c Release 1 (12.1.0.2):

• The Allocation Breakdown and Allocation History charts on the Memory Management page show In-Memory Area information.

• The amount of CPU consumed is broken out into regular CPU usage (CPU usage not related to in-memory operations) and in-memory CPU usage (CPU usage for in-memory operations), when applicable. This CPU breakdown is shown in several places:

  • On the Monitored SQL Execution Details page, wherever CPU activity is shown.

  • On the SQL Details page, in the Activity % column.

  • On the Activity tab in the Performance Hub, when Resource Consumption by Wait Class is selected.

• Oracle Enterprise Manager Database Express (EM Express) is the next-generation management tool for administration and management of individual databases that comes with Oracle Database 12c Release 1 (12.1).

  In previous Oracle Database releases, Oracle Enterprise Manager Database Control (DB Control) was the primary database management tool. DB Control is not included in this release.

  See "Introduction to Oracle Enterprise Manager Database Express" for more information about EM Express.

• SQL Developer is used to manage schema objects.

  Previous versions of this book described how to manage schema objects using DB Control. This version describes how to manage schema objects using SQL Developer.

  See Managing Schema Objects for more information about using SQL Developer.

• Oracle Recovery Manager (RMAN) is used to perform database backup and recovery operations.

  Previous versions of this book described how to perform database backup and recovery operations using DB Control. This version describes how to perform database backup and recovery operations using RMAN.

  See Performing Backup and Recovery for more information about using RMAN to perform database backup and recovery.