New In Oracle Database
Version 26ai

Description Link Last Modified
General
Contents of this page are based on a combination of Beta versions 23.1 through 23.3 and will all be updated to 23.4 as time permits.
 
Architecture
New Background Processes
  • BGnn
  • GCWn
  • SCMN
  • TMON
  • VOSD
Deprecated/Desupported/Dropped Background Processes
  • None
Background Processes 01-May-2023
New Objects
  • ANNOTATIONS
  • DOMAINS
Deprecated/Desupported/Dropped Objects
  • None
ANNOTATIONS
DOMAINS


 
30-Jul-2023
20-Jan-2024


 
Oracle Machine Learning (OML) - -
 
Security
Read Only Users USERS 01-May-2023
Schema Level Object Privileges Grants (these are a violation of the Principle of Least Privilege) Object Privileges 01-May-2023
Schema Level System Privilege Grants (these are a violation of the Principle of Least Privilege) System Privileges 01-May-2023
 
Basic
New Users
  • DGPDB_INT
  • GGSHAREDCAP
Deprecated/Desupported/Dropped Users as Part of Default Install
  • ORDDATA
  • ORDPLUGINS
  • ORDSYS
  • SI_INFORMATN_SCHEMA
USERS 01-May-2023
New Roles (25 new roles since 19c, the following list is new since 21c)
  • AVTUNE_PKG_ROLE
  • DB_DEVELOPER_ROLE
  • DGPDB_ROLE
  • GRAPH_ADMINISTRATOR
  • GRAPH_DEVELOPER
  • GRAPH_USER
  • GSMCATUSER_ROLE
  • NOTIFICATIONS_ADMIN
  • NOTIFICATIONS_USER
  • OGG_APPLY
  • OGG_APPLY_PROCREP
  • OGG_CAPTURE
  • OGG_SHARED_CAPTURE
  • OSAK_ADMIN_ROLE
  • PGX_SERVER_GET_INFO
  • PGX_SERVER_MANAGE
  • PGX_SESSION_ADD_PUBLISHED_GRAPH
  • PGX_SESSION_COMPILE_ALGORITHM
  • PGX_SESSION_CREATE
  • PGX_SESSION_GET_PUBLISHED_GRAPH
  • PGX_SESSION_MODIFY_MODEL
  • PGX_SESSION_NEW_GRAPH
  • PGX_SESSION_READ_MODEL
  • SAGA_ADM_ROLE
  • SAGA_CONNECT_ROLE
  • SAGA_CATALOG_USER
  • SHARDED_SCHEMA_OWNER
  • SQL_FIREWALL_ADMIN
  • SQL_FIREWALL_VIEWER
  • XSTREAMS_APPLY
  • XSTREAMS_CAPTURE
Deprecated/Desupported/Dropped Roles as Part of Default Install
  • DATAPATCH_ROLE
  • DV_PUBLIC
  • DV_REALM_OWNER
  • DV_REALM_RESOURCE
  • EM_EXPRESS_ALL
  • EM_EXPRESS_BASIC
  • MGW_ADMINISTRATOR_ROLE
  • MGW_AGENT_ROLE
  • ORACLE_JAVA_DEV
  • ORDADMIN
ROLES 04-Jun-2023
New System Privileges (25 new privileges since 19c, the following list is new since 21c)
  • ADMINISTER FINE GRAINED AUDIT POLICY
  • ADMINISTER REDACTION POLICY
  • ADMINISTER Row LEVEL SECURITY POLICY
  • ADMINISTER SQL FIREWALL
  • Alter ANY DOMAIN
  • Alter ANY MLE
  • Alter ANY PROPERTY GRAPH
  • CREATE ACTIVE DATA CACHE
  • CREATE ANY DOMAIN
  • CREATE ANY MLE
  • CREATE ANY PROPERTY GRAPH
  • CREATE DOMAIN
  • CREATE MLE
  • CREATE PROPERTY GRAPH
  • DROP ANY DOMAIN
  • DROP ANY MLE
  • DROP ANY PROPERTY GRAPH
  • EXECUTE ANY DOMAIN
  • GRANT ANY SCHEMA PRIVILEGE
  • READ ANY PROPERTY GRAPH
Deprecated/Desupported/Dropped System Privileges
  • MANAGE ANY FILE GROUP
  • MANAGE FILE GROUP
  • READ ANY FILE GROUP
SYSTEM PRIVILEGES 13-Feb-2024
New Dynamic Performance Views
  • GV$?
Deprecated/Desupported/Dropped Dynamic Performance Views
  • ?
Dynamic Performance Views -
New Object Privileges (3 new privileges since 19c, the following list is new since 21c)
  • 19: KEEP SEQUENCE
  • 32: SIGN
  • 33: COLLECT DEBUG INFO
Deprecated/Desupported/Dropped Object Privileges
  • None
OBJECT PRIVILEGES 01-May-2023
New Hints
  • TBD
- -
New Initialization Parameters (63 since 19c)
  • ACTIVE_DATA_CACHE
  • ACTIVE_LEGACY_RECO_PROTOCOL
  • ALLOW_WEAK_CRYPTO
  • AUTO_START_PDB_SERVICES
  • BLOCKCHAIN_TABLE_MAX_NO_DROP
  • CLIENT_PREFETCH_ROWS
  • CURRENT_TIME_AT_DBTIMEZONE
  • DB_FLASHBACK_LOG_DEST_SIZE
  • DRCP_CONNECTION_LIMIT
  • ENABLE_PER_PDB_DRCP
  • GROUP_BY_POSITION_ENABLED
  • HEARTBEAT_BATCH_SIZE
  • HI_SHARED_MEMORY_ADDRESS
  • HYBRID_READ_ONLY
  • INMEMORY_DEEP_VECTORIZATION
  • IPDDB__ENABLE
  • MAX_AUTH_SERVERS
  • MAX_SAGA_DURATION
  • MEMOPTIMIZE_WRITE_AREA_SIZE
  • MEMORY_MAX_SIZE
  • MIN_AUTH_SERVERS
  • OPTIMIZER_CAPTURE_SQL_QUARANTINE
  • OPTIMIZER_CROSS_SHARD_RESILIENCY
  • OPTIMIZER_REAL_TIME_STATISTICS
  • OPTIMIZER_USE_SQL_QUARANTINE
  • PDC_FILE_SIZE
  • PLSQL_IMPLICIT_CONVERSION_BOOL
  • READ_ONLY
  • RESULT_CACHE_EXECUTION_THRESHOLD
  • RESULT_CACHE_MAX_TEMP_SIZE
  • RESULT_CACHE_MAX_TEMP_RESULT
  • SESSION_EXIT_ON_PACKAGE_STATE_ERROR
  • SHARD_QUERIES_RESTRICTED_BY_KEY
  • SQL_HISTORY_ENABLED
  • SYSDATE_AT_DBTIMEZONE
  • TDE_KEY_CACHE
  • TIMEZONE_VERSION_UPGRADE_ONLINE
  • TXN_HIGH_PRIORITY_WAIT_TARGET
  • TXN_MEDIUM_PRIORITY_WAIT_TARGET
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
Deprecated/Dropped Initialization Parameters
  • CLUSTER_DATABASE_INSTANCES
  • CPU_COUNT
  • LOG_ARCHIVE_START
  • REMOTE_OS_AUTHENT
  • RESULT_CACHE_MAX_RESULTS
  • SEC_CASE_SENSITIVE_LOGON
  • UNIFIED_AUDIT_SYSTEMLOG
  • UNIFIED_AUDIT_QUEUE_SIZE
  • USE_DEDICATED_BROKER
Startup Parameters 14-Feb-2024
New Underscore Initialization Parameters
  • ?
Deprecated/Desupported/Dropped Underscore Initialization Parameters
  • _enable_numa_support ?
  • _px_numa_support_enabled ?
  • _restrict_pdb_gv
??? -
Annotations Support - 01-May-2023
Enhanced Exceptions providing more granular, and useful, messages - 01-May-2023
Table support for the BOOLEAN data type TABLES 01-May-2023
New Conversion Functions and Overloads Conversion Functions 05-June-2025
New Date Functions and Overloads Date Functions 04-June-2025
Time Bucket for the TIMEZONE data types Timestamp 04-June-2025
Vector Data Type and related functionality VECTOR Data Type 04-June-2025
 
Other Deprecated, Desupported or Dropped Objects
DBMS_FEATURE_EMX - 13-Jun-2023
DBMS_FEATURE_REGISTER_ALLFEAT - 13-Jun-2023
DBMS_FEATURE_REGISTER_ALLHWM - 13-Jun-2023
 
Object Types and Features
New
  • TBD
Deprecated, Desupported or Dropped
  • TBD
- -
 
New SQL
"FROM dual" no longer required in SQL queries SELECT 01-May-2023
GROUP BY now accepts column aliases GROUP BY 01-May-2023
DDL statements accept the logical argument IF [NOT] EXISTS DDL 01-May-2023
RETURNING clause support for MERGE statements MERGE 01-May-2023
RETURNING OLD clause supported with UPDATE statements UPDATE 01-May-2023
Tables with up to 4096 columns: If you need more than 200 sign up for "SQL Basics for Dummies" - 01-May-2023
Table Value Constructors allowed in single DML and SELECT statements providing ISO support DML 01-May-2023
UPDATE based on a join condition UPDATE 01-May-2023
 
PL/SQL Changes
JavaScript MLE MODULES bypassing direct calls to the DBMS_MLE built-in package Java Script 11-Aug-2025
 
New, Modified and Dropped Functions, Operators, Procedures and Types
DBMS_FEATURE_ADBDCAT DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_ADBXTTAB DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_CHARSET DBMS_FEATURE Procedures 25-Nov-2024
DBMS_FEATURE_DBC DBMS_FEATURE Procedures 25-Nov-2024
DBMS_FEATURE_EM_DIAG DBMS_FEATURE Procedures 17-May-2025
DBMS_FEATURE_EM_GC DBMS_FEATURE Procedures 17-May-2025
DBMS_FEATURE_EM_INT DBMS_FEATURE Procedures 17-May-2025
DBMS_FEATURE_EM_TUNING DBMS_FEATURE Procedures 17-May-2025
DBMS_FEATURE_JOB_CLOUDSQL DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_EMX Dropped DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_MLE DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_REGISTER_ALLFEAT Dropped DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_REGISTER_ALLHWM Dropped DBMS_FEATURE Procedures 13-Jun-2023
DBMS_FEATURE_SQL_FIREWALL DBMS_FEATURE Procedures 25-Nov-2024
DBMS_FEATURE_USER_DV DBMS_FEATURE Procedures 13-Jun-2023
STANDARD Package new SYS$STANDARD_TIME_BUCKET Function with 5 overloads STANDARD 03-Jun-2025
STANDARD CEIL Function Has 3 New Overloads STANDARD 03-Jun-2025
STANDARD Package new COSINE_DISTANCE Vector Funciton STANDARD 03-Jun-2025
FUZZY_MATCH Data Quality Operators 17-Jun-2024
PHONIC_ENCODE Data Quality Operators 17-Jun-2024
STANDARD CEIL Function Has 3 New Overloads STANDARD 03-Jun-2025
SYS_CONTEXT added new CDB_DOMAIN, CLOUD_SERVICE, and DRAIN_STATUS options DBMS_FEATURE Procedures 16-Jan-2024
SYS_CONTEXT dropped the EXTERNAL_NAME option DBMS_FEATURE Procedures 16-Jan-2024
 
Renamed Objects
TBD - -
 
Changes to JSON, SODA and XML
JSON Schema Definition validation JSON 01-May-2023
 
New Built-in Packages
DBMS_ADAT_REPORT DBMS_ADAT_REPORT 01-May-2023
DBMS_APPLICATION DBMS_APPLICATION 21-Jun-2023
DBMS_AQMIGTOOL DBMS_AQMIGTOOL 20-May-2025
DBMS_AQMIGTOOL_SYS DBMS_AQMIGTOOL_SYS 20-May-2025
DBMS_AUTOIM DBMS_AUTOIM 01-May-2023
DBMS_AUTOIM_INTERNAL DBMS_AUTOIM_INTERNAL 31-Aug-2025
DBMS_AUTO_CLUSTERING DBMS_AUTO_CLUSTERING 29-Aug-2025
DBMS_AUTO_CLUSTERING_INTERNAL DBMS_AUTO_CLUSTERING_INTERNAL 29-Aug-2025
DBMS_AWRAPP DBMS_AWRAPP 27-May-2024
DBMS_AWRAPP_ADMIN DBMS_AWRAPP_ADMIN 27-May-2024
DBMS_AWRHUB_AGENT DBMS_AWRHUB_AGENT 28-Aug-2025
DBMS_CHANGE_TABLE_ADM DBMS_CHANGE_TABLE_ADM 13-May-2025
DBMS_CLOUD_DBLINK DBMS_CLOUD_DBLINK 17-Dec-2023
DBMS_CLOUD_DBLINK_INTERNAL DBMS_CLOUD_DBLINK_INTERNAL 17-Dec-2023
DBMS_DATA_GUARD DBMS_DATA_GUARD 01-May-2023
DBMS_DATA_GUARD_INTERNAL DBMS_DATA_GUARD_INTERNAL 01-May-2023
DBMS_DEVELOPER DBMS_DEVELOPER 30-Aug-2025
DBMS_DGPDB DBMS_DGPDB 30-Aug-2025
DBMS_DICTIONARY_CHECK DBMS_DICTIONARY_CHECK 01-Sep-2025
DBMS_GSM_CURUSER DBMS_GSM_CURUSER 01-May-2023
DBMS_GSM_SHDUSR DBMS_GSM_SHDUSR 09-Jun-2023
DBMS_GSM_VPD DBMS_GSM_VPD 09-Jun-2023
DBMS_GVT DBMS_GVT 02-Sep-2025
DBMS_HASH DBMS_HASH 29-Jan-2024
DBMS_HYBRID_VECTOR DBMS_HYBRID_VECTOR 13-Jun-2025
DBMS_INMEMORY_ADVISE DBMS_INMEMORY_ADVISE 02-Sep-2025
DBMS_JSON_DUALITY DBMS_JSON_DUALITY 01-Oct-2025
DBMS_JSON_DUALITY_INT DBMS_JSON_DUALITY_INT 02-Oct-2025
DBMS_JSON_SCHEMA DBMS_JSON_SCHEMA 04-May-2023
DBMS_KAFKA DBMS_KAFKA 05-Sep-2025
DBMS_KAFKA_ADM DBMS_KAFKA_ADM 05-Sep-2025
DBMS_KAFKA_INT DBMS_KAFKA_INT 05-Sep-2025
DBMS_KAFKA_MD DBMS_KAFKA_MD 05-Sep-2025
DBMS_KAFKA_UTL DBMS_KAFKA_UTL 05-Sep-2025
DBMS_MANAGEMENT_DIAGNOSTICS DBMS_MANAGEMENT_DIAGNOSTICS 16-Jun-2024
DBMS_NOTIFICATIONS DBMS_NOTIFICATIONS 28-May-2023
DBMS_PART_INTERNAL DBMS_PART_INTERNAL 05-Jun-2023
DBMS_PART_INTERNAL DBMS_PART_INTERNAL 05-Jun-2023
DBMS_REDACTOR DBMS_REDACTOR 28-May-2023
DBMS_ROUTER_ADMIN DBMS_ROUTER_ADMIN 28-Sep-2025
DBMS_ROW_CHANGE_TRACKING DBMS_ROW_CHANGE_TRACKING 11-Sep-2025
DBMS_ROW_CHANGE_TRACKING_INT DBMS_ROW_CHANGE_TRACKING_INT 08-Sep-2025
DBMS_SAGA DBMS_SAGA 12-Sep-2025
DBMS_SAGA_ADM DBMS_SAGA_ADM 11-Sep-2025
DBMS_SAGA_ADM_SYS DBMS_SAGA_ADM_SYS 11-Sep-2025
DBMS_SAGA_CONNECT_INT DBMS_SAGA_CONNECT_INT 08-Sep-2025
DBMS_SAGA_SYS DBMS_SAGA_SYS 11-Sep-2025
DBMS_SEARCH DBMS_SEARCH 07-Oct-2024
DBMS_SEARCH_DEF DBMS_SEARCH_DEF 27-May-2024
DBMS_SENSITIVE_DATA DBMS_SENSITIVE_DATA 30-Jan-2024
DBMS_SHARDING_DIRECTORY DBMS_SHARDING_DIRECTORY 13-May-2025
DBMS_SHARED_CAPTURE_ADM DBMS_SHARED_CAPTURE_ADM 08-Jun-2023
DBMS_SHARED_CAPTURE_INTERNAL DBMS_SHARED_CAPTURE_INTERNAL 11-Sep-2025
DBMS_SHARED_CAPTURE_IVK DBMS_SHARED_CAPTURE_IVK 08-Jun-2023
DBMS_SQLHIST DBMS_SQLHIST 30-Jan-2024
DBMS_SQLHIST_INTERNAL DBMS_SQLHIST_INTERNAL 30-Jan-2024
DBMS_SQL_FIREWALL DBMS_SQL_FIREWALL 08-Sep-2025
DBMS_SWAT_XML DBMS_SWAT_XML 15-Aug-2025
DBMS_TABLE_FUNC DBMS_TABLE_FUNC 30-Jan-2024
DBMS_TABLE_FUNC_ADMIN DBMS_TABLE_FUNC_ADMIN 14-Jun-2024
DBMS_UPG_JSON DBMS_UPG_JSON 01-Aug-2025
DBMS_UPG_JSON0 DBMS_UPG_JSON0 01-Aug-2025
DBMS_UPG_JSON_INT DBMS_UPG_JSON_INT 01-Aug-2025
DBMS_USERDIAG DBMS_USERDIAG 01-Aug-2025
DBMS_VECTOR DBMS_VECTOR 11-Aug-2025
DBMS_VECTOR_CHAIN DBMS_VECTOR_CHAIN 24-Aug-2025
DBMS_VECTOR_INTERNAL DBMS_VECTOR_INTERNAL 31-Jul-2025
KU$_DPAPPLY KU$_DPAPPLY 20-Oct-2024
KUBSBD$ICEBERG KUBSBD$ICEBERG 10-Jun-2024
LBAC_ERROR LBAC_ERROR 11-Jun-2024
LTDEFINER LTDEFINER 10-May-2025
PRVT_DBMS_INMEMORY_ADVISOR PRVT_DBMS_INMEMORY_ADVISOR 30-Jan-2024
PRVT_ILM_INVOKERS_RIGHTS PRVT_ILM_INVOKERS_RIGHTS 07-Jun-2023
PRVT_ORACHAIN PRVT_ORACHAIN 20-May-2025
PRVT_UTILITY PRVT_UTILITY 02-May-2023
TSDP_ERROR_HANDLE TSDP_ERROR_HANDLE 30-Jan-2024
 
Removed Built-in Packages
AWRINFO_UTIL - 16-May-2025
BSLN - 09-Jun-2023
CARTRIDGE - 09-Jun-2023
CTX_TREE - 09-Jun-2023
DBMS_CLR - 24-Nov-2024
DBMS_EDITIONS_UTILITIES2 - 10-Jun-2023
DBMS_FILE_GROUP - 29-Jan-2024
DBMS_FILE_GROUP_DECL - 29-Jan-2024
DBMS_FILE_GROUP_EXP - 29-Jan-2024
DBMS_FILE_GROUP_EXP_INTERNAL - 29-Jan-2024
DBMS_FILE_GROUP_IMP_INTERNAL - 29-Jan-2024
DBMS_FILE_GROUP_INTERNAL_INVOK - 29-Jan-2024
DBMS_FILE_GROUP_UTL - 29-Jan-2024
DBMS_FILE_GROUP_UTL_INVOK - 29-Jan-2024
DBMS_HS_PARALLEL - 15-Jun-2023
DBMS_HS_PARALLEL_METADATA - 15-Jun-2023
DBMS_IR - 19-Aug-2024
DBMS_JAVASCRIPT - 29-Jan-2024
DBMS_PREUP (check $ORACLE_HOME/rdbms/admin/catupstr_checks.sql) - 26-Jun-2023
DBMS_WRR_STATE_BASE present in 20c, dropped from 23ai - 01-May-2023
IM - 09-Jun-2023
MGMT_CONFIG - 09-Jun-2023
MGMT_CONFIG_UTL - 09-Jun-2023
MGMT_DB_LL_METRICS - 09-Jun-2023
MGMT_RESPONSE - 09-Jun-2023
OLS_DIP_NTFY - 08-Aug-2023
ORDAUDIOEXCEPTIONS - 09-Jun-2023
ORDAUDIO_PKG - 09-Jun-2023
ORDDOCEXCEPTIONS - 09-Jun-2023
ORDDOC_PKG - 09-Jun-2023
ORDERROR - 09-Jun-2023
ORDERRORINT - 09-Jun-2023
ORDEXCEPTIONS - 09-Jun-2023
ORDIMAGECONSTANTS - 09-Jun-2023
ORDIMAGESICONSTANTS - 09-Jun-2023
ORDDIMERRORCODES - 09-Jun-2023
ORDDIM_PKG - 09-Jun-2023
ORDDIMGEXTCODEC_PKG - 09-Jun-2023
ORDPLSGWYUTIL - 09-Jun-2023
ORDSOURCEEXCEPTIONS - 09-Jun-2023
ORDUTIL - 09-Jun-2023
ORDUTIL_PRV - 09-Jun-2023
ORDVIDEOEXCEPTIONS - 09-Jun-2023
ORDVIDEO_PKG - 09-Jun-2023
ORDX_DEFAULT_AUDIO - 09-Jun-2023
ORDX_DEFAULT_DOC - 09-Jun-2023
ORDX_DEFAULT_VIDEO - 09-Jun-2023
ORDX_FILE_SOURCE - 09-Jun-2023
ORDX_HTTP_SOURCE - 09-Jun-2023
ORD_AUDIO - 09-Jun-2023
ORD_DATASOURCE_PKG - 09-Jun-2023
ORD_DICOM - 09-Jun-2023
ORD_DICOM_ADMIN - 09-Jun-2023
ORD_DOC - 09-Jun-2023
ORD_IMAGE - 09-Jun-2023
ORD_VIDEO - 09-Jun-2023
PRVT_DBMS_MANAGE_XMLSTORAGE - 28-Jan-2024
REDO_DIFF - 09-Jun-2023
TKHCS_LOG_PKG - 09-Jun-2023
UTL_RECOMP2 - 10-Jun-2023
 
Built-in Packages with New Subprograms
CTX_DDL has 6 new subprograms CTX_DDL 07-Oct-2025
CTX_DOC has new POLICY_TOKENS_ONLY subprogram CTX_DOC 08-Oct-2025
CTX_QUERY has new WARM_CACHE procedure CTX_QUERY 11-May-2025
CTX_REPORT has 2 new INDEX_HEALTH_STATISTICS and SHOW_TOKENS subprograms CTX_REPORT 08-Oct-2025
DBMS_ADBTASKADMN has 4 new subobjects DBMS_ADBTASK_ADMIN 19-May-2025
DBMS_ADDM has 8 new subprograms DBMS_ADDM 25-May-2025
DBMS_ADVISOR has new CHECK_DBA_GRANTED function DBMS_ADVISOR 03-Nov-2024
DBMS_APP_CONT has 3 new subprograms DBMS_APP_CONT 17-May-2025
DBMS_APP_CONT_ADMIN has 13 new subprograms DBMS_APP_CONT_ADMIN 25-May-2025
DBMS_AQ has 12 new subprograms DBMS_AQ 18-Aug-2025
DBMS_AQADM has 12 new subprograms DBMS_AQADM 18-Aug-2025
DBMS_AQADM_SYS has 32 new subprograms DBMS_AQADM_SYS 03-Nov-2024
DBMS_AQADM_SYSCALLS has 10 new subprograms DBMS_AQADM_SYSCALLS 20-Jul-2025
DBMS_AQJMS has 3 new subprograms DBMS_AQJMS 14-Oct-2024
DBMS_ASH has 4 new subprograms DBMS_ASH 05-Dec-2024
DBMS_AUTO_INDEX has new RECOMMEND_function DBMS_AUTO_INDEX 11-Aug-2025
DBMS_AUTO_INDEX_INTERNAL has new RECOMMEND_AND_VERIFY function DBMS_AUTO_INDEX_INTERNAL 01-Dec-2024
DBMS_AUDIT_MGMT_LSBY has 3 new subprograms DBMS_AUDIT_MGMT_LSBY 20-May-2025
DBMS_AUTOTASK_PRVT has 5 new subprograms DBMS_AUTOTASK_PRVT 11-Aug-2025
DBMS_AUTO_REPORT has 4 new subprograms DBMS_AUTO_REPORT 30-Mar-2024
DBMS_AUTO_TASK has 2 new asynchronous operation functions DBMS_AUTO_TASK 21-Aug-2025
DBMS_AUTO_TASK_ADMIN has 4 new procedures DBMS_AUTO_TASK_ADMIN 21-Aug-2025
DBMS_AVTUNE has new 5 new subprograms DBMS_AVTUNE 28-Aug-2025
DBMS_AVTUNE has new 10 new subprograms DBMS_AVTUNE_UTIL 28-Aug-2025
DBMS_AWRHUB has 6 new subprograms DBMS_AWRHUB 28-Aug-2025
DBMS_AWRHUB_SERVER has 3 new subprograms DBMS_AWRHUB_SERVER 28-Aug-2025
DBMS_AWRHUB_SOURCE has 2 new subprograms DBMS_AWRHUB_SOURCE 28-Aug-2025
DBMS_AWR_ANALYTICS has 3 new subprograms DBMS_AWR_ANALYTICS 28-May-2023
DBMS_AWR_WAREHOUSE_SERVER has 2 new CLEANUP_ORPHAN procedures DBMS_AWR_WAREHOUSE_SERVER 28-Aug-2025
DBMS_AWR_WAREHOUSE_SOURCE has new MODIFY_PACKAGING_METHOD procedure DBMS_AWR_WAREHOUSE_SOURCE 28-Aug-2025
DBMS_BACKUP_RESTORE added 11 new subprograms DBMS_BACKUP_RESTORE 07-Dec-2024
DBMS_BLOCKCHAIN_TABLE has 14 new subprograms DBMS_BLOCKCHAIN_TABLE 25-Aug-2025
DBMS_CAPTURE_ADM_INTERNAL has new IS_NEW_CAP_INSTANCE_ALLOWED function DBMS_CAPTURE_ADM_INTERNAL 29-Aug-2025
DBMS_CLOUD has 3 new subprograms DBMS_CLOUD 17-Dec-2023
DBMS_CLOUD_ADMIN_INTERNAL has 2 new subprograms DBMS_CLOUD_ADMIN_INTERNAL 17-Dec-2023
DBMS_CLOUD_CORE has new GET_DB_VERSION procedure DBMS_CLOUD_CORE 17-Dec-2023
DBMS_CLOUD_REQUEST has new REFRESH_RESOURCE_PRINCIPAL procedure DBMS_CLOUD_REQUEST 17-Dec-2023
DBMS_CONNECTION_POOL has new ADD_POOL and REMOVE_POOL procedures DBMS_CONNECTION_POOL 26-Feb-2024
DBMS_CRYPTO has 6 new procedures DBMS_CRYPTO 26-Aug-2024
DBMS_CRYPTO_FFI has 6 new procedures DBMS_CRYPTO_FFI 29-Aug-2025
DBMS_CSX_INT has 4 new subprograms DBMS_CSX_INT 08-Jul-2024
DBMS_CUBE_PRVTEXP has new CLOB2FILE and GETCONTENTCLOB subprograms DBMS_CUBE_PRVTEXP 29-Aug-2025
DBMS_DATA_MINING has new IMPORT_ONNX_MODEL procedure DBMS_DATA_MINING 30-Nov-2024
DBMS_DBFS_CONTENT_ADMIN has 2 new subprograms DBMS_DBFS_CONTENT_ADMIN 04-Aug-2024
DBMS_DBFS_HS has new unlockpath procedure DBMS_DBFS_HS 25-Nov-2024
DBMS_DBFS_SFS_ADMIN has new TBSUSAGEDBA procedure DBMS_DBFS_SFS_ADMIN 14-Oct-2024
DBMS_DESCRIBE has new DATA_TYPE_TO_ID function DBMS_DESCRIBE 21-Apr-2024
DBMS_DG has 42 new subprograms DBMS_DG 30-Aug-2025
DBMS_DLM has 4 new subprograms DBMS_DLM 02-Sep-2025
DBMS_DRS has 11 new subprograms DBMS_DRS 27-Aug-2025
DBMS_DST has 3 new subprograms DBMS_DST 08-Aug-2024
DBMS_DUMA_INTERNAL has 4 new subprograms DBMS_DUMA_INTERNAL 17-Jun-2024
DBMS_FEATURE_USAGE has new REGISTER_ALL_FEATURES procedure DBMS_FEATURE_USAGE 27-Mar-2024
DBMS_FLASHBACK_ARCHVE has 3 new subprograms DBMS_FLASHBACK_ARCHIVE 16-Jul-2024
DBMS_FS has new FS_EXISTS and LIST_FILES functions DBMS_FS 25-Sep-2023
DBMS_GOLDENGATE_ADM has 4 new subprograms DBMS_GOLDENGATE_ADM 02-Sep-2025
DBMS_GSM_CLOUDADMIN has new VALIDATEVNCR procedure DBMS_GSM_CLOUDADMIN 14-Oct-2024
DBMS_GSM_COMMON has 23 new subprograms DBMS_GSM_COMMON 14-May-2025
DBMS_GSM_DBADMIN has 142 new subprograms DBMS_GSM_DBADMIN 28-May-2025
DBMS_GSM_FIX has 8 new subprograms DBMS_GSM_FIX 16-Aug-2025
DBMS_GSM_FIXED has 21 new subprograms DBMS_GSM_FIXED 16-Aug-2025
DBMS_GSM_POOLADMIN has 28 new subprograms DBMS_GSM_POOLADMIN 13-May-2025
DBMS_GSM_SEC has 8 new subprograms DBMS_GSM_SEC 28-May-2023
DBMS_GSM_UTILITY has 30 new subprograms DBMS_GSM_UTILITY 01-Dec-2024
DBMS_HADOOP_INTERNAL has 4 new subprograms DBMS_HADOOP_INTERNAL 05-Oct-2025
DBMS_HCS_LOG has new SET_LOGGING_LEVEL procedure DBMS_HCS_LOG 12-May-2024
DBMS_HEAT_MAP_INTERNAL dropped BLOCK_HEAT_MAP procedure DBMS_HEAT_MAP_INTERNAL 22-Apr-2024
DBMS_HEAT_MAP_INTERNAL has 3 new subprograms DBMS_HEAT_MAP_INTERNAL 22-Apr-2024
DBMS_HIERARCHY has new the GET_MV_SQL_FOR_AV_CACHE overload DBMS_HIERARCHY 14-Sep-2025
DBMS_ILN_ADMIN has 6 new subprograms DBMS_ILM_ADMIN 04-Sep-2025
DBMS_IMMUTABLE_TABLE has new ADD_INTERVAL_PARTITIONING procedure DBMS_IMMUTABLE_TABLE 01-May-2023
DBMS_INMEMORY has new POPULATE_GRAPH and REPOPULATE_GRAPH procedures DBMS_INMEMORY 07-Oct-2023
DBMS_INMEMORY_ADMIN has new SET_SGA_PERCENTAGE procedures DBMS_INMEMORY_ADMIN 14-Sep-2025
DBMS_IRERESH has new COMPUTE_REFRESH_JOBCLAS procedure DBMS_IREFRESH 11-Sep-2025
DBMS_ISCHED has 4 new subprograms DBMS_ISCHED 15-May-2025
DBMS_JAVA has 56 new subprograms DBMS_JAVA 26-Sep-2025
DBMS_JMS_PLSQL has new GET_ERROR_TEXT function DBMS_JMS_PLSQL 03-Oct-2024
DBMS_JSON has 5 new subprograms DBMS_JSON 20-Aug-2024
DBMS_JSON0 has 12 new subprograms DBMS_JSON0 02-Oct-2025
DBMS_JSON_INT has 3 new subprograms DBMS_JSON_INT 11-May-2025
DBMS_JSON_INT dropped the GENDATAGUIDE procedure DBMS_JSON_INT 11-May-2025
DBMS_LOB has new GET_LOB_COMPR_RATIO & GET_LOB_DEDUPLICATION_RATIO functions DBMS_LOB 10-Nov-2024
DBMS_LOGMNR_INTERNAL has 7 new subprograms DBMS_LOGMNR_INTERNAL 27-Sep-2025
DBMS_LOGMNR_SESSION_INT has 5 new subprograms DBMS_LOGMNR_SESSION_INT 07-Oct-2025
DBMS_LOGREP_UTIL has 60 new subprograms DBMS_LOGREP_UTIL 08-Sep-2025
DBMS_MACADM has 9 new subprograms DBMS_MACADM 11-May-2025
DBMS_MACUTL has 3 new subprogram DBMS_MACUTL 11-May-2025
DBMS_MANAGEMENT_BOOTSTRAP has new RECREATE_AWR_PARTITIONS procedure DBMS_MANAGEMENT_BOOTSTRAP 11-May-2025
DBMS_METADATA has 5 new subprograms DBMS_METADATA 23-Aug-2025
DBMS_METADATA_BUILD has new HAS_FILTER function DBMS_METADATA_BUILD 01-Apr-2024
DBMS_METADATA_UTIL has 3 new subprograms DBMS_METADATA_UTIL 14-Aug-2025
DBMS_MLE has 10 new subprograms DBMS_MLE 11-Aug-2025
DBMS_NETWORK_ACL_ADMIN has new GET_HOST_ACLFLAG function DBMS_NETWORK_ACL_ADMIN 20-Aug-2024
DBMS_OPTIM_BUNDLE has new SET_FIX_CONTROLS procedure DBMS_OPTIM_BUNDLE 05-May-2024
DBMS_PDB has new ADD_MISSING_LIFESPAN and IS_CLOUD_PDB subprograms DBMS_PDB 14-Aug-2025
DBMS_PIPE has 4 new subprograms DBMS_PIPE 08-Sep-2025
DBMS_PLUGTS has new GETREMAPSCHEMA and KCP_CLRPIRENA procedures DBMS_PLUGTS 04-Oct-2025
DBMS_PQDIAG has new qqcslv_info_prejoin and qqcslv_info_postjoin functions DBMS_PQDIAG 13-Oct-2025
DBMS_PRIV_CAPTURE new SES_HAS_SCH_PRIV procedure with 2 overloads DBMS_PRIV_CAPTURE 08-Sep-2025
DBMS_PROFILER has new create_tables procedure DBMS_PROFILER 27-Oct-2024
DBMS_PSWMG_IMPORT has new IMPORT_HISTORY_INSERT procedure DBMS_PSWMG_IMPORT 05-Sep-2025
DBMS_PRVTAQIM has new CREATE_BASE_VIEW_12C_21 procedure DBMS_PRVTAQIM 07-Sep-2024
DBMS_PRVTAQIP has 5 new subprograms DBMS_PRVTAQIP 23-Aug-2025
DBMS_PRVTAQIS has new CHECK_RULE function DBMS_PRVTAQIS 27-Oct-2024
DBMS_RCVCAT has 19 new subprograms DBMS_RCVCAT 13-Oct-2025
DBMS_RCVMAN has 14 new subprograms DBMS_RCVMAN 14-Oct-2025
DBMS_RCVVPC removed the G_RAREP_USER function added in 21c DBMS_RCVVPC 14-Oct-2025
DBMS_REDEFINITION_INTERNAL has new TAB_IN_BITMAP function DBMS_REDEFINITION_INTERNAL 14-Aug-2025
DBMS_REPLAYHUB has 3 new subprograms DBMS_REPLAYHUB 01-Mar-2024
DBMS_REPORT has 7 new subprograms DBMS_REPORT 04-Oct-2025
DBMS_RESULT_CACHE has 15 new subprograms DBMS_RESULT_CACHE 05-Oct-2025
DBMS_RMIN_SYS has 2 new subprograms DBMS_RMIN_SYS 05-Oct-2025
DBMS_RULE has new ANALYZE_EXPRESSION procedure DBMS_RULE 07-Oct-2025
DBMS_RULE_ADM has new GRANT_ and REVOKE_ SCHEMA_PRIVILEGE procedures DBMS_RULE_ADM 06-Sep-2024
DBMS_SERVICE has new CREATE_ and DELETE_CHILD_SERVICE procedures DBMS_SERVICE 26-Aug-2024
DBMS_SCHEDULER has 4 new subprograms DBMS_SCHEDULER 25-Aug-2025
DBMS_SERVICE_PRVT has 5 new subprograms DBMS_SERVICE_PRVT 14-Aug-2024
DBMS_SESSION has new CLEAR_ALL_LOCAL_CONTEXTS procedure DBMS_SESSION 07-Oct-2024
DBMS_SHARED_POOL has new PURGE_ROW_CACHE subprogram DBMS_SHARED_POOL 12-Jun-2024
DBMS_SMB_INTERNAL has new INIT_SMB_PARAMETER_FUN function DBMS_SMB_INTERNAL 07-Oct-2025
DBMS_SNAP_INTERNAL has new SYNC_UP_LPT procedure DBMS_SNAP_INTERNAL 07-Oct-2024
DBMS_SODA has 4 new subprograms DBMS_SODA 08-Jul-2024
DBMS_SODA_ADMIN has 16 new subprograms DBMS_SODA_ADMIN 12-May-2025
DBMS_SODA_DML has new DO_UPDATE_DESCRIPTOR subprogram DBMS_SODA_DML 27-Mar-2024
DBMS_SODA_USER_DML has new CREATE_USER_INNER procedure DBMS_SODA_USER_DML 01-Apr-2024
DBMS_SODA_UTIL has 7 new subprograms DBMS_SODA_UTIL 07-Oct-2025
DBMS_SPACE has 5 new subprograms DBMS_SPACE 01-Sep-2025
DBMS_SPACE_ADMIN has 2 new subprograms DBMS_SPACE_ADMIN 01-Sep-2025
DBMS_SPM has new ADD_VERIFIED_SQL_PLAN_BASELINE function DBMS_SPM 04-Sep-2024
DBMS_SPM_INTERNAL has 6 new subprograms DBMS_SPM_INTERNAL 04-Oct-2025
DBMS_SQLCONTROL_INTERNAL dropped EXISTS_OBJECT added OBJECT_EXISTS DBMS_SQLCONTROL_INTERNAL 01-Dec-2023
DBMS_SQLDIAG has new REPORT_SQL subprogram DBMS_SQLDIAG 05-Oct-2025
DBMS_SQLDIAG_INTERNAL has 16 new subprograms DBMS_SQLDIAG_INTERNAL 14-Aug-2024
DBMS_SQLSET has new DROP_SQLSET_BY_PREFIX procedure DBMS_SQLSET 08-Jun-2023
DBMS_SQLTCB_INTERNAL has new I_GET_SQL subprogram DBMS_SQLTCB_INTERNAL 07-Oct-2025
DBMS_SQLTUNE has new DROP_SQLSET_BY_PREFIX and UPDATE_SQLSET_EMS subprograms DBMS_SQLTUNE 05-Oct-2025
DBMS_SQLTUNE_INTERNAL has 7 new subprograms DBMS_SQLTUNE_INTERNAL 05-Oct-2025
DBMS_SQLTUNE_UTIL0 has new IS_NON_CDB function DBMS_SQLTUNE_UTIL0 04-Aug-2024
DBMS_SQLTUNE_UTIL2 has new USER_ID_TO_NAME function DBMS_SQLTUNE_UTIL2 11-Aug-2024
DBMS_STATS has 6 new subprograms DBMS_STATS 10-Sep-2025
DBMS_STATS_INTERNAL has 29 new subprograms DBMS_STATS_INTERNAL 12-Sep-2025
DBMS_STREAMS has 5 new functions DBMS_STREAMS 08-Sep-2025
DBMS_STREAMS_ADM_IVK has new VERIFY_AND_GET_SUBSET_RULES functions DBMS_STREAMS_ADM_IVK 28-Sep-2025
DBMS_STREAM_TBS_INT has new GENERATE_NAME function DBMS_STREAMS_TBS_INT 08-Aug-2024
DBMS_SWAT_INTERNAL has 6 new subprograms DBMS_SWAT_INTERNAL 14-Aug-2025
DBMS_SWAT_MM_INTERNAL has 14 new subprograms DBMS_SWAT_MM_INTERNAL 01-Dec-2024
DBMS_SWAT_MM_UTILS has 6 new subprograms DBMS_SWAT_MM_UTILS 14-Aug-2024
DBMS_SWAT_VER_INTERNAL has new RECOMMEND_AND_VERIFY subprogram DBMS_SWAT_VER_INTERNAL 15-Aug-2025
DBMS_SWRF_INTERNAL has 20 new subprograms DBMS_SWRF_INTERNAL 12-Sep-2025
DBMS_SWRF_REPORT_INTERNAL has 11 new subprograms DBMS_SWRF_REPORT_INTERNAL 01-Oct-2025
DBMS_SYSTEM has 11 new subprograms DBMS_SYSTEM 05-Aug-2025
DBMS_SYS_MLE has 11 new subprograms DBMS_SYS_MLE 11-Aug-2025
DBMS_TEQK has 6 new subprograms DBMS_TEQK 04-Aug-2025
DBMS_TRANSACION has 5 new subprograms DBMS_TRANSACTION 15-Sep-2025
DBMS_USER_CERTS has new ADD and DROP _CERTIFICATE_REPL procs DBMS_USER_CERTS 06-Jun-2023
DBMS_WORKLOAD_REPOSITORY has 14 new subprograms DBMS_WORKLOAD_REPOSITORY 15-Aug-2025
DBMS_WORKLOAD_REPOSITORY_DEF DBMS_WORKLOAD_REPOSITORY_DEF 30-Jul-2025
DBMS_WRR_INTERNAL has 48 new subprograms DBMS_WRR_INTERNAL 11-Aug-2025
DBMS_UTILITY has new GET_COLUMN_LIMIT function DBMS_UTILITY 14-Sep-2025
DBMS_XSTREAM_ADM has 24 new subprograms DBMS_XSTREAM_ADM 01-Dec-2024
DBMS_XSTREAM_ADM_INTERNAL dropped ADD and UPDATE GOLDENGATE_PRIVILEGE DBMS_XSTREAM_ADM_INTERNAL 14-Apr-2024
DBMS_XSTREAM_ADM_UTL has new IS_ROOT_WITH_DGPDB function DBMS_XSTREAM_ADM_UTL 11-Aug-2025
DBMS_XSTREAM_AUTH_IVK dropped all 3 GRANT_ADMIN procedures DBMS_XSTREAM_AUTH_IVK 29-Apr-2024
DBMS_XSTREAM_GG has 3 new procedures and 1 new function DBMS_XSTREAM_GG 04-Aug-2024
DBMS_XSTREAM_GG_ADM has 2 new subprograms DBMS_XSTREAM_GG_ADM 28-Jul-2025
DBMS_XSTREAM_GG_INTERNAL has 9 new subprograms DBMS_XSTREAM_GG_INTERNAL 28-Jul-2024
DIANA has 10 new subprograms DIANA 25-Dec-2025
DMP_SYS has new UPDATE_VIEWS procedure DMP_SYS 30-Mar-2024
DRIACC added CHK_ACCESS and DEL_CACHE subprograms DRIACC 16-Jun-2025
GENDATAPROVIDERINTERFACE has new CLOSE subrogram GENDATAPROVIDERINTERFACE 27-Mar-2024
HTMLDB_UTIL has 23 new subprograms HTMLDB_UTIL 14-Apr-2024
JAVAVM_SYS has the procedure JPM_ROOT_ENABLED added JAVAVM_SYS 18-Apr-2024
JVMRJBCINV has the function SET_MODULE_NAME added JVMRJBCINV 18-Apr-2024
KUPD$DATA_INT has new SET_DEBUG procedure KUPD$DATA_INT 28-Jul-2025
KUPF$FILE has 4 new subprograms KUPF$FILE 26-Jul-2025
KUPF$FILE_INT has 4 new subprograms KUPF$FILE_INT 01-Sep-2024
KUPP$PROC has 4 new subprograms KUPP$PROC 26-Jul-2025
KUPU$UTILITIES_INT has 6 new subprograms KUPU$UTILITIES_INT 11-Aug-2024
KUPV$FT_INT has new TRACE subprogram with 2 overloads KUPV$FT_INT 23-Jul-2025
KU$_DPLOAD removed all previously existing subprograms and added 6 new subprograms KU$_DPLOAD 01-Apr-2024
KU$_DPLOCK has new GET_DB_VERSION function KU$_DPLOCK 07-Aug-2023
LBAC_CACHE dropped 6 subprograms LBAC_CACHE 18-Aug-2024
LT has a new subprograms GRANTPRIVSFORADMIN subprogram LT 10-May-2025
LOGMNR_DICT_CACHE has 9 new subprograms LOGMNR_DICT_CACHE 23-Jul-2025
LTDEFINER has 31 new subprograms LTDEFINER 10-May-2025
LTUTIL has 2 new BUMPTYUPPER and RECOMPUTEALLVTROWIDS LTUTIL 24-Aug-2025
OPG_APIS has 2 new subprograms OPG_APIS 20-Jul-2025
OPG_GRAPHOP has new POPULATE_DISTINCT_VERTEX_TAB procedure OPG_GRAPHOP 16-Feb-2024
OWM_ASSERT_PKG has new VERIFYOVMSQL procedure OWM_ASSERT_PKG 27-Mar-2024
OWM_DYNSQL_ACCESS has 4 new subprograms OWM_DYNSQL_ACCESS 24-Aug-2025
OWM_MIG_PKG has new GRANT_SELECT procedure OWM_MIG_PKG 08-May-2024
PRIVATE_JDBC has new GET_MAX_STRING_SIZE function PRIVATE_JDBC 20-Aug-2023
PRIVATE_JDBC_DR has new GET_MAX_STRING_SIZE function PRIVATE_JDBC_DR 01-Aug-2023
PRVT_ASH_OMX has new FIND_ASH_TIMEZONE function PRVT_ASH_OMX 18-Jul-2025
PRVT_COMPRESS added 5 new subprograms PRVT_COMPRESS 27-Jan-2024
PRVT_COMPRESSION has 2 new procedures PRVT_COMPRESSION 04-Aug-2024
PRVT_EMX has new REGISTER_EMXONLY_REPORTS and REGISTER_UI and subprograms PRVT_EMX 17-Jul-2025
PRVT_HDM has 18 new subprograms PRVT_HDM 17-Jul-2025
PRVT_ILM has new AUTO_OPTIMIZE_FEATURE_TRACKING subprogram PRVT_ILM 15-Jul-2025
SDO_RDF_SYS has new PRIVS_FOR_OLS_LBACSYS procedure SDO_RDF_SYS 04-Aug-2023
SEM_RDFCTX_DR has 12 new subprograms SEM_RDFCTX_DR 08-Dec-2024
STANDARD has dozens of new function and new overloads STANDARD 15-Jul-2025
UTL_HTTP has new 2 new subprograms UTL_HTTP 28-May-2025
UTL_I18N has new 3 new subprograms, each with 4 overloads and new data types and constants UTL_I18N 26-May-2025
UTL_RECOMP has new 3 new subprograms relocated from UTL_RECOMP2 in 21c UTL_RECOMP 10-Jun-2023
UTL_SMTP has new SET_CREDENTIAL object with 2 overloads UTL_SMTP 04-Sep-2024
 
Built-in Packages with Removed Subprograms
DBMS_AQ has 2 removed subprogram DBMS_AQ 18-Aug-2025
DBMS_AW.EVAL_NUMBER function removed DBMS_AW 23-Aug-2025
BSLN_INTERNAL dropped 27 subprograms BSLN_INTERNAL 11-Aug-2024
CTX_ADM has removed the SHUTDOWN, STOP_OPTIMIZE and TEST_EXTPROC procedures CTX_ADM 26-Feb-2024
CTX_DDL has 6 subprograms removed CTX_DDL 01-Dec-2024
CTX_QUERY.STORE_CTXIN_CURSOR procedure removed CTX_QUERY 11-May-2025
CTX_REPORT.VALIDATE_MVDATA function removed CTX_REPORT 08-Oct-2025
DBMS_ADDM removed the FAILED_AUTO_TASKS_REPORT subprogram DBMS_ADDM 25-May-2025
DBMS_APPLY_ADM_INTERNAL.ALTER_MONITOR_JOB dropped DBMS_APPLY_ADM_INTERNAL 20-May-2025
DBMS_AQ_IND_MON.GET_OUTPUT_LOG and SET_OUTPUT_LOG subprograms dropped DBMS_AQ_IND_MON 12-Aug-2024
DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL dropped DBMS_AUDIT_MGMT 20-May-2025
DBMS_BACKUP_RESTORE dropped the IR_ICD_FINISH and IR_ICD_START procedures DBMS_BACKUP_RESTORE 21-Aug-2025
DBMS_CAPTURE_ADM removed 4 "sync" subprograms DBMS_CAPTURE_ADM 24-Aug-2025
DBMS_CAPTURE_ADM_INTERNAL removed 2 "sync" subprograms DBMS_CAPTURE_ADM_INTERNAL 29-Aug-2025
DBMS_CRYPTO.COOKIE procedure removed DBMS_CRYPTO 26-Aug-2024
DBMS_CRYPTO_FFI.COOKIE procedure removed DBMS_CRYPTO_FFI 08-May-2024
DBMS_GSM_COMMON.ISCDB function removed DBMS_GSM_COMMON 14-May-2025
DBMS_GSM_UTILITY dropped ISGSMUP function DBMS_GSM_UTILITY 01-Dec-2024
DBMS_LOGREP_IMP dropped CREATE_SYNC_CAPTURE and PREPARE_SYNC_OBJECT DBMS_LOGREP_IMP 08-Sep-2025
DBMS_LOGREP_UTIL.GET_OBJECT_NAME function dropped DBMS_LOGREP_UTIL 08-Sep-2025
DBMS_LOGSTDBY removed 4 EDS prefixed subprograms DBMS_LOGSTDBY 07-Sep-2024
DBMS_RCVMAN has 14 dropped subprograms DBMS_RCVMAN 14-Oct-2025
DBMS_REPORT.REGISTER_SWF removed DBMS_REPORT 04-Oct-2025
DBMS_SQLTUNE_INTERNAL.I_INSERT_SQLSET_SQLTEXT dropped DBMS_SQLTUNE_INTERNAL 05-Oct-2025
DBMS_STATS_INTERNAL.VALIDATE_REALTIME_STATS_PREF procedure dropped DBMS_STATS_INTERNAL 19-May-2024
DBMS_STREAMS_ADM_UTL.PROCESS_DROP_USER_PRIVILEGE procedure dropped DBMS_STREAMS_ADM_UTL 12-Sep-2025
DBMS_STREAMS_RPC has 4 subprograms removed DBMS_STREAMS_RPC 02-Oct-2024
DBMS_STREAM_TBS_INT dropped 3 subprograms DBMS_STREAMS_TBS_INT 08-Aug-2024
DBMS_STREAM_TBS_INT_INVOK.GET_FILE_GROUP_VERSION_INFO function dropped DBMS_STREAMS_TBS_INT_INVOK 18-Aug-2025
DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY_INTERNAL procedure dropped DBMS_WORKLOAD_REPLAY 11-Aug-2025
DBMS_XDBUTIL_INT.CREATECROSSCONFOLDER procedure dropped DBMS_XDBUTIL_INT 11-May-2025
DBMS_XMLDOM_ICD has all 6 subprograms removed and is now an orphaned header DBMS_XMLDOM_ICD 24-Aug-2023
DBMS_XSTREAM_ADM_UTL dropped 2 subprogram DBMS_XSTREAM_ADM_UTL 11-Aug-2025
DRIACC dropped CAN_EXECUTE, USER_IN_ROLE and VERIFY_COLSPEC subprograms DRIACC 16-Jun-2025
DRIACCHELP dropped 4 subprograms DRIACCHELP 16-Jun-2025
JAVAVM_SYS has the procedure UNINSTALL_DBHADOOP removed JAVAVM_SYS 07-Aug-2023
KUPU$UTILITIES_INT has dropped GPD_IMP_ALLOWED KUPU$UTILITIES_INT 11-Aug-2024
KU$_DPLOAD removed all previously existing subprograms KU$_DPLOAD 01-Apr-2024
LOGSTDBY_INTERNAL dropped 6 subprograms with names beginning with EDS LOGSTDBY_INTERNAL 14-Dec-2023
OPG_APIS dropped 38 subprograms OPG_APIS 20-Jul-2025
OWM_ASSERT_PKG dropped NOOP procedure OWM_ASSERT_PKG 27-Mar-2024
PRVT_COMPRESS dropped LOAD_TAB_INMEMORY procedure PRVT_COMPRESS 27-Jan-2024
PRVT_EMX dropped the RGET_SWF function PRVT_EMX 17-Jul-2025
PRVT_HDM dropped the REPORT subprogram PRVT_HDM 17-Jul-2025
SEM_RDFCTX_DR dropped GET_POLICY_INFO or it relocated to SEM_RDFCTX_IR SEM_RDFCTX_DR 20-Jul-2025
 
Built-in Packages with New or Removed Overloads
DBMS_ABDTASK_ADMIN.MODIFY_ABDTASK_SETTINGS has 1 new overload DBMS_ABDTASK_ADMIN 01-May-2023
DBMS_AQ has 7 new overloads in 4 pre-existing subprograms DBMS_AQ 18-Aug-2025
DBMS_AQJADM_SYS.SCHEDULE_PROPAGATION has 1 new overload DBMS_AQADM_SYS 03-Nov-2024
DBMS_AQJMS SUBSCRIBER_EXISTS has a new overload DBMS_AQJMS 14-Oct-2024
DBMS_BACKUP_RESTORE has 29 new overloads across 20 different subprograms DBMS_BACKUP_RESTORE 21-Aug-2025
DBMS_CLOUD CREATE_CREDENTIAL and .SEND_REQUEST have 1 new overload each DBMS_CLOUD 17-Dec-2023
DBMS_CLOUD_INTERNAL.CREATE_CREDENTIAL has 2 new overloads DBMS_CLOUD_INTERNAL 17-Dec-2023
DBMS_COMPRESSION.GET_COMPRESSION_RATIO has 2 new overloads DBMS_COMPRESSION 04-Aug-2024
DBMS_CRYPTO has 3 new overloads each for DECRYPT and ENCRYPT DBMS_CRYPTO 26-Aug-2024
DBMS_CRYPTO_FFI has 3 new overloads each for DECRYPT and ENCRYPT DBMS_CRYPTO_FFI 29-Aug-2025
DBMS_DBFS_SFS subprograms have a total of 7 new overloads DBMS_DBFS_SFS 12-Aug-2025
DBMS_DRS has 40 previously existing subprograms with a total of 46 new overloads DBMS_DRS 27-Aug-2025
DBMS_GOLDENGATE_ADM has 2 subprograms with new overloads DBMS_GOLDENGATE_ADM 02-Sep-2025
DBMS_GSM_FIX has 4 new overloads DBMS_GSM_FIX 28-Jul-2024
DBMS_GSM_POOLADMIN.GET_INFO has 2 new overloads DBMS_GSM_POOLADMIN 13-May-2025
DBMS_GOLDENGATE_ADM_INT_INVOK has 2 new overloads DBMS_GOLDENGATE_ADM_INT_INVOK 18-Feb-2024
DBMS_HIERARCHY has new the GET_MV_SQL_FOR_AV_CACHE overload DBMS_HIERARCHY 14-Sep-2025
DBMS_JSON has new CREATE_VIEW overload DBMS_JSON 11-May-2025
DBMS_LOBUTIL has new GETPHYSICALLENGTH overload DBMS_LOBUTIL 08-Sep-2025
DBMS_METADATA_UTIL.GLO has 1 new overload DBMS_METADATA_UTIL 14-Aug-2025
DBMS_MLE has 14 new overloads 12 DBMS_MLE 11-Aug-2025
DBMS_PIPE has 3 subprograms each with 2 new overloads for a total of 6 DBMS_PIPE 08-Sep-2025
DBMS_PLUGTS.SENDTRACEMSG has new overload DBMS_PLUGTS 04-Oct-2025
DBMS_RCVMAN has 7 subprograms with a total of 8 overloads DBMS_RCVMAN 14-Oct-2025
DBMS_SNAPSHOT_UTL has 2 subprograms each with 1 new overload DBMS_SNAPSHOT_UTL 31-Aug-2025
DBMS_SQL has 6 subprograms with a total of 25 new overloads DBMS_SQL 13-Sep-2025
DBMS_SQLPA.CREATE_ANALYSIS_TASK has new overload 5 DBMS_SQLPA 06-Oct-2025
DBMS_SQLSET.UPDATE_SQL_SET has 1 new overload DBMS_SQLSET 08-Jun-2023
DBMS_SQLTUNE.UPDATE_SQLSET has 2 new overloads DBMS_SQLTUNE 05-Oct-2025
DBMS_SQLTUNE_INTERNAL.I_CREATE_TUNING_TASK and I_UPDATE_SQLSET DBMS_SQLTUNE_INTERNAL 05-Oct-2025
DBMS_STATS.CONFIGURE_ADVISOR_OPR_FILTER has 2 new overloads DBMS_STATS 10-Sep-2025
DBMS_SYS_ERROR has 26 new overloads DBMS_SYS_ERROR 30-Mar-2024
DBMS_SYS_MLE has 14 new overloads DBMS_SYS_MLE 11-Aug-2025
DBMS_SYS_SQL has 25 new overloads DBMS_SYS_SQL 10-Aug-2025
DBMS_UTILITY.COMMA_TO_TABLE has 2 new overloads DBMS_UTILITY 14-Sep-2025
DBMS_WRR_INTERNAL dropped 3 WRR LOCK related procedures DBMS_WRR_INTERNAL 11-Aug-2025
DBMS_XDBT.CONFIGURE_AUTOSYNC and CREATESECTIONGROUPPREF have new overloads DBMS_XDBT 12-May-2024
DBMS_XMLSCHEMA_UTIL.CONFORMING and VALIDATE have new overloads DBMS_XMLSCHEMA_UTIL 30-Jul-2025
KUPD$DATA_INT.SEND_TRACE_MSG has a new overload 2 KUPD$DATA_INT 28-Jul-2025
KUPM$MCP.FILE_LOG_MESSAGE has a new overload created as overload 1 KUPM$MCP 14-Feb-2024
OPG_APIS.DROP_PG has new overload 3 OPG_APIS 20-Jul-2025
OWA.GET_PAGE has a new overload OWA 18-Jul-2025
SA_UTL.DOMINATES dropped overload 3 SA_UTL 25-May-2025
STANDARD has dozens of new function and new overloads STANDARD 26-Jul-2025
 
Built-in Packages with Parameters Changes
DBMS_AVTUNE many subprograms have parameters and data type changes DBMS_AVTUNE 28-Aug-2025
DBMS_AWRHUB.SETUP_SERVER_CACHE_MAILBOX dropped 1 parameter DBMS_AWRHUB 28-Aug-2025
DBMS_AWRHUB.SETUP_SOURCE_CACHE_MAILBOX added 1 new parameter DBMS_AWRHUB 28-Aug-2025
DBMS_AWRHUB_SOURCE.MODIFY_SOURCE_SETTINGS has 4 new parameters DBMS_AWRHUB_SOURCE 28-Aug-2025
DBMS_BLOCKCHAIN_TABLE.GET_BYTES_FOR_ROW_HASH has new parameter DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_BLOCKCHAIN_TABLE.GET_SIGNED_BLOCKCHAIN_DIGEST has 2 new parameters DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_BLOCKCHAIN_TABLE.IMPORT_CHAIN has 2 new parameters DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_BLOCKCHAIN_TABLE.IMPORT_EPOCH has 3 new parameters DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_BLOCKCHAIN_TABLE.SIGN_ROW has new parameter DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_CLOUD has new SEND_REQUEST parameters DBMS_CLOUD 17-Dec-2023
DBMS_CLOUD_INTERNAL has 2 subprograms with new parameters DBMS_CLOUD_INTERNAL 17-Dec-2023
DBMS_DBFS_CONTENT_ADMIN has new parameters in 5 subprograms DBMS_DBFS_CONTENT_ADMIN 04-Aug-2024
DBMS_GSM_FIX.VALIDATESHARD has new IS_CDB parameter DBMS_GSM_FIX 28-Jul-2024
DBMS_GSM_FIXED.FIXBC has 2 new parameters DBMS_GSM_FIXED 08-Apr-2024
DBMS_GSM_SEC.PUTMKEY has a new parameters DBMS_GSM_SEC 28-May-2023
DBMS_LOGREP_UTIL.GET_PDB_SHORT_NAME has 1 new parameter DBMS_LOGREP_UTIL 14-Nov-2024
DBMS_PDB_ALTER_SHARING has a new FORCE parameter in 5 subprograms DBMS_PDB_ALTER_SHARING 06-Jun-2023
DBMS_REPLAYHUB has 4 subprograms with new and/or renamed parameters DBMS_REPLAYHUB 01-Mar-2024
DBMS_SODA has 6 subprograms with new parameter defaults DBMS_SODA 08-Jul-2024
DBMS_SQLTUNE_UTIL2.VALIDATE_SNAPSHOT has a new parameter DBMS_SQLTUNE_UTIL2 11-Aug-2024
DBMS_USER_CERTS has 2 subprograms with renamed parameters DBMS_USER_CERTS 06-Jun-2023
 
Built-in Packages with New or Removed Constants, Exceptions, Types, or other Significant Changes
DBMS_AVTUNE has new constants and types DBMS_AVTUNE 28-Aug-2025
DBMS_BLOCKCHAIN_TABLE pragma has changed from UNSUPPORTED to NONE DBMS_BLOCKCHAIN_TABLE 01-May-2023
DBMS_CLOUD has many new constants DBMS_CLOUD 01-May-2023
DBMS_COMPRESSION has 2 new constants DBMS_COMPRESSION 04-Aug-2024
DBMS_DB_VERSION has new 23ai constant DBMS_DB_VERSION 22-Apr-2024
DBMS_EDITIONS_UTILITIES has 4 new constants DBMS_EDITIONS_UTILITIES 10-Jun-2023
DBMS_FLASHBACK_ARCHVE has 3 new LIFESPAN constants DBMS_FLASHBACK_ARCHIVE 16-Jul-2024
DBMS_GSM_DDL.DECDDLVCH trim size parameter has new default value DBMS_GSM_DDL 28-May-2023
DBMS_GSM_FIX has 11 new length constants and 1 new exception DBMS_GSM_FIX 28-Jul-2024
DBMS_GSM_FIXED has new ALL_DATABASES and IN_PAYLOAD constants DBMS_GSM_FIXED 08-Apr-2024
DBMS_ILN_ADMIN has many new constants DBMS_ILM_ADMIN 04-Sep-2025
DBMS_LCR has new oson_diff constant DBMS_LCR 07-Oct-2025
DBMS_PQDIAG has new qcslv_type_postjoin and qcslv_col_postjoin types DBMS_PQDIAG 01-May-2023
DBMS_SODA has 2 new constants DBMS_SODA 08-Jul-2024
DBMS_SPACE has 12 new constants DBMS_SPACE 01-Sep-2025
DRIG has 52 new constants and dropped 30 constants DRIG 17-Oct-2025
DRIOBJ has 26 new constants DRILIST 07-Sep-2024
DRIOBJ has 4 new constants DRIOBJ 14-Jun-2024
UTL_RECOMP has new ORACLE_MAINTAINED and STUBS constants UTL_RECOMP 10-Jun-2023
UTL_SMTP has 2 new constants UTL_SMTP 04-Sep-2024
 
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 21c
  Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved