Changes in This Release for Oracle Database Reference

This preface lists changes in Oracle Database Reference:

• Changes in Oracle Database 19c, Release Update 19.22

• Changes in Oracle Database 19c, Release Update 19.16

• Changes in Oracle Database 19c, Release Update 19.13

• Changes in Oracle Database 19c, Release Update 19.11

• Changes in Oracle Database 19c, Release Update 19.10

• Changes in Oracle Database 19c, Release Update 19.6

• Changes in Oracle Database 19c, Release Update 19.4

• Changes in Oracle Database 19c

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:

• IDENTITY_PROVIDER_CONFIG

• IDENTITY_PROVIDER_TYPE

• TABLESPACE_ENCRYPTION

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:

• DBA_ACCHK_EVENTS

• DBA_ACCHK_EVENTS_SUMMARY

• DBA_ACCHK_STATISTICS

• DBA_ACCHK_STATISTICS_SUMMARY

• ALL_IMMUTABLE_TABLES, DBA_IMMUTABLE_TABLES, and USER_IMMUTABLE_TABLES

Changes in Oracle Database 19c, Release Update 19.10

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

• BLOCKCHAIN_TABLE_MAX_NO_DROP

• CONTAINER_DATA

• MAX_AUTH_SERVERS

• MIN_AUTH_SERVERS

• OPTIMIZER_REAL_TIME_STATISTICS

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

• ALL_BLOCKCHAIN_TABLES, DBA_BLOCKCHAIN_TABLES, and USER_BLOCKCHAIN_TABLES

• ALL_CERTIFICATES, DBA_CERTIFICATES, and USER_CERTIFICATES

• DBA_LOGMNR_DICTIONARY_BUILDLOG

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 initialization parameters are new in Oracle Database 19c:

• ADG_REDIRECT_DML

• ALLOW_ROWID_COLUMN_TYPE

• CLIENT_STATISTICS_LEVEL

• CPU_MIN_COUNT

• DATA_GUARD_MAX_IO_TIME

• DATA_GUARD_MAX_LONGIO_TIME

• ENABLE_IMC_WITH_MIRA

• LOB_SIGNATURE_ENABLE

• MAX_DATAPUMP_PARALLEL_PER_JOB

• MAX_IDLE_BLOCKER_TIME

• UNIFIED_AUDIT_COMMON_SYSTEMLOG

Note:

See Initialization Parameters for more information about these initialization parameters.

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

• ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE

• DBA_AUTO_INDEX_CONFIG

• DBA_AUTO_STAT_EXECUTIONS

• DBA_PDB_SNAPSHOTFILE

• DBA_RAT_CAPTURE_SCHEMA_INFO

• DBA_REGISTRY_BACKPORTS

• DBA_SQL_QUARANTINE

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

See Also:

Oracle Database Upgrade Guide