Changes in This Release for Oracle Database PL/SQL Packages and Types Reference

New Features

The following features are new in this release:

• Decision Tree Mining Text Data

  See DBMS_DATA_MINING

• Native Text Support

  See DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM

• Native Text Support

  See DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM

• XStream Support for XML Object Relational and Binary

  See Logical Change Record TYPEs

• Native Double in Data Mining Functions

  See DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM

• Feature Selection and Creation for Generalized Linear Models (GLM)

  See DBMS_DATA_MINING_TRANSFORM

• Expectation Maximization (EM) Clustering and Density Estimation

  See DBMS_DATA_MINING

• Feature Extraction Using Singular Value Decomposition

  See DBMS_DATA_MINING

• Privilege Analysis

  See DBMS_PRIVILEGE_CAPTURE

• Database Replay Support for Database Consolidation

  See DBMS_WORKLOAD_REPLAY

• Rules Engine Result Cache

  See DBMS_RULE

• AQ Rules Engine Fast Evaluation of SYS_CONTEXT and Other Predicates

  See DBMS_RULE

• Oracle Data Redaction

  See DBMS_REDACT

• Real-Time Database Operations Monitoring

  See DBMS_MONITOR

• Support for Secure Hash Algorithm SHA-2 in Oracle Database

  See DBMS_CRYPTO

• Pluggable Databases Resource Plans

  See DBMS_RESOURCE_MANAGER

• Segment-Level Compression Tiering

  See DBMS_ILM, DBMS_ILM_ADMIN and DBMS_HEAT_MAP

• Row-Level Compression Tiering

  See DBMS_ILM, DBMS_ILM_ADMIN and DBMS_HEAT_MAP

• PL/SQL Interface for Managing ADO Policies

  See DBMS_ILM, DBMS_ILM_ADMIN and DBMS_HEAT_MAP

• Resource Manager Runaway Query Management

  See DBMS_RESOURCE_MANAGER

• Oracle Data Pump No Logging Option for Import

  See DBMS_DATAPUMP

• Oracle Data Pump Export View As a Table

  See DBMS_DATAPUMP and DBMS_METADATA

• Oracle Data Pump: Support SecureFiles LOB as Default

  See DBMS_DATAPUMP and DBMS_METADATA

• Pluggable Databases

  See DBMS_PDB and UTL_RECOMP

• Synchronous Materialized View Refresh

  See DBMS_SYNC_REFRESH

• Enhanced Parallel Statement Queuing

  See DBMS_RESOURCE_MANAGER and DBMS_SESSION

• XStream New Apply Parameters

  See DBMS_APPLY_ADM

• XStream Optimized Management of Large Transactions

  See DBMS_APPLY_ADM

• Adaptive SQL Plan Management

  See DBMS_AUTO_SQLTUNE, DBMS_SPM and DBMS_XPLAN

• SQL Plan Directives

  See DBMS_SPD and DBMS_STATS

• Mechanism to Pass Results From SQL Statements Embedded in Database PL/SQL Programs Implicitly to the External Client Program

  See DBMS_SQL

• Concurrent Statistics Gathering

  See DBMS_SPD and DBMS_STATS

• Application Continuity for Java

  See DBMS_APP_CONT and DBMS_SERVICE

• SQL Translation Framework

  See DBMS_SERVICE, DBMS_SQL and DBMS_SQL_TRANSLATOR

• New Types of Optimizer Statistics

  See DBMS_SPD and DBMS_STATS

• Session-Private Statistics for Global Temporary Table

  See DBMS_SPD and DBMS_STATS

• Adaptive Query Optimization

  See DBMS_XPLAN

• Rolling Upgrade Using Active Data Guard

  See DBMS_ROLLING

• Enable Digest Authentication with Oracle Database HTTP Listener

  See DBMS_XDB, DBMS_XDB_ADMIN and DBMS_XDBZ

• XStream New Capture Parameters

  See DBMS_CAPTURE_ADM

• Online Redefinition of Multiple Partitions

  See DBMS_REDEFINITION

• Support Redefinition of Tables With VPD Policies

  See DBMS_REDEFINITION

• Lock Timeout for FINISH_REDEF_TABLE

  See DBMS_REDEFINITION

• New Job Types

  See DBMS_SCHEDULER

• Native Text Support

  See DBMS_DATA_MINING and DBMS_DATA_MINING_TRANSFORM

• Sharded Queues for Performance and Scalability

  See DBMS_AQ, DBMS_AQADM and DBMS_PROPAGATION_ADM

• New PL/SQL DBMS_UTILITY.EXPAND_SQL_TEXT Procedure

  See DBMS_UTILITY

• New PL/SQL Package UTL_CALL_STACK

  See UTL_CALL_STACK

• Oracle Data Pump Support for Database Consolidation: Full Transportable

  See DBMS_DATAPUMP

• Automatic Column Group Detection

  See DBMS_STATS

• Heat Map

  See DBMS_HEAT_MAP, DBMS_ILM, DBMS_ILM_ADMIN and DBMS_FLASHBACK

• New schema Parameter for DBMS_SQL.PARSE Procedure

  See DBMS_SQL

• Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition

  See DBMS_PART

• VPD Fine-Grained Context-Sensitive Policies

  See DBMS_RLS

• Out-of-Place Materialized View Refresh

  See DBMS_MVIEW

• Improved Automatic Degree of Parallelism

  See DBMS_STATS

• Transparent Sensitive Data Protection

  See DBMS_TSDP_MANAGE and DBMS_TSDP_PROTECT

• Oracle Data Pump Enhanced Compression Options

  See DBMS_DATAPUMP

• Enhancements to System Statistics

  See DBMS_STATS

• Transaction Guard

  See DBMS_APP_CONT

• Enhancements to Incremental Statistics

  See DBMS_STATS

• Temporal Validity Flashback Queries

  See DBMS_FLASHBACK_ARCHIVE

• LOGTIME Parameter for Oracle Data Pump Command

  See DBMS_DATAPUMP

• Queryable Patch Inventory

  See DBMS_QOPATCH

• Enterprise Manager Database Express

  See DBMS_XDB_ADMIN and DBMS_XDB_CONFIG