New In Oracle Database
Version 19.3

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 Initialization Parameters
  • TBD
Deprecated Initialization Parameters

  • CLUSTER_DATABASE_INSTANCES
Startup Parameters 26-Feb-2019
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
TBD   23-Feb-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
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)in 19.1 DBMS_APP_CONT 30-Jun-2019
DBMS_AUTO_TASK_ADMIN has new MODIFY_AUTOTASK_SETTINGS procedure DBMS_AUTO_TASK_ADMIN 26-Feb-2019
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 has new TABLE_SAMPLING relocated from DBMS_HS_PARALLEL_METADATA DBMS_HS_PARALLEL 20-Mar-2019
DBMS_HS_PARALLEL_METADATA TABLE_SAMPLING relocated toDBMS_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_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 has 3 newnew 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 constants for the DIRECTORY_HAS_SYMLINK function 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 18.3
  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