| 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
Deprecated/Desupported/Dropped Background Processes
|
Background Processes |
01-May-2023 |
New Objects
Deprecated/Desupported/Dropped Objects
|
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
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
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
|
OBJECT PRIVILEGES |
01-May-2023 |
| New Hints
|
- |
- |
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
Deprecated, Desupported or Dropped
|
- |
- |
| |
| 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 |