New In Oracle Database
Versions 20c and 21c

Description Link Last Modified
Architecture
Legacy, non-container architecture fully desupported - 29-Feb-2020
Attention Log Attention Log 19-Jan-2021
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
New
  • Object Type: MLE Language in namespaces 1 and 147
Deprecated/Desupported

  • Oracle Enterprise Manager Database Express (EM Express)
  • Oracle Wallet Manager
  • SHA-1 for DBMS_CRYPTO
  • SHA-1 for SQL*Net
  • MD4
  • MD5
 - 20-Dec-2020






12-Dec-2020
 
Security
Force upgraded password files to be case sensitive - 07-Mar-2020
DBMS_CRYPTO support for asymmetric key operations - -
Database clients can be configured to maintain multiple SSL sessions using different certificates - 07-Mar-2020
PASSWORD_ROLLOVER_TIME added to PROFILE Profiles 26-Dec-2020
STIG compliant Unified Audit Policies are predefined - 07-Mar-2020
Support for centrally managed wallets - 07-Mar-2020
USER_APPLICATION_ROLES view enhanced to show roles granted - 07-Mar-2020
 
General
New Users
  • DGPDB_INT
  • DV_OWNER
Deprecated/Dropped Users as Part of Default Install
  • TBD
 USERS 26-Dec-2020
New Roles
  • AVTUNE_PKG_ROLE
  • BDSQL_ADMIN
  • BDSQL_USER
  • GSMROOTUSER_ROLE
  • MAINTPLAN_APP
  • PPLB_ROLE
Deprecated/Dropped Roles as Part of Default Install
  • CSW_USR_ROLE
  • DV_PUBLIC
  • DV_REALM_OWNER
  • DV_REALM_RESOURCE
 ROLES 31-Dec-2020
New System Privileges
  • Create Logical Partition Tracking
  • Drop Logical Partition Tracking
  • Execute Dynamic MLE
  • Enable Diagnostics
Deprecated/Dropped System Privileges
  • None
 SYSTEM PRIVILEGES 10-Jan-2021
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
 - -
New Dynamic Performance Views
  • GV$ACTIVITY_MVIEW
  • GV$ACTIVITY_TABLE
  • GV$ALL_ACTIVE_SESSION_HISTORY
  • GV$ALL_SQL_MONITOR
  • GV$ALL_SQL_PLAN
  • GV$ALL_SQL_PLAN_MONITOR
  • GV$AQ_DEQUEUE_SESSIONS
  • GV$AQ_PARTITION_STATS
  • GV$ASM_ACFSAUTORESIZE
  • GV$AV_BTT_CACHE
  • GV$BCAPPLY_STATS
  • GV$BUILD_INFO
  • GV$COMPATIBILITY_REQUIREMENT
  • GV$CONNECTION_BROKER
  • GV$CONSENSUS_CLIENTS
  • GV$CONSENSUS_LOGS
  • GV$CONSENSUS_STATS
  • GV$CONTAINER_TOPOLOGY
  • GV$CON_WAITCLASSMETRIC
  • GV$CON_WAITCLASSMETRIC_HISTORY
  • GV$DG_BROKER_PROPERTY
  • GV$DG_BROKER_PROPERTY_INT
  • GV$DIAG_USER_TRACE_RECORDS
  • GV$EQ_CACHED_PARTITIONS
  • GV$EQ_CROSS_INSTANCE_JOBS
  • GV$EQ_DEQUEUE_SESSIONS
  • GV$EQ_INACTIVE_PARTITIONS
  • GV$LCR_CACHE
  • GV$LISTENER_HEALTH
  • GV$EQ_MESSAGE_CACHE
  • GV$EQ_MESSAGE_CACHE_ADVICE
  • GV$EQ_MESSAGE_CACHE_STAT
  • GV$EQ_NONDUR_SUBSCRIBER
  • GV$EQ_NONDUR_SUBSCRIBER_LWM
  • GV$EQ_PARTITION_STATS
  • GV$EQ_REMOVE_DEQUEUE_AFFINITY
  • GV$EQ_SUBSCRIBER_LOAD
  • GV$EQ_SUBSCRIBER_STAT
  • GV$EQ_SUBSCR_REGISTRATION_STATS
  • GV$EQ_UNCACHED_PARTITIONS
  • GV$FOREIGN_DATAFILE_COPY
  • GV$GCS_LOCK_STATE_RESOLUTION_HISTORY
  • GV$LISTENER_HEALTH
  • GV$MDX_CURSOR
  • GV$MDX_CURSOR_DEPENDENCY
  • GV$PKCS11_PATH
  • GV$PQ_SLAVEINFO
  • GV$QUERY_BLOCK_ORIGIN
  • GV$RESULT_SUBCACHE_STATISTICS
  • GV$SECUREFILE_SHRINK
Deprecated/Dropped Dynamic Performance Views

  • V$CELL_DB_HISTORY
  • V$OBJECT_USAGE (deprecated as of 12.1)
  • V$XML_AUDIT_TRAIL
 Dynamic Performance Views 28-Dec-2020
New Object Privileges
  • None
Deprecated/Dropped Object Privileges

  • None
 - 02-Jan-2021
New Hints
  • TBD
 - -
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 30-Dec-2020
New Built-In Packages
  • See below
Dropped Built-In Packages
  • DBMS_CLR
  • DBMS_CRYPTO_TOOLKIT
  • DBMS_CRYPTO_TOOLKIT_FFI
  • DBMS_CRYPTO_TOOLKIT_TYPES
  • DBMS_OBFUSCATION_TOOLKIT
  • DBMS_OBFUSCATION_TOOLKIT_FFI
  • DBMS_SERVER_TRACE
  • ORDIMDPCALLOUTS
  • ORD_ADMIN
  • ORD_DICOM_ADMIN_PRV
  • ORD_DICOM_CT
  • ORD_DICOM_PKG
  • UTL_ORAMTS
  • UTL_SPADV
 Built-In Packages 31-Dec-2020
 
Other Deprecated or Dropped Objects
TBD   -
 
Object Types and Features
New
  • BlockChain Tables
Deprecated and Desupported
  • Legacy (Non-Container) Architecture
  • Obfuscation Toolkit
 BlockChain Tables


 		 27-Dec-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
SQL Macros SQL Macros 04-Jan-2021
 
PL/SQL Changes
SQL Macros SQL Macros 04-Jan-2021
FOR LOOP Enhancement Control Structures 08-Jan-2021
New PL/SQL Informational Warning Messages (06027, 06028, 06029) PL/SQL Warnings 01-Jan-2021
New PL/SQL Severe Warning Messages (05026, 05027, 05028, 05029) PL/SQL Warnings 01-Jan-2021
Dropping PLW-07202 was announced in version 12.2 but was not done until 20c PL/SQL Warnings 01-Jan-2021
New Pragma SUPPRESS_WARNING_6009 PRAGMAS 01-Jan-2021
 
New or Modified Functions, Operators, Procedures, and Types
AVTUNE_LOG_LISTAGGCLOB$ SYS Owned Functions 02-Jan-2021
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_HCS DBMS_FEATURE Procedures 26-Dec-2020
DBMS_FEATURE_IM_BASE_LEVEL DBMS_FEATURE Procedures 08-Dec-2020
DBMS_FEATURE_SEHA DBMS_FEATURE Procedures 26-Dec-2020
DG$GETFLATDG Dropped SYS Owned Functions 02-Jan-2021
GET_SUPPORT_MODE SYS Owned Functions 02-Jan-2021
GET_SUPPORT_REASON SYS Owned Functions 02-Jan-2021
JSON$CHECK_EXPR SYS Owned Functions 02-Jan-2021
KCISYS_BITMAPAGG SYS Owned Functions 02-Jan-2021
KCISYS_CATRSIAGG SYS Owned Functions 02-Jan-2021
KCISYS_RSIAGG SYS Owned Functions 02-Jan-2021
ONAME SYS Owned Functions 02-Jan-2021
PNAME SYS Owned Functions 02-Jan-2021
SPATIALACTIVE SYS Owned Functions 02-Jan-2021
TKHCS_LOG_LISTAGGCLOB SYS Owned Functions 02-Jan-2021
VERIFY_FUNCTION Dropped SYS Owned Functions 02-Jan-2021
VERIFY_FUNCTION_11G Dropped SYS Owned Functions 02-Jan-2021
 
Renamed Objects
None Identified So Far - -
 
New or Modified Functions, Operators, Procedures, and Types
ANY_VALUE ANY_VALUE 06-Nov-2020
 
Changes to JSON, SODA and XML
TBD - -
 
New Built-in Packages
DBFS_OFS_CONVERSION DBFS_OFS_CONVERSION 12-Dec-2020
DBMS_ACTIVITY DBMS_ACTIVITY 13-Dec-2020
DBMS_ADBTASK_ADMIN DBMS_ADBTASK_ADMIN 12-Dec-2020
DBMS_APP_CONT_REPORT DBMS_APP_CONT_REPORT 14-Dec-2020
DBMS_AQ_IND_MON DBMS_AQ_IND_MON 12-Dec-2020
DBMS_AQ_SUB DBMS_AQ_SUB 12-Dec-2020
DBMS_AUTO_MV DBMS_AUTO_MV 13-Dec-2020
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_AVTUNE_UTIL DBMS_AVTUNE_UTIL 17-Dec-2020
DBMS_AWRHUB DBMS_AWRHUB 16-Dec-2020
DBMS_AWRHUB_SERVER DBMS_AWRHUB_SERVER 16-Dec-2020
DBMS_AWRHUB_SOURCE DBMS_AWRHUB_SOURCE 16-Dec-2020
DBMS_AWR_ANALYTICS DBMS_AWR_ANALYTICS 27-Dec-2020
DBMS_BLOCKCHAIN_TABLE DBMS_BLOCKCHAIN_TABLE 27-Dec-2020
DBMS_BLOCKCHAIN_UTL DBMS_BLOCKCHAIN_UTL 27-Dec-2020
DBMS_CLOUD DBMS_CLOUD 05-Dec-2020
DBMS_CLOUD_TYPES DBMS_CLOUD_TYPES 05-Dec-2020
DBMS_CUBE_PRVTEXP DBMS_CUBE_PRVTEXP 17-Dec-2020
DBMS_DLM DBMS_DLM 27-Dec-2020
DBMS_FLASHBACK_ARCHIVE_MIGRATE DBMS_FLASHBACK_ARCHIVE_MIGRATE 13-Dec-2020
DBMS_GSM_DDL DBMS_GSM_DDL 06-Dec-2020
DBMS_GSM_SEC DBMS_GSM_SEC 06-Dec-2020
DBMS_HCS_LOG DBMS_HCS_LOG 17-Dec-2020
DBMS_MAINTPLAN DBMS_MAINTPLAN 19-Dec-2020
DBMS_MAX_STRING_SIZE DBMS_MAX_STRING_SIZE 05-Jan-2021
DBMS_MDX_UTIL DBMS_MDX_UTIL 22-Dec-2020
DBMS_MLE DBMS_MLE 20-Dec-2020
DBMS_OPTIM_BUNDLE DBMS_OPTIM_BUNDLE 06-Jan-2021
DBMS_PQDIAG DBMS_PQDIAG 06-Jan-2021
DBMS_REPLAYHUB DBMS_REPLAYHUB 04-Jan-2021
DBMS_SWAT DBMS_SWAT 13-Dec-2020
DBMS_SWAT_ARM_INTERNAL DBMS_SWAT_ARM_INTERNAL 31-Dec-2020
DBMS_SWAT_INTERNAL DBMS_SWAT_INTERNAL 23-Dec-2020
DBMS_SWAT_MM_INTERNAL DBMS_SWAT_MM_INTERNAL 06-Jan-2021
DBMS_SWAT_MM_UTILS DBMS_SWAT_MM_UTILS 07-Jan-2021
DBMS_SWAT_VER_INTERNAL DBMS_SWAT_VER_NTERNAL 28-Dec-2020
DBMS_SYS_MLE DBMS_SYS_MLE 20-Dec-2020
DBMS_TABLE_DATA DBMS_TABLE_DATA 27-Dec-2020
DBMS_TEQK DBMS_TEQK 24-Dec-2020
DBMS_TSDP_PROTECT_INT DBMS_TSDP_PROTECT_INT 24-Dec-2020
DBMS_USER_CERTS DBMS_USER_CERTS 27-Dec-2020
DBMS_WRR_STATE_BASE DBMS_WRR_STATE_BASE 23-Dec-2020
LBAC_POLICY_ADMIN_INT LBAC_POLICY_ADMIN_INT 21-Dec-2020
LTI LTI 30-Dec-2020
SA_USER_ADMIN_INT SA_USER_ADMIN_INT 05-Jan-2021
 
Built-in Packages with New or Removed Objects
DBMS_APP_CONT_ADMIN has 5 new objects DBMS_APP_CONT_ADMIN 14-Dec-2020
DBMS_ASSERT has new SIMPLE_SQL_NAME_LIST function DBMS_ASSERT 07-Dec-2020
DBMS_BLOCKCHAIN_TABLE has 4 new objects DBMS_BLOCKCHAIN_TABLE 27-Dec-2020
DBMS_BLOCKCHAIN_UTL has new IS_COPIER object DBMS_BLOCKCHAIN_UTL 27-Dec-2020
DBMS_CLOUD has 11 new objects DBMS_CLOUD 14-Dec-2020
DBMS_GSM_FIXED has 4 new objects DBMS_GSM_FIXED 06-Dec-2020
DBMS_GSM_SEC has new PUTCATUSER procedure DBMS_GSM_SEC 19-Jan-2021
DBMS_LOB LOADFROMFILE and LOB new buffering support DBMS_LOB 22-Dec-2020
DBMS_PLSQL_CODE_COVERAGE has new GET_BLOCK_MAP function DBMS_PLSQL_CODE_COVERAGE 22-Dec-2020
DBMS_REGISTRY_SYS has 2 new objects DBMS_REGISTRY_SYS 18-Dec-2020
DBMS_WORKLOAD_REPOSITORY has new AWR_EXP procedure DBMS_WORKLOAD_REPOSITORY 22-Jan-2021
DBMS_WRR_INTERNAL dropped the EXPORT_REP_EXT_TBL procedure DBMS_WRR_INTERNAL 23-Dec-2020
DBMS_WRR_PROTECTED has new GET_DBREPLAY_PATCH_INFO function DBMS_WRR_PROTECTED 23-Dec-2020
DBMS_XSTREAM_GG_ADM has new PURGE_TXN_CDR_INFO object DBMS_XSTREAM_GG_ADM 04-Jan-2021
KBRSI_ICD has 19 new objects KBRSI_ICD 17-Jan-2021
KBRSI_ICD has 4 objects removed KBRSI_ICD 17-Jan-2021
 
Built-in Packages with New or Removed Overloads
DBMS_CLOUD.CREATE_CREDENTIAL has a new overload DBMS_CLOUD 14-Dec-2020
 
Built-in Packages with Parameters Changes
DBMS_APP_CONT_PRVT.REPARE_REPLAY has 4 new parameters DBMS_APP_CONT_ADMIN 14-Dec-2020
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 03-Jan-2021
DBMS_SNAPSHOT_UTL has new IMPORT_LPT_TRIGGER_STRING and SYNC_UP_LPT objs DBMS_SNAPSHOT_UTL 22-Jan-2021
KBRSI_ICD.RSKRSPDELETEDB has new P_TKEY parameter KBRSI_ICD 17-Jan-2021
KBRSI_ICD.RSSCHEDUNLOCK modified from BINARY_INTEGER (19c) to BOOLEAN (21c) KBRSI_ICD 17-Jan-2021
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_BLOCKCHAIN_TABLE has new SIGN_ALGO_DEFAULT Constant DBMS_BLOCKCHAIN_TABLE 27-Dec-2020
DBMS_CLOUD has added new constants with version 21c DBMS_CLOUD 14-Dec-2020
DBMS_CLOUD_TYPES has 2 new constants with version 21c DBMS_CLOUD_TYPES 14-Dec-2020
DBMS_CLOUD_TYPES has 2 new types and has altered LIST_OBJECT_RET_T in 21c DBMS_CLOUD_TYPES 14-Dec-2020
DBMS_DB_VERSION has new 20c and 21c Constants DBMS_DB_VERSION 09-Jan-2021
DBMS_LCR has 2 new OSON constants for JSON DBMS_LCR 18-Dec-2020
 
Related Topics
New in 11.2
New in 12.1
New in 12.2
New in 18c
New in 19c
New in 20c
  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