New In Oracle Database
Versions 20c and 21c

Description Link Last Modified
General
Version 20c was only released in the Oracle Cloud
Version 21.1 was only released in the Oracle Cloud - it was, in everything except name, the final beta
Version 21.2 was released as the first version of the Oracle 21c Autonomous Database
Version 21.3 was the first Generally Available (GA) release
 
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
  • MAX_IDLE_BLOCKER_TIME
  • 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_HETEROGENEOUS_SNAPSHOT
  • DBMS_HS_PARALLEL
  • DBMS_HS_PARALLEL_METADATA
  • DBMS_HS_PASSTHROUGH
  • DBMS_IAS_CONFIGURE
  • DBMS_IAS_QUERY
  • DBMS_IAS_SESSION
  • DBMS_IAS_TEMPLATE
  • DBMS_LIBCACHE
  • DBMS_LIBCACHE$DEF
  • DBMS_MGWMDG
  • DBMS_OBFUSCATION_TOOLKIT
  • DBMS_OBFUSCATION_TOOLKIT_FFI
  • DBMS_SERVER_TRACE
  • DBMS_WRR_STATE (present in 21.1 but dropped in 21.3)
  • DBMS_WRR_STATE_BASE (present in 21.1 but dropped in 21.3)
  • ORDIMDPCALLOUTS
  • ORDIMGSIG_PKG
  • ORDIMGSI_PKG
  • ORD_ADMIN
  • ORD_DICOM_ADMIN_PRV
  • ORD_DICOM_CT
  • ORD_DICOM_PKG
  • UTL_ORAMTS
  • UTL_SPADV
 Built-In Packages 12-Jun-2021
 
Other Deprecated or Dropped Objects
TBD   -
 
Object Types and Features
New
  • Blockchain Tables
  • Immutable Tables
  • JSON Data Type
  • Transactional Event Queues add to Advanced Queueing
Deprecated and Desupported
  • Legacy (Non-Container) Architecture
  • Obfuscation Toolkit
 BlockChain Tables
Immutable Tables
Data Types
DBMS_AQADM



 

24-Aug-2021
24-Aug-2021
30-Jun-2021
06-Feb-2021



06-Feb-2021
06-Feb-2021
 
 
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
ORA_SHARDSPACE_NAME Pseudocolumn Pseudocolumns 19-Jun-2021
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_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
IS NOT NULL JSON Functions 30-Jun-2021
IS NULL JSON Functions 30-Jun-2021
JSON_EQUAL JSON Functions 30-Jun-2021
JSON_SCALAR JSON Functions 30-Jun-2021
JSON_SERIALIZE JSON Functions 30-Jun-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
SYS_CONTEXT TLS_VERSION SYS_CONTEXT 01-Apr-2022
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_AUDIT_MGMT_SUPPORT DBMS_AUDIT_MGMT_SUPPORT 24-Aug-2021
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 22-Aug-2021
DBMS_CLOUD_ADMIN DBMS_CLOUD_ADMIN 12-Mar-2023
DBMS_CLOUD_ADMIN_INTERNAL DBMS_CLOUD_ADMIN_INTERNAL 12-Mar-2023
DBMS_CLOUD_CAPABILITY DBMS_CLOUD_CAPABILITY 22-Aug-2021
DBMS_CLOUD_CORE DBMS_CLOUD_CORE 22-Aug-2021
DBMS_CLOUD_INTERNAL DBMS_CLOUD_INTERNAL 22-Aug-2021
DBMS_CLOUD_MACADM DBMS_CLOUD_MACADM 22-Aug-2021
DBMS_CLOUD_REQUEST DBMS_CLOUD_REQUEST 22-Aug-2021
DBMS_CLOUD_TASK DBMS_CLOUD_TASK 22-Aug-2021
DBMS_CLOUD_TYPES DBMS_CLOUD_TYPES 22-Aug-2021
DBMS_CUBE_PRVTEXP DBMS_CUBE_PRVTEXP 17-Dec-2020
DBMS_DLM DBMS_DLM 27-Dec-2020
DBMS_EDITIONS_UTILITIES2 DBMS_EDITIONS_UTILITIES2 24-Aug-2021
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_IMMUTABLE_TABLE DBMS_IMMUTABLE_TABLE 20-Aug-2021
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 21-Mar-2021
DBMS_OPTIM_BUNDLE DBMS_OPTIM_BUNDLE 06-Jan-2021
DBMS_PQDIAG DBMS_PQDIAG 06-Jan-2021
DBMS_REPLAYHUB DBMS_REPLAYHUB 19-Feb-2021
DBMS_XMLSCHEMA_UTIL DBMS_XMLSCHEMA_UTIL 03-Jul-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 (present in 21.1 but dropped in 21.3) DBMS_WRR_STATE_BASE 23-Dec-2020
LBAC_POLICY_ADMIN_INT LBAC_POLICY_ADMIN_INT 21-Dec-2020
LTI LTI 30-Dec-2020
REDO_DIFF REDO_DIFF 24-Aug-2021
SA_USER_ADMIN_INT SA_USER_ADMIN_INT 05-Jan-2021
TKHCS_LOG_PKG TKHCS_LOG_PKG 24-Aug-2021
UTL_RECOMP2 UTL_RECOMP2 23-Aug-2021
 
Built-in Packages with New or Removed Objects
CTX_DOC.FUNC_EVAL and .QUERY_IMCU removed CTX_DOC 03-Dec-2021
DBMS_APP_CONT_ADMIN has 5 new objects DBMS_APP_CONT_ADMIN 14-Dec-2020
DBMS_AQ has new SEEK procedure DBMS_AQ 08-Nov-2021
DBMS_AQADM_SYS has new AQTM_PARAM_CHK, ISTRANSACTIONALEVENTQUEUE, ISTXNEVENTQUEUE, and VERIFY_TRANSACTIONAL_EVENT_QUEUE objects DBMS_AQADM_SYS 08-Nov-2021
DBMS_AQADM has 6 new objects, 5 related to Transactional Event Queues DBMS_AQADM 06-Feb-2021
DBMS_ASH has new FETCH_OBJ_NAME and FETCH_SQLTEXT objects DBMS_ASH 29-Jan-2021
DBMS_ASH has FETCH_OBJ_NAME_AWR and 3 other objects removed DBMS_ASH 29-Jan-2021
DBMS_ASSERT has new SIMPLE_SQL_NAME_LIST function DBMS_ASSERT 07-Dec-2020
DBMS_AUDIT_MGMT_LSBY has 10 new objects DBMS_AUDIT_MGMT_LSBY 29-Jan-2021
DBMS_AUTOTASK_PRVT has new REQUEST_GRACE_PERIOD function DBMS_AUTOTASK_PRVT 29-Jan-2021
DBMS_AUTO_INDEX has new DROP_AUTO_INDEXES procedure DBMS_AUTO_INDEX 29-Jan-2021
DBMS_AUTO_INDEX_INTERNAL has 4 new objects DBMS_AUTO_INDEX_INTERNAL 11-Feb-2021
DBMS_AW dropped 3 ..._ACCESS_TRACKING objects DBMS_AW 12-Feb-2021
DBMS_AW_EXP has new LOB_WRITEAPPEND object with 2 overloads DBMS_AW_EXP 03-Dec-2021
DBMS_AW_INTERNAL has 4 new objects DBMS_AW_INTERNAL 12-Feb-2021
DBMS_BACKUP_RESTORE has 5 new objects DBMS_BACKUP_RESTORE 23-Feb-2021
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_CRYPTO has new PKDECRYPT, PKENCRYPT, SIGN and VERIFY objects DBMS_CRYPTO 18-Feb-2021
DBMS_CRYPTO_FFI has new PKDECRYPT, PKENCRYPT, SIGN and VERIFY objects DBMS_CRYPTO_FFI 18-Feb-2021
DBMS_CUBE has new IMPORT_XML_BLOB procedure DBMS_CUBE 19-Feb-2021
DBMS_CUBE_LOG has new TABLE_DROP and TABLE_TRUNCATE procedures DBMS_CUBE_LOG 19-Feb-2021
DBMS_DBFS_CONTENT has 5 new objects DBMS_DBFS_CONTENT 14-May-2021
DBMS_DBFS_HS dropped UNLOCKPATH procedure DBMS_DBFS_HS 14-May-2021
DBMS_DBFS_SFS has 25 new objects DBMS_DBFS_SFS 14-May-2021
DBMS_DBFS_SFS_ADMIN has new NEWIDAUX object DBMS_DBFS_SFS_ADMIN 14-May-2021
DBMS_DRS has 37 new objects DBMS_DRS 24-Feb-2021
DBMS_EDITIONS_UTILITIES has new ACTUALIZE_ALL procedure DBMS_EDITIONS_UTILITIES 24-Feb-2021
DBMS_FUSE has new FS_MKSOC function with 3 overloads DBMS_FUSE 28-Feb-2021
DBMS_GSM_FIX has 12 new objects DBMS_GSM_FIX 04-Mar-2021
DBMS_GSM_FIXED has 4 new objects DBMS_GSM_FIXED 04-Mar-2021
DBMS_GSM_POOLADMIN has 11 new objects DBMS_GSM_POOLADMIN 05-Mar-2021
DBMS_GSM_UTILITY has 8 new objects DBMS_GSM_UTILITY 05-Mar-2021
DBMS_GSM_SEC has new PUTCATUSER procedure DBMS_GSM_SEC 19-Jan-2021
DBMS_HADOOP_INTERNAL has new EVAL_PART_KEY_OPERATOR procedure DBMS_HADOOP_INTERNAL 07-Mar-2021
DBMS_HADOOP_INTERNAL dropped 3 objects DBMS_HADOOP_INTERNAL 07-Mar-2021
DBMS_HIERARCHY has 3 new objects DBMS_HIERARCHY 08-Mar-2021
DBMS_INDEX_UTL has new GET_REORG_INDEX_ACTION procedure DBMS_INDEX_UTL 09-Mar-2021
DBMS_INTERNAL_ROLLING has new IS_PLSQL_PRAGMA procedure DBMS_INTERNAL_ROLLING 10-Mar-2021
DBMS_IR has new UPDATEFEASABILITYANDIMPACT procedure DBMS_IR 11-Mar-2021
DBMS_ISCHED has new CREATE_CLOUD_CREDENTIAL and RESOLVE3_NAME objects DBMS_ISCHED 11-Mar-2021
DBMS_ISCHED dropped DEFINE_CHAIN_RULE and DEFINE_CHAIN_STEP objects DBMS_ISCHED 11-Mar-2021
DBMS_I_INDEX_UTL has new I_ANALYZE_INDEX and I_COMPUTE_ACTION objects DBMS_I_INDEX_UTL 13-Feb-2021
DBMS_JSON has new BLOB_TO_JSON, GATHER_STATS, and GET_VIEW_SQL objects DBMS_JSON 14-Mar-2021
DBMS_JSON0 has new CHECKPK and GETMAXVCSIZE objects DBMS_JSON0 14-Mar-2021
DBMS_JSON_INT has new BLOB2JSON procedure DBMS_JSON_INT 14-Mar-2021
DBMS_LOGMNR.INIT_REPLCATION_METADATA dropped DBMS_LOGMNR 14-Mar-2021
DBMS_LOB LOADFROMFILE and LOB new buffering support DBMS_LOB 22-Dec-2020
DBMS_MACADM has new ALLOW_COMMON_OPERATION procedure DBMS_MACADM 25-Dec-2021
DBMS_MACUTL has new GET_ACO_STATUS function DBMS_MACUTL 26-Dec-2021
DBMS_METADATA_UTIL has new IS_SHARD_TBL_IN_SHARD_CATALOG function DBMS_METADATA_UTIL 20-Mar-2021
DBMS_ODCI has UPGRADE_SECOBJ procedure removed DBMS_ODCI 24-Mar-2021
DBMS_PARALLEL_EXECUTE_INTERNAL has 4 new objects DBMS_PARALLEL_EXECUTE_INTERNAL 24-Mar-2021
DBMS_PLSQL_CODE_COVERAGE has new GET_BLOCK_MAP function DBMS_PLSQL_CODE_COVERAGE 22-Dec-2020
DBMS_PLUGTS has new KCP_SETPIRENA procedure DBMS_PLUGTS 28-Mar-2021
DBMS_PREUP dropped 20 objects from 19c and added 14 new objects DBMS_PREUP 29-Mar-2021
DBMS_RCVCAT has 26 new objects, drops ISTRANSLATEDPDBID, KTRANSLATEPDBNAME DBMS_RCVCAT 31-Mar-2021
DBMS_RCVMAN has 13 new objects DBMS_RCVMAN 31-Mar-2021
DBMS_RCVVPC has 8 new objects DBMS_RCVVPC 02-Apr-2021
DBMS_REDACT_INT dropped 3 "POLICY_DESCRIPTIONS" objects DBMS_REDACT_INT 30-Sep-2021
DBMS_REDEFINITION_INTERNAL has 9 new objects DBMS_REDEFINITION_INTERNAL 04-Apr-2021
DBMS_REGISTRY dropped 2 objects DBMS_REGISTRY 07-Apr-2021
DBMS_REGISTRY_SYS has 2 new objects DBMS_REGISTRY_SYS 18-Dec-2020
DBMS_RESULT_CACHE has 7 new objects DBMS_RESULT_CACHE 10-Apr-2021
DBMS_SMB_INTERNAL has new INIT_SMB_PARAMETER procedure DBMS_SMB_INTERNAL 21-Apr-2021
DBMS_SODA has 12 new objects DBMS_SODA 22-Apr-2021
DBMS_SODA_ADMIN has 11 new objects DBMS_SODA_ADMIN 08-Aug-2021
DBMS_SODA_DML has 3 new objects DBMS_SODA_DML 08-Aug-2021
DBMS_SODA_UTIL dropped CHECKANDGETCOMPAT and ISJDCS DBMS_SODA_UTIL 28-Aug-2021
DBMS_SODA_UTIL added GETSERVICENAME and LIST_USAGE_STATISTICS DBMS_SODA_UTIL 28-Aug-2021
DBMS_SPM_INTERNAL has 6 new objects and dropped LOAD_AUTO_EVOLVE_TASK_CONFIG DBMS_SPM_INTERNAL 22-Apr-2021
DBMS_SQADM_SYSCALLS has 2 new objects DBMS_SQADM_SYSCALLS 22-Apr-2021
DBMS_SQLCONTROL_INTERNAL renamed by prefix dropping all four previously existing objects DBMS_SQLCONTROL_INTERNAL 22-Apr-2021
DBMS_SQLCONTROL_INTERNAL added new GET_OBJECT_NAME procedure DBMS_SQLCONTROL_INTERNAL 22-Apr-2021
DBMS_SQLPATCH has new VERIFY_QUERYABLE_INVENTORY function DBMS_SQLPATCH 24-Apr-2021
DBMS_SQLQ_INTERNAL procedures renamed to drop I_ prefix and 4 objects dropped DBMS_SQLQ_INTERNAL 24-Apr-2021
DBMS_SQLQ_INTERNAL.CREATE_QUARANTINE_BY_TEXT renamed to _BY_SQLTEXT DBMS_SQLQ_INTERNAL 24-Apr-2021
DBMS_SQLTCB_INTERNAL has new FIXQ object DBMS_SQLTCB_INTERNAL 19-Mar-2021
DBMS_SQLTUNE has1 has 1 new object DBMS_SQLTUNE 27-Apr-2021
DBMS_SQLTUNE_UTIL0 has 1 new object DBMS_SQLTUNE_UTIL0 27-Apr-2021
DBMS_SQLTUNE_UTIL1 has 3 new objects DBMS_SQLTUNE_UTIL1 27-Apr-2021
DBMS_SQLTUNE_UTIL2 has 5 new objects DBMS_SQLTUNE_UTIL2 27-Apr-2021
DBMS_STATS_INTERNAL has 35 new objects DBMS_STATS_INTERNAL 01-May-2021
DBMS_SWRF_INTERNAL has 3 new objects DBMS_SWRF_INTERNAL 06-May-2021
DBMS_WORKLOAD_CAPTURE dropped GET_STATE function DBMS_WORKLOAD_CAPTURE 12-May-2021
DBMS_WORKLOAD_CAPTURE_I dropped GET_STATE and USER_CALLS_GRAPH DBMS_WORKLOAD_CAPTURE_I 12-May-2021
DBMS_WORKLOAD_REPLAY dropped GET_STATE adds new CONFIGURE DBMS_WORKLOAD_REPLAY 12-May-2021
DBMS_WORKLOAD_REPLAY_I dropped GET_STATE adds new CONFIGURE DBMS_WORKLOAD_REPLAY_I 12-May-2021
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_XPLAN has new COMPARE_CURSOR and COMPARE_EXPLAIN objects DBMS_XPLAN 24-May-2021
DBMS_XSTREAM_GG_ADM has new PURGE_TXN_CDR_INFO object DBMS_XSTREAM_GG_ADM 04-Jan-2021
DBMS_XSTREAM_GG_INTERNAL has new PURGE_TXN_CDR_INFO_INTERNAL object DBMS_XSTREAM_GG_INTERNAL 28-May-2021
DBMS_XS_SIDP has new DODHEXCHANGE2 and DODHEXCHANGE3 procedures DBMS_XS_SIDP 31-May-2021
DIANA has 15 new objects DIANA 12-Oct-2021
EXCHANGE has new DO_DDL_JOB procedure EXCHANGE 03-Jun-2021
HTF has 2 new objects HTF -
KBRSI_ICD has 4 objects removed and 19 new objects added KBRSI_ICD 17-Jan-2021
KUPF$FILE has 3 new objects KUPF$FILE 22-Jun-2022
KUPF$FILE_INT has 3 new objects KUPF$FILE_INT 08-Nov-2021
KUPP$PROC has 4 new objects KUPP$PROC 05-Jun-2021
KUPU$UTILITIES has 8 new objects and dropped WRITEAUDITRECORD KUPU$UTILITIES 28-Sep-2021
PRVTEMX_DBHOME has new REPORT_ASH_XML function PRVTEMX_DBHOME 20-Jun-2021
PRVTEMX_PERF has new ACTION_CANCEL_SQL_XML function PRVTEMX_DBHOME 20-Jun-2021
PRVT_AWR_VIEWER has 9 new objects PRVT_AWR_VIEWER 21-Jun-2021
PRVT_DBMS_INMEMORY_ADMIN has SPACE_USAGE2 and TRACE removed PRVT_DBMS_INMEMORY_ADMIN 09-Mar-2021
PRVT_DIMENSION_SYS_UTIL dropped the SET_DEBUG procedure PRVT_DIMENSION_SYS_UTIL 24-Jun-2021
PRVT_EMX has new OMX_LOCALES function PRVT_EMX 15-Mar-2021
STANDARD has 4 new objects STANDARD 30-Jun-2021
XS_ACL has new GRANT_PRIVILEGE and REVOKE_PRIVILEGE procedures XS_ACL 02-Jul-2021
 
Built-in Packages with New or Removed Overloads
CTX_DOC.TOKENS has one new overloads CTX_DOC 03-Dec-2021
DBMS_AQ.DEQUEUE and ENQUEUE have new overloads DBMS_AQ 08-Nov-2021
DBMS_CLOUD.CREATE_CREDENTIAL has a new overload DBMS_CLOUD 14-Dec-2020
DBMS_JSON.ADD_VIRTUAL_COLUMNS and GET_INDEX_DATAGUIDE have new overloads DBMS_JSON 14-Mar-2021
DBMS_XDB_REPOS.LOCK_RESOURCE has a new overload DBMS_XDB_REPOS 05-Nov-2022
 
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_GSM_POOLADMIN.ADD_SHARD has 5 new parameters DBMS_GSM_POOLADMIN 05-Mar-2021
DBMS_HIERARCHY.VALIDATE_ANALYTIC_VIEW has 2 new parameters DBMS_HIERARCHY 08-Mar-2021
DBMS_JSON objects add 13 new parameters DBMS_JSON 14-Mar-2021
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_ADVISOR has 32 new ZoneMap related constants DBMS_ADVISOR 06-Feb-2021
DBMS_AQADM has 4 new Retention Type constants DBMS_AQADM 06-Feb-2021
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_GSM_UTILITY has many new constants DBMS_GSM_UTILITY 05-Mar-2021
DBMS_INDEX_UTL has 6 constants for GET_REORG_INDEX_ACTION DBMS_INDEX_UTL 09-Mar-2021
DBMS_JSON objects has 11 new constants DBMS_JSON 14-Mar-2021
DBMS_LCR has 2 new OSON constants for JSON DBMS_LCR 18-Dec-2020
DBMS_PDB has 2 new FEATURE_ID constants DBMS_PDB 27-Mar-2021
DBMS_RCVCAT has new ECODE_UNKNOWN_INC constant DBMS_RCVCAT 31-Mar-2021
 
Related Topics
New in 11.2
New in 12.1
New in 12.2
New in 18c
New in 19c
New in 20c
New in 23c
  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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx