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
DRnn Background Process Dropped Background Processes 12-Nov-2020
New MZnn Background Process Added Background Processes 12-Nov-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
  • AVTUNE_PKG_ROLE
  • BDSQL_ADMIN
  • BDSQL_USER
  • GSMROOTUSER_ROLE
  • PPLB_ROLE
Deprecated/Dropped Roles as Part of Default Install
  • CSW_USR_ROLE
ROLES 17-Nov-2020
New System Privileges
  • None
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_CLR
  • DBMS_OBFUSCATION_TOOLKIT
  • DBMS_OBFUSCATION_TOOLKIT_FFI
  • ORDIMDPCALLOUTS
  • ORD_ADMIN
Built-In Packages 28-Nov-2020
 
Other Deprecated or Dropped Objects
TBD   -
 
Object Types and Features
New
  • BlockChain Tables
Deprecated
  • Legacy (Non-Container) Architecture
  • Obfuscation Toolkit
BlockChain Tables


 
19-Nov-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
DBMS_FEATURE_APPROX_QP DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_EM_DIAG DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_EM_GC DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_EM_INT DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_EM_TUNING DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_IM_BASE_LEVEL DBMS_FEATURE Procedures 08-Dec-2020
 
Renamed Objects
None Identified - -
 
New or Modified Functions, Operators, Procedures, and Types
ANY_VALUE ANY_VALUE 06-Nov-2020
 
Changes to JSON, SODA and XML
None Identified - -
 
New Built-in Packages
DBFS_OFS_CONVERSION DBFS_OFS_CONVERSION 12-Dec-2020
DBMS_ADBTASK_ADMIN DBMS_ADBTASK_ADMIN 12-Dec-2020
DBMS_AQ_IND_MON DBMS_AQ_IND_MON 11-Feb-2021
DBMS_AQ_SUB DBMS_AQ_SUB 11-Feb-2021
DBMS_AUTO_SQLSET DBMS_AUTO_SQLSET 12-Dec-2020
DBMS_AUTO_ZONEMAP DBMS_AUTO_ZONEMAP 12-Dec-2020
DBMS_AUTO_ZONEMAP_INTERNAL DBMS_AUTO_ZONEMAP_INTERNAL 12-Dec-2020
DBMS_AVTUNE DBMS_AVTUNE 17-Dec-2020
DBMS_AWRHUB_SERVER DBMS_AWRHUB_SERVER 30-Nov-2020
DBMS_AWRHUB_SOURCE DBMS_AWRHUB_SOURCE 30-Nov-2020
DBMS_AWR_ANALYTICS DBMS_AWR_ANALYTICS 27-Nov-2020
DBMS_BLOCKCHAIN_TABLE DBMS_BLOCKCHAIN_TABLE 24-Nov-2020
DBMS_BLOCKCHAIN_UTL DBMS_BLOCKCHAIN_UTL 25-Nov-2020
DBMS_CLOUD DBMS_CLOUD 05-Dec-2020
DBMS_CLOUD_TYPES DBMS_CLOUD_TYPES 05-Dec-2020
DBMS_DLM DBMS_DLM 28-Nov-2020
DBMS_GSM_DDL DBMS_GSM_DDL 06-Dec-2020
DBMS_GSM_SEC DBMS_GSM_SEC 06-Dec-2020
DBMS_MAX_STRING_SIZE DBMS_MAX_STRING_SIZE 26-Nov-2020
DBMS_MDX_UTIL DBMS_MDX_UTIL -
DBMS_MLE DBMS_MLE 21-Mar-2021
DBMS_OPTIM_BUNDLE DBMS_OPTIM_BUNDLE 28-Nov-2020
DBMS_PQDIAG DBMS_PQDIAG 28-Nov-2020
DBMS_TABLE_DATA DBMS_TABLE_DATA 09-Dec-2020
DBMS_TSDP_PROTECT_INT DBMS_TSDP_PROTECT_INT -
DBMS_USER_CERTS DBMS_USER_CERTS 25-Nov-2020
DBMS_WRR_STATE_BASE DBMS_WRR_STATE_BASE -
LBAC_POLICY_ADMIN_INT LBAC_POLICY_ADMIN_INT -
LTI LTI -
 
Built-in Packages with New or Removed Objects
Package has new SIMPLE_SQL_NAME_LIST function DBMS_ASSERT 07-Dec-2020
Package has 4 new objects DBMS_GSM_FIXED 06-Dec-2020
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
None Identified   -
 
Built-in Packages with Parameters Changes
DBMS_DST.UPGRADE_TABLE has a new FROM_TZ_VERSION parameter DBMS_DST 07-Dec-2020
DBMS_SERVICE.DISCONNECT_SESSION has new GUID parameter DBMS_SERVICE 28-Nov-2020
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
None Identified   -
 
Related Topics
New in 11.2
New in 12.1
New in 12.2
New in 18c
New in 19c
New in 21c
  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