The following features are new in this release:

• DBMS_ADDM

  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. Two new parameters, CDB_TYPE_OVERRIDE and READ_ONLY_TYPE_OVERRIDE added to the following subprograms to the DBMS_ADDM package:

  • ANALYZE_DB Procedure
  • ANALYZE_INST Procedure
  • ANALYZE_PARTIAL Procedure
  • COMPARE_CAPTURE_REPL AY_REPORT Function
  • COMPARE_DATABASES Function
  • COMPARE_INSTANCES Function
  • COMPARE_REPLAY_REPLA Y_REPORT Function
  • REAL_TIME_ADDM_REPORT Function

• DBMS_AUTO_INDEX

  The new package DBMS_AUTO_INDEX provides an interface for configuring auto indexes and generating reports containing the details of the executed automatic indexing operations in a database.

  See "DBMS_AUTO_INDEX"

• DBMS_CREDENTIAL

  You can also use the DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure to manage the credentials for cloud object storage. The credential parameter of impdb specifies the name of a credential object that contains the user name and password required to access an object store bucket. You can also specify a default credential using the database property DEFAULT_CREDENTIAL.

• DBMS_HADOOP

  Oracle Database now supports hybrid partitioned tables. A hybrid partitioned table is a partitioned table in which some partitions reside in the database and some partitions reside outside the database in external files, such as operating system files or Hadoop Distributed File System (HDFS) files.

  A new procedure CREATE_HYBRID_PARTNED_TABLE is added to the DBMS_HADOOP package.

• DBMS_INMEMORY_ADMIN

  A new function POPULATE_WAIT is added to DBMS_INMEMORY_ADMIN package. This function ensures that the specified In-Memory objects have been populated before allowing application access.

• DBMS_MEMOPTIMIZE

  The following new subprograms are added to the DBMS_MEMOPTIMIZE package as part of the Memoptimized Rowstore fast ingest feature:

  • GET_APPLY_HWM_SEQID

  • GET_WRITE_HWM_SEQID

  • WRITE_END

  See "DBMS_MEMOPTIMIZE"

• DBMS_MEMOPTIMIZE_ADMIN

  The new package DBMS_MEMOPTIMIZE_ADMIN provides an interface for flushing the Memoptimized Rowstore data buffered in the large pool to disk.

  See "DBMS_MEMOPTIMIZE_ADMIN"

• DBMS_METADATA

  The following new transform parameters which are used by the metadata layer of datapump are added to the DBMS_METADATA.SET_TRANSFORM_PARAM procedure:

  • OMIT_ENCRYPTION_CLAUSE
  • DWCS_CVT_IOTS
  • DWCS_CVT_CONSTRAINTS
  • CONSTRAINT_USE_DEFAULT_INDEXES
  • CONSTRAINT_NAME_FROM_INDEXES

• DBMS_MVIEW

  Oracle Database now supports hybrid partitioned tables. A hybrid partitioned table is a partitioned table in which some partitions reside in the database and some partitions reside outside the database in external files, such as operating system files or Hadoop Distributed File System (HDFS) files.

  A new parameter, SKIP_EXT_DATA, is added to the DBMS_MVIEW.REFRESH procedure.

• DBMS_SQLQ

  The new package DBMS_SQLQ provides an interface for configuring quarantine thresholds for SQL statements and their execution plans. The SQL statements that cross the quarantine thresholds are quarantined and are not allowed to run again in a database.

  See "DBMS_SQLQ"

• DBMS_SQLDIAGNew SQL Repair Advisor function DBMS_SQLDIAG.SQL_DIAGNOSE_AND_REPAIR

  The new SQL Repair Advisor function DBMS_SQLDIAG.SQL_DIAGNOSE_AND_REPAIR creates a diagnostic task, executes it, and accepts SQL patch recommendation for a SQL statement that is generating a critical error. This function helps users to diagnose and fix problems.

• DBMS_SODA

  DBMS_SODA is a PL/SQL package implementing Simple Oracle Document Access (SODA) which allows you to use the Oracle Database as a NoSQL document store. Additional functions and features are added in this release.

• DBMS_STATS

  A new boolean parameter REALTIME_STATS is added to GET_TABLE_STATS and GET_COLUMN_STATS procedures.

• DBMS_XPLAN

  New COMPARE_PLANS function added to the DBMS_XPLAN package. This function compares each plan in a list with a reference plan and returns the report.

• Key-based Messaging

  The following new parameters are added to the GET_QUEUE_PARAMETER, SET_QUEUE_PARAMETER, and UNSET_QUEUE_PARAMETER procedures of the DBMS_AQADM package as part of the Key-based messaging feature:

  • Sharded queue parameters
    • SHARD_NUM
    • KEY_BASED_ENQUEUE
    • STICKY_DEQUEUE
  • Key-based parameters
    • AQ$KEY_TO_SHARD_MAP
    • AQ$GET_KEY_SHARD_INST

  See "DBMS_AQADM"