New In Oracle Database Version 18cR1 and R2
Version 18.1.0.0

Description Link Last Modified
Architecture
NO AUTHENTICATION schemas Users 06-Mar-2018
Private Temporary Tables Temporary Tables 06-Mar-2018
Read Only Oracle Home (ROOH) ROOH 26-Feb-2018
 
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 PRVILEGES 04-Mar-2018
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_XMLQUERY DBMS_XMLQUERY 05-Apr-2018
DBMS_XMLSAVE DBMS_XMLSAVE 05-Apr-2018
Oracle Multimedia and DICOM Multiple Built-in Packages 05-Apr-2018
 
New SQL
??? ??? TBD
??? ??? TBD
 
New PL/SQL
??? ??? TBD
??? ??? 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
DBMS_FEATURE_VPD DBMS_FEATURE_USAGE 04-Jun-2018
ROUND_TIED_TO_EVEN Numeric Functions 17-Mar-2018
LDAP_SERVER_TYPE SYS_CONTEXT 31-May-2018
 
Object Rename
TBD ??? TBD
 
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 30-Mar-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_XDS_INT DBMS_XDS_INT 07-May-2018
 
Built-in Packages with New or Removed Functions and Procedures
DBMS_DRS has 27 new objects several with overloads DBMS_DRS 01-Mar-2018
DBMS_HPROF has new CREATE_TABLES procedure DBMS_HPROF 14-Mar-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_SESSION has 5 new objects DBMS_SESSION 30-May-2018
DBMS_SQLTUNE has 6 new objects DBMS_SQLTUNE 09-Jul-2018
DBMS_TF contains 11 new objects DBMS_TF 12-Apr-2018
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_XPLAN has 2 new objects DBMS_XPLAN 23-May-2018
KUBSAFT has new DESCRIBE_VERSION function KUBSAGT 06-Jul-2018
 
Built-in Packages with New or Removed Overloads
DBMS_HPROF ANALYZE has 2 new overloads, START_PROFILING has 1 DBMS_HPROF 14-Mar-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
 
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
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
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
ODCICONST has 3 new IndexInfoFlag constants ODCICONST 13-Jul-2018
 
Related Topics
New in 12.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-2017 Daniel A. Morgan All Rights Reserved