The following features are new in this release:

• Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs)

  You can now use ADDM to analyze AWR data in PDBs for identifying and resolving performance related issues.

  See "ADDM for a Multitenant Environment" for more information.

• Real-time SQL monitoring functionality enabled for non-administrative database users

  The database users without the administrative privileges can also now view the execution plans and performance metrics of their SQL statements by navigating to the Monitored SQL Executions page of Oracle Enterprise Manager Cloud Control (Cloud Control).

  See the section "Monitoring Database Operations in Cloud Control" for more information.

The following feature is desupported in this release.

• Oracle Streams

  Starting in Oracle Database 19c, the Oracle Streams feature is desupported. Use Oracle GoldenGate to replace all replication features of Oracle Streams.

The following features are new in this release:

• Manageability support for In-Memory Column Store

  The new Oracle Database In-Memory Column Store (IM column store) feature accelerates database performance of analytics, data warehousing, and online transaction processing (OLTP) applications.

  SQL Monitor report, ASH report, and AWR report now show statistics for various in-memory operations.

  • In-memory statistics in SQL Monitor report: Activity % in Time and Wait Statistics panel, Activity column in Plan Statistics table, and Activity tab in SQL Monitor report show CPU consumed by SQL commands while executing in-memory query operations. SQL Monitor report now supports Adaptive plans. The Execution plan shows Resolving or Resolved icon depending upon the current status of that plan. The Plan Statistics tab contains a drop down list to show current plan, final plan, and full plan. It also contains Plan Note button, which when clicked, shows the notes that are generated in the explain plan for the SQL statement.

  • In-memory statistics in ASH report: ASH report header table shows the size of in-memory pool under In Memory Area column. Top Events, Top SQL, and Activity Over Time sections show CPU consumption by various in-memory operations.

  • In-memory statistics in AWR report: AWR report contains a new section - In-Memory Segments Statistics - that shows in-memory segment consumption based on various attributes, such as, scans, DB block changes, populate CUs, and repopulate CUs. Time Model Statistics section shows statistics related to in-memory CPU usage and Instance Activity Statistics section shows statistics related to in-memory activities.

The following are additional changes in the release:

• Changes in ASH Analytics page

  In the Average Active Sessions chart on ASH analytics page, you can now click on CPU wait class to see its breakdown by CPU usage based on various in-memory operations as well as total CPU used for operations other than in-memory operations.

  See "Determining the Cause of Spikes in Database Activity" for more information.

The following features are new in this release:

• Real-time database operations monitoring

  Real-Time database operations monitoring tracks and reports on active and recently completed database operations. You can monitor details of the execution of a single SQL or PL/SQL statement. You can also monitor the progress of long-running operations such as a batch job, or extract, transform, and load (ETL) processing.

  See "Monitoring Real-Time Database Operations " for information on this feature.

Oracle Enterprise Manager Database Control is no longer supported by Oracle.

The following are additional changes in the release:

• Oracle Enterprise Manager Cloud Control

  In previous releases of Oracle Database, you used Oracle Enterprise Manager Database Control (Database Control) to manage database performance tuning from a graphical user interface. In this release, you can use the Oracle Enterprise Manager Cloud Control (Cloud Control) graphical user interface. Cloud Control provides more functionality than Database Control. The procedures in this guide use Cloud Control.

  You must install Cloud Control separately from Oracle Database.

  See Also:

  Oracle Enterprise Manager Cloud Control Basic Installation Guide

• ASH Analytics page

  Cloud Control has the ASH Analytics page, which graphically displays recent Active Session History information.

  See "Determining the Cause of Spikes in Database Activity" for more information.

• Real-Time ADDM

  Cloud Control has the Real-Time ADDM page, from which you can run automatic database diagnostic monitoring in real time to diagnose problems with a slow or hung database.

  See "Diagnosing Serious Performance Problems in Real Time" for more information.