New In Oracle Database
Version 19c

Description Link Last Modified
Architecture
TBD    
 
General
New Users
  • GSMROOTUSER
Deprecated/Dropped Users as Part of Default Install
  • None
USERS 23-Feb-2019
New Roles
  • APPLICATION_TRACE_VIEWER
  • BDSQL_ADMIN
  • BDSQL_USER
  • GSMROOTUSER_ROLE
  • MGW_ADMINISTRATOR_ROLE
  • MGW_AGENT_ROLE
  • ORACLE_JAVA_DEV
  • SYSUMF_ROLE
Deprecated/Dropped Roles as Part of Default Install
  • None
ROLE 23-Feb-2019
New System Privileges
  • TBD
Deprecated/Dropped System Privileges
  • TBD
SYSTEM PRIVILEGES 23-Feb-2019
New Object Privileges
  • TBD
Deprecated/Dropped Object Privileges

  • TBD
Object Privileges 23-Feb-2019
New Dynamic Performance Views
  • TBD
Deprecated/Dropped Dynamic Performance Views
  • TBD
Dynamic Performance Views 23-Feb-2019
New Hints
  • JSON_LENGTH
  • NO_PQ_EXPAND_TABLE
  • NO_USE_SCALABLE_GBY_INVDIST
  • PQ_EXPAND_TABLE
  • QUARANTINE
  • USE_SCALABLE_GBY_INVDIST
Hints 30-Jul-2019
New Initialization Parameters
  • DATA_GUARD_MAX_IO_TIME
  • DATA_GUARD_MAX_LONGIO_TIME
  • ENABLE_IMC_WITH_MIRA
  • LOG_SIGNATURE_ENABLE
  • MAX_DATAPUMP_PARALLEL_PER_JOB
Deprecated Initialization Parameters

  • CLUSTER_DATABASE_INSTANCES
  • CURSOR_SPACE_FOR_TIME
Startup Parameters 22-Oct-2020
New Built-In Packages
  • See below
Dropped Built-In Packages
  • DBMS_APPLY_HANDLER_ADM
  • DBMS_APPLY_HANDLER_INTERNAL
  • DBMS_FIX_CONTROL_PERSISTENCE
  • DBMS_OPTIM_BUNDLE
  • DBMS_OUTLN_EDIT
  • DBMS_STREAMS_ADVISOR_ADM
  • DBMS_STREAMS_ADV_ADM_UTL
  • DBMS_STREAMS_ADV_ADM_UTL_INVOK
  • DBMS_STREAMS_HANDLER_ADM
  • DBMS_STREAMS_HANDLER_INTERNAL
  • DBMS_STREAMS_MC
  • DBMS_STREAMS_MC_INV
  • DBMS_STREAMS_MESSAGING
  • DBMS_SUMREF_UTIL
  • OUTLN_EDIT_PKG
Built-In Packages 21-Jun-2019
 
Deprecated or Dropped Objects
Product User Profile: The table still exists ... but the functionality does not.   09-Dec-2019
 
New Object Types
Hybrid Partitioned Tables Partitioning 23-Feb-2019
 
New SQL
DISTINCT operator is now available for use with the LISTAGG aggregate Analytic Functions 24-Feb-2019
Materialized views query rewriting is enhanced to support queries with JSON_EXISTS, JSON_VALUE and other functions when it contains a JSON_TABLE function Materialized Views 24-Feb-2019
 
New PL/SQL
TBD    
 
New or Modified Functions, Operators, Procedures, and Types
TO_BLOB has 1 new overloads Conversion Function 09-Mar-2019
TO_CHAR has 2 new overloads (25 & 26) Conversion Function 09-Mar-2019
TO_CLOB has 2 new overloads Conversion Function 09-Mar-2019
 
Renamed Objects
TBD    
 
New or Modified Functions, Operators, Procedures, and Types
New JSON_DATAGUIDE SQL aggregate function can detect GeoJSON in docs JSON 24-Feb-2019
New JSON_MERGE_PATCH function can update a JSON document declaratively applying one or more changes to multiple documents in a single statement JSON 24-Feb-2019
New JSON_SERIALIZE function to serialize JSON data to text or UTF-encoded BLOBs JSON 24-Feb-2019
 
Changes to JSON, SODA and XML
Syntax simplifications for SQL/JSON path expressions and new JSON_SERIALIZE function JSON 24-Feb-2019
Materialized views query rewriting is enhanced to support queries with JSON_EXISTS, JSON_VALUE and other functions when it contains a JSON_TABLE function Materialized Views 24-Feb-2019
 
New Built-in Packages
DBMS_APP_CONT_ADMIN with 10 objects relocated from DBMS_APP_CONT DBMS_APP_CONT_ADMIN 30-Jun-2019
DBMS_AQ_IMPORT_INTERNAL_DR DBMS_AQ_IMPORT_INTERNAL_DR 01-Jul-2019
DBMS_AUTO_INDEX DBMS_AUTO_INDEX 02-Jul-2019
DBMS_AUTO_INDEX_INTERNAL DBMS_AUTO_INDEX_INTERNAL 02-Jul-2019
DBMS_AWR_WAREHOUSE_SERVER DBMS_AWR_WAREHOUSE_SERVER 30-Jun-2019
DBMS_AWR_WAREHOUSE_SOURCE DBMS_AWR_WAREHOUSE_SOURCE 30-Jun-2019
DBMS_BDSQL DBMS_BDSQL 30-Jun-2019
DBMS_CHAIN_INVOKER DBMS_CHAIN_INVOKER 03-Jul-2019
DBMS_FEATURE_USAGE_CLIENT DBMS_FEATURE_USAGE_CLIENT 03-Jul-2019
DBMS_FUSE_PUBLIC DBMS_FUSE_PUBLIC 30-Jun-2019
DBMS_JAVA_DEV DBMS_JAVA_DEV 02-Mar-2019
DBMS_MEMOPTIMIZE_ADMIN DBMS_MEMOPTIMIZE_ADMIN 22-Feb-2019
DBMS_SQLCONTROL_INTERNAL DBMS_SQLCONTROL_INTERNAL 28-Jun-2019
DBMS_SQLQ DBMS_SQLQ 23-Feb-2019
DBMS_SQLQ_INTERNAL DBMS_SQLQ_INTERNAL 28-Jun-2019
KUBSD$DESC_INT KUBSD$DESC_INT 24-Feb-2019
KU$_DPLOAD KU$_DPLOAD 04-Mar-2019
KU$_DPLOCK KU$_DPLOCK 04-Mar-2019
PRVT_ASH_OMX PRVT_ASH_OMX 28-Jun-2019
SDO_RDF_SYS SDO_RDF_SYS 25-Jan-2020
UTL_RPADV UTL_RPADV 22-Feb-2019
XDB_MIGRATESCHEMA XDB_MIGRATESCHEMA 28-Jun-2019
 
Built-in Packages with New or Removed Objects
CDBVIEW_INTERNAL has new CREATE_CDBVIEW procedure CDBVIEW_INTERNAL 24-Feb-2019
DBMS_APPLY_ADM ADD_STMT_HANDLER, REMOVE_STMT_HANDER and SET_CHANGE_HANDLER removed DBMS_APPLY_ADM 25-Feb-2019
DBMS_APPLY_ADM has new CLEAR_KEY_COLUMNS procedure DBMS_APPLY_ADM 25-Feb-2019
DBMS_APP_CONT had 10 new objects (4 relocated from DBMS_SESSION) DBMS_APP_CONT 30-Jun-2019
DBMS_AUTO_TASK_ADMIN has new MODIFY_AUTOTASK_SETTINGS procedure DBMS_AUTO_TASK_ADMIN 26-Feb-2019
DBMS_DATAPUMP_UTL has new DBMS_DATAPUMP_UTL 03-May-2020
DBMS_DBFS_SFS_ADMIN dropped BLESSUSER procedure DBMS_DBFS_SFS_ADMIN 14-May-2019
DBMS_DBFS_SFS_ADMIN has 6 new objects DBMS_DBFS_SFS_ADMIN 14-May-2019
DBMS_DRS has new METADATA_FILE procedure DBMS_DRS 27-Feb-2019
DBMS_GSM_CLOUDADMIN has new CAT_REDO_MARKER procedure DBMS_GSM_CLOUDADMIN 04-Mar-2019
DBMS_GSM_DBADMIN has 5 new objects DBMS_GSM_DBADMIN 28-Feb-2019
DBMS_GSM_FIX has new GETDBVERSION and VALIDATECDB objects DBMS_GSM_FIX 20-May-2019
DBMS_GSM_POOLADMIN has new PDB_FIXUP and RECOVERCHUNKS procedures DBMS_GSM_POOLADMIN 17-Mar-2019
DBMS_GSM_UTILITY has new GETVERSIONSTRING function DBMS_GSM_UTILITY 20-May-2019
DBMS_HADOOP has new CREATE_HYBRID_PARTNED_TABLE and USER_PRIVILEGED objects DBMS_HADOOP 01-Mar-2019
DBMS_HADOOP_INTERNAL has 3 objects removed and 13 new objects DBMS_HADOOP_INTERNAL 01-Mar-2019
DBMS_HS_PARALLEL.TABLE_SAMPLING relocated from DBMS_HS_PARALLEL_METADATA DBMS_HS_PARALLEL 20-Mar-2019
DBMS_HS_PARALLEL_METADATA.ABLE_SAMPLING > DBMS_HS_PARALLEL_METADATA DBMS_HS_PARALLEL_METADATA 20-Mar-2019
DBMS_INMEMORY_ADMIN has 6 new objects DBMS_INMEMORY_ADMIN 24-Feb-2019
DBMS_IR.UPDATEFEASABILITYANDIMPACT removed DBMS_IR 11-Mar-2019
DBMS_JSON has new GEOJSON function DBMS_JSON 11-Mar-2019
DBMS_LOGMNR has new INIT_REPLICATION_METADATA and PROFILE procedures DBMS_LOGMNR 27-Feb-2019
DBMS_MANAGEMENT_BOOTSTRAP has new CLEANUP_DB_REPLAY objects procedure DBMS_MANAGEMENT_BOOTSTRAP 21-Mar-2019
DBMS_MEMOPTIMIZE has 3 new objects DBMS_MEMOPTIMIZE 11-Mar-2019
DBMS_PDB_ALTER_SHARING renamed REMOVE_LINK to SET_SHARING_NONE DBMS_PDB_ALTER_SHARING 25-Feb-2019
DBMS_PDB_APP_CON has a new MOVE_DATA procedure DBMS_PDB_APP_CON 25-Feb-2019
DBMS_PLUGTS removed 12 objects and added 3 new ones DBMS_PLUGTS 28-Feb-2019
DBMS_PREUP has 15 new objects DBMS_PREUP 26-Jul-2019
DBMS_RCVMAN has 8 new objects DBMS_RCVMAN 27-Feb-2019
DBMS_REGISTRY removed the SET_RDBMS_UPGRADED_STATUS procedure DBMS_REGISTRY 18-Mar-2019
DBMS_REGISTRY adds nine new objects DBMS_REGISTRY 18-Mar-2019
DBMS_REGISTRY_SYS removed 9 objects DBMS_REGISTRY_SYS 18-Mar-2019
DBMS_REGISTRY_SYS has new CAPITALIZE_SINGLE_QUOTED and CATCON_QUERY objects DBMS_REGISTRY_SYS 18-Mar-2019
DBMS_SERVICE has new KILL_SESSION and TAG_SESSION objects DBMS_SERVICE 28-Feb-2019
DBMS_SESSION dropped 4 CONNECTION_TEST objects (moved to DBMS_APP_CONT) DBMS_SESSION 17-Mar-2019
DBMS_SESSION added new CURRENT_IS_ROLE_ENABLED and SESSION_IS_ROLE_ENABLED functions DBMS_SESSION 17-Mar-2019
DBMS_SPACE has new GET_COMPRESSSION_RATIO procedure DBMS_SPACE 06-Apr-2019
DBMS_SQLTUNE_UTIL0 removed CHECK_OBJ_PRIV function DBMS_SQLTUNE_UTIL0 11-Mar-2019
DBMS_SQLTUNE_UTIL0 has new CHECK_DV_ACCESS and SET_DB_LINK_TO_PRIM objects DBMS_SQLTUNE_UTIL0 11-Mar-2019
DBMS_SQLTUNE_UTIL1 has 7 new objectsDBMS_SQLTUNE_UTIL1 11-Mar-2019
DBMS_SQLTUNE_UTIL2, RESOLV_EXEC_NAME moved to DBMS_SQLTUNE_UTIL1 DBMS_SQLTUNE_UTIL2 11-Mar-2019
DBMS_STATS has 4 new objects DBMS_STATS 10-Mar-2019
DBMS_STATS_INTERNAL dropped GET_OBJ_ID_FOR_QUALIFIED_NAME DBMS_STATS_INTERNAL 08-Apr-2019
DBMS_STATS_INTERNAL has 28 new objects DBMS_STATS_INTERNAL 08-Apr-2019
DBMS_STREAMS_TABLESPACE_ADM removed PULL_SIMPLE_TABLESPACE and PULL_TABLESPACES objects DBMS_STREAMS_TABLESPACE_ADM 02-Mar-2019
DBMS_SUMMARY has SET_LOGFILE_NAME procedure removed DBMS_SUMMARY 14-Mar-2019
DBMS_UTILITY has new DIRECTORY_HAS_SYMLINK function DBMS_UTILITY 17-Mar-2019
DBMS_WORKLOAD_REPOSITORY has new AWR_IMP and MODIFY_TABLE_SETTINGS objects DBMS_WORKLOAD_REPOSITORY 25-Feb-2019
DBMS_WRR_INTERNAL dropped 3 objects DBMS_WRR_INTERNAL 13-Jul-2019
DBMS_WRR_INTERNAL has new FORMAT_TIME_INTERVAL and PROCESS_SQL_SCHEMA DBMS_WRR_INTERNAL 13-Jul-2019
DBMS_WRR_PROTECTED.SET_PDB_ENABLED has been removed DBMS_WRR_PROTECTED 13-Jul-2019
DBMS_WRR_PROTECTED has 5 new objects DBMS_WRR_PROTECTED 13-Jul-2019
DBMS_XDBZ has 6 objects removed DBMS_XDBZ 03-Mar-2019
DBMS_XPLAN has new COMPARE_PLANS, DISPLAY_SHARD_PLANS, GET_FINAL_PLAN objects DBMS_XPLAN 05-Mar-2019
 
Built-in Packages with New or Removed Overloads
DBMS_APPLY_ADM.SET_KEY_COLUMNS has new 3rd overload DBMS_APPLY_ADM 25-Feb-2019
DBMS_GSM_FIX.VALIDATEDATABASE has a new 3rd overload DBMS_GSM_FIX 20-May-2019
DBMS_RCVMAN has 2 objects newly overloaded and deprecating overload 1 DBMS_RCVMAN 27-Feb-2019
DBMS_SQLTUNE_UTIL0.CBDCON_NAME2ID has new overload DBMS_SQLTUNE_UTIL0 11-Mar-2019
 
Built-in Packages with Parameters Changes
DBMS_GSM_POOLADMIN has new FAILOVER_RESTORE parameter DBMS_GSM_POOLADMIN 17-Mar-2019
DBMS_LOGSTDBY has new parameter CON_ID in SKIP_TRANSACTION and UNSKIP_TRANSACTION DBMS_LOGSTDBY 23-May-2019
DBMS_MVIEW has new SKIP_EXT_DATA parameter DBMS_MVIEW 30-Mar-2019
DBMS_SNAPSHOT has new SKIP_EXT_DATA parameter DBMS_SNAPSHOT 30-Mar-2019
DBMS_SQLPA.REMOTE_PROCESS_SQL has 3 new parameters DBMS_SQLPA 31-Mar-2019
DBMS_STATS has new REALTIME_STATS parameter DBMS_STATS 10-Mar-2019
DBMS_XSTREAM_ADM several objects have new LCRID_VERSION parameter DBMS_XSTREAM_ADM 24-Feb-2019
 
Built-in Packages with new Constants, Exceptions, Types, and other significant changes
DBMS_DBMS_DATA_PUMP has a number of new constants DBMS_ADVISOR 11-Mar-2019
DBMS_ADVISOR has 2 new constants DBMS_DATAPUMP 17-Mar-2019
DBMS_GSM_COMMON has a large number of new constants DBMS_GSM_COMMON 15-Mar-2019
DBMS_GSM_UTILITY has many new constants DBMS_GSM_UTILITY 20-May-2019
DBMS_HANG_MANAGER has new RESOLUTION_SCOPE_NODE constant DBMS_HANG_MANAGER 01-Mar-2019
DBMS_PDB has three new constants and V_FEAT_MAX revalued to 38 DBMS_PDB 04-Mar-2019
DBMS_RCVMAN has new and modified PL/SQL types and constants DBMS_RCVMAN 27-Feb-2019
DBMS_REGISTRY has 4 new constants new values for previously existing constants DBMS_REGISTRY 18-Mar-2019
DBMS_RESOURCE_MANAGER drops 8 constants DBMS_RESOURCE_MANAGER 11-Mar-2019
DBMS_SERVER_ALERT has 11 new constants DBMS_SERVER_ALERT 05-Apr-2019
DBMS_SERVICE has many new constants DBMS_SERVICE 28-Feb-2019
DBMS_SESSION dropped 3 CONNECTION_TEST related constants (moved to DBMS_APP_CONT) DBMS_SESSION 17-Mar-2019
DBMS_SPACE has new VERIFY_SHRINK and OBJECT_SPACE_USAGE types DBMS_SPACE 06-Apr-2019
DBMS_SQLTUNE_UTIL1 has many new constants DBMS_SQLTUNE_UTIL1 11-Mar-2019
DBMS_SQLTUNE_UTIL2 has 5 new constants DBMS_SQLTUNE_UTIL2 11-Mar-2019
DBMS_SQL_TRANSLATOR has new ATTR_LOG_ERRORS constant DBMS_SQL_TRANSLATOR 11-Apr-2019
DBMS_STANDARD has new ORA_MAX_NAME_LEN constant DBMS_STANDARD 10-Apr-2019
DBMS_STATS,GET_COLUMN_STATS has new REALTIME_STATS parameter DBMS_STATS 10-Mar-2019
DBMS_TSDP_PROTECT has 2 new and 2 renamed constants DBMS_TSDP_PROTEC 08-Apr-2019
DBMS_UTILITY has new QUOTED_NAME_ARRAY data type and 2 new DIRECTORY_HAS_SYMLINK constants DBMS_UTILITY 17-Mar-2019
DBMS_XSTREAM_ADM has a new CLEAR_KEY_COLUMNS constant DBMS_XSTREAM_ADM 24-Feb-2019
ODCICONST has new CompReferencedCol constant ODCICONST 25-Feb-2019
 
Related Topics
New in 11.2
New in 12.1
New in 12.2
New in 18c
New in 20c
New in 21c
  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
  DBSecWorx