Changes in This Release for Oracle Database Reference

Changes in Oracle Database 19c, Release Update 19.29

The following initialization parameter is new in Oracle Database 19c, Release Update 19.29:

HEARTBEAT_BATCH_SIZE

Changes in Oracle Database 19c, Release Update 19.28

The following initialization parameters are new in Oracle Database 19c, Release Update 19.28:

The following static data dictionary views are new in Oracle Database 19c, Release Update 19.28:

Changes in Oracle Database 19c, Release Update 19.26

The following initialization parameter is changed in Oracle Database 19c, Release Update 19.26:

A new AUTO setting is available for the DB_LOST_WRITE_PROTECT parameter and it is the default setting.

Changes in Oracle Database 19c, Release Update 19.23

The following initialization parameter is new in Oracle Database 19c, Release Update 19.23:

SESSION_EXIT_ON_PACKAGE_STATE_ERROR

Changes in Oracle Database 19c, Release Update 19.22

The following initialization parameter is new in Oracle Database 19c, Release Update 19.22:

OGG_ONLINE_DDL

The following initialization parameter is changed in Oracle Database 19c, Release Update 19.22:

The PRE_PAGE_SGA initialization parameter is deprecated. The value of PRE_PAGE_SGA is always set to TRUE on Exadata systems. Any attempt to set this parameter to FALSE on an Exadata system will not take effect.

Changes in Oracle Database 19c, Release Update 19.21

The following initialization parameter is new in Oracle Database 19c, Release Update 19.21:

MAIN_WORKLOAD_TYPE

Changes in Oracle Database 19c, Release Update 19.16

The following initialization parameters are new in Oracle Database 19c, Release Update 19.16:

Changes in Oracle Database 19c, Release Update 19.13

New AE Analytic Views

Oracle Database 19c, Release Update 19.13, introduces AE ("all edition") analytic views. Each new AE analytic view corresponds to an existing non-AE analytic view. AE views have the same columns as their non-AE counterparts, plus a column that displays the name of the application edition where the editioned object is defined.

The following table lists the new AE analytic views, divided into three categories: analytic view views, attribute dimension views, and hierarchy views. For brevity, only the ALL_ views are listed. The corresponding DBA_ and USER_ views are also available and are documented in this guide.

Analytic View Views	Attribute Dimension Views	Hierarchy Views
ALL_ANALYTIC_VIEW_ATTR_CLS_AE ALL_ANALYTIC_VIEW_BAS_MEAS_AE ALL_ANALYTIC_VIEW_CLASS_AE ALL_ANALYTIC_VIEW_CLC_MEAS_AE ALL_ANALYTIC_VIEW_COLUMNS_AE ALL_ANALYTIC_VIEW_DIM_CLS_AE ALL_ANALYTIC_VIEW_DIMS_AE ALL_ANALYTIC_VIEW_HIER_CLS_AE ALL_ANALYTIC_VIEW_HIERS_AE ALL_ANALYTIC_VIEW_KEYS_AE ALL_ANALYTIC_VIEW_LEVELS_AE ALL_ANALYTIC_VIEW_LVL_CLS_AE ALL_ANALYTIC_VIEW_LVLGRPS_AE ALL_ANALYTIC_VIEW_MEAS_CLS_AE ALL_ANALYTIC_VIEWS_AE	ALL_ATTRIBUTE_DIM_ATTR_CLS_AE ALL_ATTRIBUTE_DIM_ATTRS_AE ALL_ATTRIBUTE_DIM_CLASS_AE ALL_ATTRIBUTE_DIM_JN_PTHS_AE ALL_ATTRIBUTE_DIM_KEYS_AE ALL_ATTRIBUTE_DIM_LEVELS_AE ALL_ATTRIBUTE_DIM_LVL_ATRS_AE ALL_ATTRIBUTE_DIM_LVL_CLS_AE ALL_ATTRIBUTE_DIM_ORD_ATRS_AE ALL_ATTRIBUTE_DIM_TABLES_AE ALL_ATTRIBUTE_DIMENSIONS_AE	ALL_HIER_CLASS_AE ALL_HIER_COLUMNS_AE ALL_HIER_HIER_ATTR_CLASS_AE ALL_HIER_HIER_ATTRIBUTES_AE ALL_HIER_JOIN_PATHS_AE ALL_HIER_LEVEL_ID_ATTRS_AE ALL_HIER_LEVELS_AE ALL_HIERARCHIES_AE

Changes in Oracle Database 19c, Release Update 19.11

The following initialization parameter is new in Oracle Database 19c, Release Update 19.11:

DRCP_DEDICATED_OPT

The following static data dictionary views are new in Oracle Database 19c, Release Update 19.11:

Changes in Oracle Database 19c, Release Update 19.10

The following initialization parameters are new in Oracle Database 19c, Release Update 19.10:

The following static data dictionary views are new in Oracle Database 19c, Release Update 19.10:

Changes in Oracle Database 19c, Release Update 19.6

The following initialization parameter is new in Oracle Database 19c, Release Update 19.6:

OPTIMIZER_SESSION_TYPE

Changes in Oracle Database 19c, Release Update 19.4

The following initialization parameter is new in Oracle Database 19c, Release Update 19.4:

IGNORE_SESSION_SET_PARAM_ERRORS

Changes in Oracle Database 19c

This section lists changes in Oracle Database Reference for Oracle Database 19c.

See Oracle Database New Features Guide for a complete list of new features for this release.

New Features

This section lists new features in this manual for Oracle Database 19c.

The following changes to initialization parameters are new in Oracle Database 19c:

On Linux platforms only, Oracle recommends against explicitly setting values for MEMORY_TARGET and MEMORY_MAX_TARGET in the initialization parameter file at the time of instance startup. Doing so may result in suboptimal small page allocation in the SGA. Furthermore, if the USE_LARGE_PAGES parameter is set to ONLY and you attempt to set values for MEMORY_TARGET and MEMORY_MAX_TARGET, the instance will fail to start.

See MEMORY_TARGET, MEMORY_MAX_TARGET, and USE_LARGE_PAGES.

The following initialization parameters are new in Oracle Database 19c:

Note:

See Initialization Parameters for more information about these initialization parameters.

The following static data dictionary views are new in Oracle Database 19c:

Note:

Static Data Dictionary Views for more information about these static data dictionary views

The following dynamic performance views are new in Oracle Database 19c:

GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS
GV$ASM_ACFSAUTORESIZE and V$ASM_ACFSAUTORESIZE
GV$MEMOPTIMIZE_WRITE_AREA and V$MEMOPTIMIZE_WRITE_AREA
GV$SHARED_SERVER_STAT and V$SHARED_SERVER_STAT
GV$SQL_TESTCASES and V$SQL_TESTCASES

Note:

GV$ Views and Dynamic Performance Views for more information about these dynamic performance views

Deprecated Features

The following features are deprecated in Oracle Database 19c, and may be desupported in a future release:

The CLUSTER_DATABASE_INSTANCES initialization parameter
The PRE_PAGE_SGA initialization parameter (starting with Oracle Database 19c, Release Update 19.22)
The SERVICE_NAMES initialization parameter

Desupported Features

The following features are desupported in Oracle Database 19c:

The MAX_CONNECTIONS attribute of the LOG_ARCHIVE_DEST_n initialization parameter, for Oracle Data Guard redo transport
The EXAFUSION_ENABLED initialization parameter
The O7_DICTIONARY_ACCESSIBILITY initialization parameter
Oracle Streams is desupported. As a result, the following views are desupported:
- ALL_STREAMS_COLUMNS
- ALL_STREAMS_MESSAGE_RULES
- ALL_STREAMS_RULES
- ALL_STREAMS_UNSUPPORTED
- DBA_STREAMS_ADMINISTRATOR
- DBA_STREAMS_COLUMNS
- DBA_STREAMS_MESSAGE_RULES
- DBA_STREAMS_RULES
- DBA_STREAMS_SPLIT_MERGE
- DBA_STREAMS_SPLIT_MERGE_HIST
- DBA_STREAMS_STMTS
- DBA_STREAMS_STMT_HANDLERS
- DBA_STREAMS_TRANSFORMATIONS
- DBA_STREAMS_UNSUPPORTED
- V$STREAMS_CAPTURE
- V$STREAMS_MESSAGE_TRACKING
- V$STREAMS_TRANSACTION
Extended Datatype Support (EDS) is desupported. As a result, the following views are desupported:
- DBA_LOGSTDBY_EDS_SUPPORTED
- DBA_LOGSTDBY_EDS_TABLES