New In Oracle Database
Version 20c

Description Link Last Modified
Architecture & Features
Legacy, non-container architecture has been is no longer supported - 29-Feb-2020
Persistent Memory Database and FileStore Persistent Memory DB 17-Apr-2020
SecureFile Defragmentation SecureFiles 28-Mar-2020
 
Security
Force upgraded password files to be case sensitive - 07-Mar-2020
Database clients can be configured to maintain multiple SSL sessions using different certificates - 07-Mar-2020
Support for centrally managed wallets - 07-Mar-2020
USER_APPLICATION_ROLES view enhanced to show roles granted - 07-Mar-2020
STIG compliant Unified Audit Policies are predefined - 07-Mar-2020
  -  
 
General
New Users
  • DV_OWNER
Deprecated/Dropped Users as Part of Default Install
  • TBD
USERS 09-Apr-2020
New Roles
  • TBD
Deprecated/Dropped Roles as Part of Default Install
  • TBD
ROLE -
New System Privileges
  • ENABLE DIAGNOSTICS
Deprecated/Dropped System Privileges
  • None
SYSTEM PRIVILEGES 19-Apr-2020
New Data Dictionary Objects
  • DBA_OGG_AUTO_CAPTURED_TABLES
  • USER_OGG_AUTO_CAPTURED_TABLES
Deprecated/Dropped Data Dictionary Objects
  • ALL_DEF_AUDIT_OPTS
  • AUDIT_ACTIONS
  • DBA_AUDIT_EXISTS
  • DBA_AUDIT_OBJECT
  • DBA_AUDIT_SESSION
  • DBA_AUDIT_STATEMENT
  • DBA_AUDIT_TRAIL
  • DBA_COMMON_AUDIT_TRAIL
  • DBA_FGA_AUDIT_TRAIL
  • DBA_OBJ_AUDIT_OPTS
  • DBA_PRIV_AUDIT_OPTS
  • DBA_STMT_AUDIT_OPTS
  • USER_AUDIT_OBJECT
  • USER_AUDIT_SESSION
  • USER_AUDIT_STATEMENT
  • USER_AUDIT_TRAIL
  • USER_OBJ_AUDIT_OPTS
- 09-Apr-2020
New Dynamic Performance Views
  • TBD
Deprecated/Dropped Dynamic Performance Views

  • V$XML_AUDIT_TRAIL
Dynamic Performance Views -
New Object Privileges
  • TBD
Deprecated/Dropped Object Privileges

  • TBD
Object Privileges -
New Hints
  • TBD
Hints -
New Initialization Parameters
  • DBNEST_ENABLE
  • DBNEST_PDB_FS_CONF
  • DIAGNOSTICS_CONTROL
  • INMEMORY_DEEP_VECTORIZATION
  • PMEM_FILESTORE
  • TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM
Deprecated/Dropped Initialization Parameters
  • AUDIT_FILE_DEST
  • AUDIT_SYS_OPERATIONS
  • AUDIT_SYSLOG_LEVEL
  • AUDIT_TRAIL
  • IGNORE_CASE
  • UNIFIED_AUDIT_SGA_QUEUE_SIZE
Startup Parameters 09-Apr-2020
New Built-In Packages
  • See below
Dropped Built-In Packages
  • DBMS_OBFUSCATION_TOOLKIT
  • DBMS_OBFUSCATION_TOOLKIT_FFI
Built-In Packages 09-Apr-2020
 
Deprecated or Dropped Objects
TBD   -
 
Object Types & Features
New
  • BlockChain Tables
Deprecated
  • TBD
BlockChain Tables 29-Feb-2020
 
New SQL
EXCEPT Set Operator Oracle Operators 25-Mar-2020
INTERSECT ALL Set Operator Oracle Operators 25-Mar-2020
MINUS ALL Set Operator Oracle Operators 25-Mar-2020
Process Identifier (PID) userenv Constant SYS_CONTEXT 27-Mar-2020
 
New PL/SQL
New PL/SQL Informational Warning Messages (06027, 06028, 06029) PL/SQL Warnings 28-Mar-2020
New PL/SQL Severe Warning Messages (05026, 05027, 05028, 05029) PL/SQL Warnings 28-Mar-2020
New Pragma SUPPRESS_WARNING_6009 PRAGMAS 28-Mar-2020
 
New or Modified Functions, Operators, Procedures, and Types
TBD - -
 
Renamed Objects
TBD - -
 
New or Modified Functions, Operators, Procedures, and Types
TBD - -
 
Changes to JSON, SODA and XML
TBD - -
 
New Built-in Packages
DBMS_AUTO_ZONEMAP DBMS_AUTO_ZONEMAP 29-Feb-2020
DBMS_BLOCKCHAIN_TABLE DBMS_BLOCKCHAIN_TABLE 29-Feb-2020
DBMS_USER_CERTS DBMS_USER_CERTS 29-Feb-2020
 
Built-in Packages with New or Removed Objects
LOAD_FROM_FILE and LOB Buffering Supported in DBMS_LOB DBMS_LOB 09-Apr-2020
DBMS_PLSQL_CODE_COVERAGE has new GET_BLOCK_MAP function DBMS_PLSQL_CODE_COVERAGE 08-Mar-2020
 
Built-in Packages with New or Removed Overloads
TBD   -
 
Built-in Packages with Parameters Changes
DBMS_ROLLING has new BLOCK_UNSUPPORTED parameter DBMS_ROLLING 08-Mar-2020
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
TBD   -
 
Related Topics
New in 11.2
New in 12.1
New in 12.2
New in 18c
New in 19c
  Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx