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):

• 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.