Changes in Oracle Database 12c Release 2 (12.2)

The following are changes in Oracle Database Development Guide for Oracle Database 12c Release 2 (12.2):

New Features

  • Dropping an edition has been enhanced to postpone dropping each editioned object it contains until after the object is no longer inherited by a usable descendent edition.

    See : Dropping an Edition
  • The PL/SQL Basic Block Coverage feature helps you insure some quality predictability and consistency by assessing how well your tests actually test your code. See : Using PL/SQL Basic Block Coverage to Maintain Quality

  • PL/Scope reports on SQL Identifier and Statement metadata for SQL statements, tables, views and sequences appearing in PL/SQL source code.

    See : Using PL/Scope
  • PL/SQL DEPRECATE pragma, See: Deprecating Packages, Subprograms, and Types

  • Sharding is the ability to partition data horizontally across independent databases. Each database in this configuration is called a shard. All the shards together make up a single logical database that is called a sharded database. See : Oracle Database Administrator’s Guide for more information about developing applications in a sharded database.

  • Added new MAX_TXN_THINK_TIME parameter to configure DRCP. See Configuring DRCP for more information.

  • Support for sharing proxy sessions in DRCP with other applications. See Sharing Proxy Sessions for more information.

  • Support for shared connections in both PDB and non-PDB environments using DRCP. See About Database Resident Connection Pool for more information.

  • Support for receiving FAN event notifications. See About Receiving FAN Event Notifications for more information.

  • Transaction Guard support for Oracle XA Transactions. See Using Transaction Guard for more information about Transaction Guard.

Deprecated Features

The following features are deprecated in this release, and may be desupported in a future release:

  • Oracle SQL Extensions (oracle.sql.*) are deprecated in favor of standard Java classes or oracle.jdbc extension types.

  • The DBMS_DEBUG package is deprecated. Use DBMS_DEBUG_JDWP package instead.

    See Debugging PL/SQL and Java for more information.

Desupported Features

Some features previously described in this document are desupported in Oracle Database 12c Release 2 (12.2).

  • Desupport of server-side SQLJ and JPublisher.