New In Oracle Database Versions 18cR1 to R3
Version 18.3.0.1

Description Link Last Modified
Architecture
NO AUTHENTICATION schemas Users 06-Mar-2018
Read Only Oracle Home (ROOH) ROOH 26-Feb-2018
DataPump No Logging Option for Import DataPump -
SQL*Loader Express Mode SQL*Loader -
Full transportable support for point-in-time recoveryof PDBs - -
 
General
New Users
  • APEX_PUBLIC_USER
  • APEX_REST_PUBLIC_USER
  • FLOWS_FILES
Deprecated/Dropped Roles as Part of Default Install
  • SPATIAL_CSW_ADMIN_USR
USERS 03-May-2018
New Roles
  • None
Deprecated/Dropped Roles as Part of Default Install
  • JAVA_DEPLOY
  • SPATIAL_CSW_ADMIN
  • XFILES_ADMINISTRATOR
  • XFILES_USER
ROLE 04-Mar-2018
New System Privileges
  • READ ANY ANALYTIC VIEW CACHE
  • TEXT DATASTORE ACCESS
  • WRITE ANY ANALYTIC VIEW CACHE
Deprecated/Dropped System Privileges
  • EXEMPT DDL REDACTION POLICY
  • EXEMPT DML REDACTION POLICY
SYSTEM PRIVILEGES 04-Mar-2018
New Object Privileges
  • None
Deprecated/Dropped Object Privileges

  • None
Object Privileges 04-Mar-2018
New Dynamic Performance Views
  • gv$aq_ipc_active_msgs
  • gv$aq_ipc_msg_stats
  • gv$aq_ipc_pending_msgs
  • gv$aq_job_coordinator
  • gv$asm_audit_load_jobs
  • gv$asm_cache_events
  • gv$database_replay_progress
  • gv$imhmseg
  • gv$im_delta_header
  • gv$im_smu_delta
  • gv$java_patching_status
  • gv$java_services
  • gv$memoptimize_write_area
  • gv$quarantine_summary
  • gv$lockdown_rules
  • gv$sqlcommand
  • gv$sql_shard
  • gv$subscr_registration_stats
  • gv$wlm_pcservice
  • vw_x$aud_xs_actions
  • v$_lock
Deprecated/Dropped Dynamic Performance Views
  • v$diag_dfs_purge
  • gv$unified_audit_trial
Dynamic Performance Views 17-Jan-2019
New Initialization Parameters
  • ADG_ACCOUNT_INFO_TRACKING
  • AWR_PDB_MAX_PARALLEL_SLAVES
  • DBFIPS_140
  • DB_BLOCK_CHECKING (the old parameter was TRUE/FALSE this one is not)
  • FORWARD_LISTENER
  • INMEMORY_AUTOMATIC_LEVEL
  • INMEMORY_OPTIMIZED_ARITHMETIC
  • INMEMORY_PREFER_XMEM_MEMCOMPRESS
  • INMEMORY_PREFER_XMEM_PRIORITY
  • INMEMORY_XMEM_SIZE
  • MEMOPTIMIZE_POOL_SIZE
  • MULTISHARD_QUERY_DATA_CONSISTENCY
  • MULTISHARD_QUERY_PARTIAL_RESULTS
  • OPTIMIZER_IGNORE_HINTS
  • OPTIMIZER_IGNORE_PARALLEL_HINTS
  • PARALLEL_MIN_DEGREE
  • PDB_TEMPLATE
  • PRIVATE_TEMP_TABLE_PREFIX
  • RESOURCE_MANAGER_CPU_ALLOCATION
  • STANDBY_PDB_SOURCE_FILE_DBLINK
  • STANDBY_PDB_SOURCE_FILE_DIRECTORY
  • TDE_CONFIGURATION
  • UNIFIED_AUDIT_SYSTEMLOG
  • WALLET_ROOT
Deprecated Initialization Parameters
  • DBA_REGISTERED_MVIEW_GROUPS
  • DB_BLOCK_CHECKING (the parameter name still exists but valid values have changed)
  • GLOBAL_CONTEXT_POOL_SIZE
  • MAX_ENABLED_ROLES
  • OPTIMIZER_ADAPTIVE_FEATURES
  • PARALLEL_AUTOMATIC_TUNING
  • PARALLEL_IO_CAP_ENABLED
  • PARALLEL_SERVER
  • PARALLEL_SERVER_INSTANCES
  • STANDBY_ARCHIVE_DEST
  • UTL_FILE_DIR
Startup Parameters 01-Apr-2018
 
Deprecated or Dropped
DBMS_CDC_EXPDP N/A 02-Mar-2018
DBMS_CDC_EXPVDP DBMS_CDC_EXPVDP 02-Mar-2018
DBMS_CDC_IMPDP N/A 02-Mar-2018
DBMS_CDC_IMPDPV DBMS_CDC_IMPDPV 02-Mar-2018
DBMS_CDC_IPUBLISH N/A 02-Mar-2018
DBMS_CDC_ISUBSCRIBE N/A 02-Mar-2018
DBMS_CDC_PUBLISH DBMS_CDC_PUBLISH 02-Mar-2018
DBMS_CDC_SUBSCRIBE DBMS_CDC_SUBSCRIBE 02-Mar-2018
DBMS_CDC_SYS_IPUBLISH N/A 02-Mar-2018
DBMS_CDC_DPUTIL N/A 02-Mar-2018
DBMS_CDC_UTILITY DBMS_CDC_UTILITY 02-Mar-2018
DBMS_FEATURE_CDC DBMS_FEATURE_USAGE 04-Jun-2018
DBMS_FIXED_CONTROL_PERSISTENCE DBMS_FIX_CONTROL_PERSISTENCE 14-Jan-2019
DBMS_XMLQUERY DBMS_XMLQUERY 05-Apr-2018
DBMS_XMLSAVE DBMS_XMLSAVE 05-Apr-2018
Oracle Multimedia and DICOM Multiple Built-in Packages 05-Apr-2018
ORD_DICOM_PROTOCOL N/A 06-Dec-2018
 
New Object Types
Private Temporary Tables Temporary Tables 06-Mar-2018
 
New SQL
TRUNCATE TABLE CASCADE Truncate 07-Jan-2019
 
New PL/SQL
??? ??? TBD
 
New or Modified Functions, Operators, Procedures, and Types
APPROX_COUNT Numeric Functions 17-Mar-2018
APPROX_RANK Numeric Functions 17-Mar-2018
APPROX_SUM Numeric Functions 17-Mar-2018
AS_JSON Undocumented Oracle 26-Dec-2018
COLUMNS Undocumented Oracle 26-Dec-2018
CON_ID_TO_CON_NAME Undocumented Oracle 26-Dec-2018
CON_ID_TO_DBID Undocumented Oracle 26-Dec-2018
DBMS_FEATURE_VPD DBMS_FEATURE_USAGE 04-Jun-2018
JSONTOXML Undocumented Oracle 26-Dec-2018
JSON_EQUAL Undocumented Oracle 26-Dec-2018
JSON_MERGEPATCH Undocumented Oracle 26-Dec-2018
JSON_TEXTCONTAINS2 Undocumented Oracle 26-Dec-2018
LAG_DIFF Undocumented Oracle 26-Dec-2018
LAG_DIFF_PERCENT Undocumented Oracle 26-Dec-2018
LDAP_SERVER_TYPE SYS_CONTEXT 31-May-2018
LEAD_DIFF Undocumented Oracle 26-Dec-2018
LEAD_DIFF_PERCENT Undocumented Oracle 26-Dec-2018
ORA_CHECK_SYS_PRIV Undocumented Oracle 26-Dec-2018
ORA_PARTITION_VALIDATION Undocumented Oracle 26-Dec-2018
OSON Undocumented Oracle 26-Dec-2018
ROUND_TIED_TO_EVEN Numeric Functions 17-Mar-2018
SYS_PLSQL_COUNT Undocumented Oracle 26-Dec-2018
SYS_PLSQL_CPU Undocumented Oracle 26-Dec-2018
SYS_PLSQL_IO Undocumented Oracle 26-Dec-2018
TO_UTC_TIMEZONE_TZ Conversion Function 26-Dec-2018
 
Object Rename
XS_DATA_SECURITY_UTIL renamed to XS_DATA_SECURITY_UTIL_INT XS_DATA_SECURITY_UTIL_INT 26-Jul-2018
 
New or Modified Functions, Operators, Procedures, and Types
TBD ??? TBD
 
JSON, SODA and XML
SQL and PL/SQL can be instructed to return JSON data using TREAT JSON TBD
SQL/JSON queries can return LOBs JSON TBD
SQL/JSON path expression enhancements JSON TBD
Data Dictionary Views can be used to extract path and type information for data guide enabled JSON JSON TBD
SQL/JSON dot notation to access fields JSON TBD
SQL/JSON automatic renaming of projected columns JSON TBD
Materialized Views created from JSON tables can be automatically synchronized JSON TBD
JSON key names can be 255 bytes JSON TBD
PL/SQL programs can interact with SODA document collections stored in the database SODA TBD
 
New Built-in Packages
DBMS_AWR_PROTECTED DBMS_AWR_PROTECTED 04-Mar-2018
DBMS_ISCHEDFW DBMS_ISCHEDFW 05-Mar-2018
DBMS_ISCHED_AGENT DBMS_ISCHED_AGENT 06-Mar-2018
DBMS_ISCHED_UTL DBMS_ISCHED_UTL 20-Mar-2018
DBMS_MEMOPTIMIZE DBMS_MEMOPTIMIZE 16-Sep-2018
DBMS_PDB_APP_CON DBMS_PDB_APP_CON 03-Mar-2018
DBMS_SODA DBMS_SODA 25-Feb-2018
DBMS_SQLSET DBMS_SQLSET 03-Mar-2018
DBMS_STATS_INTERNAL_AGG DBMS_STATS_INTERNAL_AGG 08-Apr-2018
DBMS_WORKLOAD_CAPTURE_I DBMS_WORKLOAD_CAPTURE_I 19-May-2018
DBMS_WORKLOAD_REPLAY_I DBMS_WORKLOAD_REPLAY_I 19-May-2018
DBMS_WRR_REPORT DBMS_WRR_REPORT -
DBMS_XDS_INT DBMS_XDS_INT 07-May-2018
 
Built-in Packages with New or Removed Functions and Procedures
DBMS_ADR has three new objects DBMS_ADR 10-Feb-2019
DBMS_ADR_APP has GET_CALL_ERROR_MSG and GET_CALL_STATUS functions DBMS_ADR_APP 29-Dec-2018
DBMS_AQ has 12 new objects DBMS_AQ 10-Dec-2018
DBMS_AQADM_VAR has 2 new functions DBMS_AQADM_VAR 10-Dec-2018
DBMS_AUDIT_MGMT has 4 new objects DBMS_AUDIT_MGMT 05-Dec-2018
DBMS_AW has three new objects DBMS_AW 31-Dec-2018
DBMS_BACKUP_RESTORE has 9 new objects DBMS_BACKUP_RESTORE 01-Jan-2019
DBMS_CSX_INT drops testDecodeJC and testEncodeJC functions DBMS_CSX_INT 01-Jan-2019
DBMS_CSX_INT adds 4 new objects DBMS_CSX_INT 01-Jan-2019
DBMS_CUBE_ADVISE_SEC removed 6 objects DBMS_CUBE_ADVISE_SEC 06-Jan-2019
DBMS_DBFS_CONTENT_ADMIN has 3 new objects DBMS_DBFS_CONTENT_ADMIN 07-Jan-2019
DBMS_DDL_INTERNAL dropped two HAS_ objects DBMS_DDL_INTERNAL 08-Jan-2019
DBMS_DM_UTIL has 6 objects removed DBMS_DM_UTIL 13-Dec-2018
DBMS_DEBUG has new GET_DIAGNOSTIC_LEVEL and GET_TIMEOUT objects DBMS_DEBUG 08-Jan-2019
DBMS_DRS has had 6 objects removed DBMS_DATA_MINING_INTERNAL 06-Dec-2018
DBMS_DNFS has new RESTORE_DATAFILE_PERMISSIONS object DBMS_DNFS 13-Dec-2018
DBMS_DRS has 27 new objects several with overloads DBMS_DRS 05-Dec-2018
DBMS_EDITIONS_UTILITIES has new CLEAN_UNUSABLE_EDITIONS procedures DBMS_EDITIONS_UTILITIES 31-Jan-2019
DBM_FREQUENT_ITEMSET has 3 new objects DBMS_FREQUENT_ITEMSET 13-Dec-2018
DBM_FS has new DESTROY_ORACLE_FS procedure DBMS_FS 13-Dec-2018
DBM_GOLDENGATE_ADM has new UPDATE_IDENTITY_COLUMN_HWM procedures DBMS_GOLDENGATE_ADM 31-Jan-2019
DBM_GSM_COMMON has 6 new objects DBMS_GSM_COMMON 17-Feb-2019
DBM_GSM_DBADMIN has 4 new objects DBMS_GSM_DBADMIN 18-Feb-2019
DBM_GSM_FIX has 2 new objects DBMS_GSM_FIX 18-Feb-2019
DBM_GSM_FIXED has 2 new objects DBMS_GSM_FIXED 18-Feb-2019
DBM_GSM_POOLADMIN has 8 new objects DBMS_GSM_POOLADMIN 18-Feb-2019
DBM_GSM_UTILITY has 8 new objects DBMS_GSM_UTILITY 18-Feb-2019
DBM_HADOOP_INTERNAL has 4 new objects DBMS_HADOOP_INTERNAL 19-Feb-2019
DBMS_HPROF has new CREATE_TABLES procedure DBMS_HPROF 14-Mar-2018
DBMS_LOGREP_UTIL has 25 new obects, 2 with overloads DBMS_LOGREP_UTIL 17-Dec-2018
DBMS_LOGREP_UTIL_INVOK has 2 new obects, DBMS_LOGREP_UTIL_INVOK 18-Dec-2018
DBMS_METADATA removed the 2 VAT_TABLE_NAME objects DBMS_METADATA 25-Dec-2018
DBMS_METADATA has new CHECK_CONSTRAINT function DBMS_METADATA 25-Dec-2018
DBMS_NETWORK_ACL_ADMIN.INSTANCE_EXPORT_ACTION dropped DBMS_NETWORK_ACL_ADMIN 06-Feb-2019
DBMS_OBJECTS_UTILS has new PERSISTABLE_DOWNGRADE_CHECK function DBMS_OBJECTS_UTILS 22-Dec-2018
DBMS_PDB has removed REMOVE_LINK and UPDATE_OBJLINK_STATS DBMS_PDB 29-Jun-2018
DBMS_PDB has 5 new objects DBMS_PDB 29-Jun-2018
DBMS_QOPATCH has 4 new objects DBMS_QOPATCH 19-Jan-2019
DBMS_REDEFINITION has 5 new objects DBMS_REDEFINITION 22-Nov-2018
DBMS_SESSION has 5 new objects DBMS_SESSION 30-May-2018
DBMS_PREUP ... has the same name and function as previous versions but contents all new DBMS_PREUP 30-Sep-2018
DBMS_SPM has new LOAD_PLANS_FROM_AWR function DBMS_SPM 08-Dec-2018
DBMS_SQLPATCH has 8 new objects and dropped VERIFY_QUERYABLE_INVENTORY DBMS_SQLPATCH 01-Oct-2018
DBMS_SQL has new BIND_VARIABLE_PKG and VARIABLE_VALUE_PKG objects DBMS_SQL 05-Dec-2018
DBMS_SQLTUNE has 6 new objects DBMS_SQLTUNE 09-Jul-2018
DBMS_STREAMS_TABLESPACE_ADM has 2 new objects DBMS_STREAMS_TABLESPACE_ADM 06-Feb-2019
DBMS_TF contains 11 new objects DBMS_TF 12-Apr-2018
DBMS_TG_DBG has new SET_SESSION_DRAINABLE procedure DBMS_TG_DBG 27-Jan-2019
DBMS_WORKLOAD_CAPTURE has 5 new objects DBMS_WORKLOAD_CAPTURE 19-May-2018
DBMS_WORKLOAD_REPLAY has 6 new objects DBMS_WORKLOAD_REPLAY 19-May-2018
DBMS_WORKLOAD_REPOSITORY has 8 new objects DBMS_WORKLOAD_REPOSITORY 27-Jan-2019
DBMS_WRR_INTERNAL dropped the 3 objects from 12c and added 4 new objects DBMS_WRR_INTERNAL 10-Feb-2019
DBMS_WRR_PROTECTED dropped the 2 objects from 12c and added 3 new objects DBMS_WRR_PROTECTED 26-Jan-2019
DBMS_XPLAN has 2 new objects DBMS_XPLAN 23-May-2018
DBMS_XSTREAM_ADM has new GET_IS_XSTREAM function DBMS_XSTREAM_ADM 10-Feb-2019
DBMS_XS_PRINCIPALS ADD and REMOVE schema proxy objects dropped DBMS_XS_PRINCIPALS 22-Nov-2018
KUBSAGT has new DESCRIBE_VERSION function KUBSAGT 06-Jul-2018
KUPP$PROC has three new objects KUPP$PROC 17-Feb-2019
PRVTEMX_DBHOME has 4 objects removed and 2 new objects PRVTEMX_DBHOME 20-Nov-2018
PRVT_AWR_VIEWER has 14 new objects PRVT_AWR_VIEWER 20-Nov-2018
UTL_CALL_STACK has 2 new functions UTL_CALL_STACK 03-Aug-2018
UTL_HTTP has new UTL_RAW_PTR function UTL_HTTP 03-Aug-2018
UTL_I18N has new VALIDATE_CARACTER_ENCODING function UTL_I18N 27-Jul-2018
XS_ADMIN_UTIL has new VALIDATE_DB_USER procedure XS_ADMIN_UTIL 26-Jul-2018
XS_PRINCIPAL has new SET_ACL procedure XS_PRINCIPAL 06-Feb-2019
 
Built-in Packages with New or Removed Overloads
DBMS_FILE_TRANSFER.COPY_FILE has 1 new overload DBMS_FILE_TRANSFER 31-Jan-2019
DBM_GSM_COMMON.RESETDBPARAMETER has 1 new overload DBMS_GSM_COMMON 17-Feb-2019
DBM_GSM_COMMON.SETDBPARAMETER has 3 new overloads DBMS_GSM_COMMON 17-Feb-2019
DBMS_HPROF ANALYZE has 2 new overloads, START_PROFILING has 1 DBMS_HPROF 14-Mar-2018
DBMS_SQLTUNE.BIND_VARIABLE and VARIABLE_VALUE have new overloads DBMS_SQL 05-Dec-2018
DBMS_SQLTUNE.CREATE and SCHEDULE _TUNING TASK has 1 new overload each DBMS_SQLTUNE 09-Jul-2018
DBMS_TF.GET_ROW_SET has a new overload DBMS_TF 12-Apr-2018
DBMS_XPLAN.DISPLAY_CURSOR has 2 new overoads DBMS_XPLAN 23-May-2018
XS_PRINCIPAL.GRANT_ROLES has a new overload XS_PRINCIPAL 23-Jul-2018
 
Built-in Packages with Parameters Changes
DBMS_DISRUPT has new parameter defaults and USER_NAMES added to disrupt_sessions DBMS_DISTRUPT 04-Jun-2018
DBMS_DST.FIND_AFFECTED_TABLES has new PARALLEL parameter DBMS_DST 04-Jun-2018
DBMS_XPLAN.PREPARE_RECORDS has 4 new parameters DBMS_XPLAN 23-May-2018
XS_ADMIN_UTIL.GRANT_SYSTEM_PRIVILEGE has new parameter XS_ADMIN_UTIL 26-Jul-2018
XS_ADMIN_UTIL.REVOKE_SYSTEM_PRIVILEGE has new parameter XS_ADMIN_UTIL 26-Jul-2018
XS_PRINCIPAL has new ACL parameter in 2 objects XS_PRINCIPAL 23-Jul-2018
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_ADR_APP has new NOERROR and PURGE_DEFAULT_THRESHOLD constants DBMS_ADR_APP 29-Dec-2018
DBMS_AUDIT_MGMT has 2 new Partition Interval constants DBMS_AUDIT_MGMT 05-Dec-2018
DBMS_DB_VERSION has new VER_LE_18 constant DBMS_DB_VERSION 04-Jun-2018
DBMS_DISRUPT has new all_users, cur_instance, and cur_user constants DBMS_DISTRUPT 04-Jun-2018
DBMS_FBT uses a redefined FLASHBACKTBLIST type DBMS_FBT 06-Jun-2018
DBMS_TF has multiple new constants and types DBMS_TF 12-Apr-2018
DBMS_XPLAN.DISPLAY_CURSOR has new num_tab_type type DBMS_XPLAN 23-May-2018
MGMT_DB_LL_METRICS has new VERSION_12gR2 constant MGMT_DB_LL_METRICS 23-Jul-2018
ODCICONST has 3 new IndexInfoFlag constants ODCICONST 13-Jul-2018
XS_ADMIN_UTIL has 6 new constants and 4 new exceptions XS_ADMIN_UTIL 26-Jul-2018
 
Related Topics
New in 11.2.0.3
New in 12.1.0.2
New in 12.2.0.1
New in 19.2.0.1
  Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved