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
Deprecated/Dropped Users as Part of Default Install
|
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
|
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
Deprecated/Dropped Object Privileges
|
- |
02-Jan-2021 |
New 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 |
30-Dec-2020 |
New Built-In Packages
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
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_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 |
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 |