Changes in This Release for Oracle Database Reference

This preface lists changes in Oracle Database Reference:

• Changes in Oracle Database Release 19c, Version 19.22

• Changes in Oracle Database Release 19c, Version 19.16

• Changes in Oracle Database Release 19c, Version 19.13

• Changes in Oracle Database Release 19c, Version 19.11

• Changes in Oracle Database Release 19c, Version 19.10

• Changes in Oracle Database Release 19c, Version 19.6

• Changes in Oracle Database Release 19c, Version 19.4

• Changes in Oracle Database Release 19c, Version 19.1

• Changes in Oracle Database Release 18c, Version 18.1

Changes in Oracle Database Release 19c, Version 19.22

The value of the PRE_PAGE_SGA initialization parameter 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 Release 19c, Version 19.16

The following initialization parameters are new in Oracle Database release 19c, version 19.16:

• IDENTITY_PROVIDER_CONFIG

• IDENTITY_PROVIDER_TYPE

• TABLESPACE_ENCRYPTION

Changes in Oracle Database Release 19c, Version 19.13

New AE Analytic Views

Oracle Database release 19c, version 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 Release 19c, Version 19.11

The following initialization parameter is new in Oracle Database release 19c, version 19.11:

• DRCP_DEDICATED_OPT

The following static data dictionary views are new in Oracle Database release 19c, version 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 Release 19c, Version 19.10

The following initialization parameters are new in Oracle Database release 19c, version 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 release 19c, version 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 Release 19c, Version 19.6

The following initialization parameter is new in Oracle Database release 19c, version 19.6:

• OPTIMIZER_SESSION_TYPE

Changes in Oracle Database Release 19c, Version 19.4

The following initialization parameter is new in Oracle Database release 19c, version 19.4:

• IGNORE_SESSION_SET_PARAM_ERRORS

Changes in Oracle Database Release 19c, Version 19.1

This section lists changes in Oracle Database Reference for Oracle Database release 19c, version 19.1.

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 release 19c, version 19.1.

The following initialization parameters are new in Oracle Database release 19c, version 19.1:

• 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 release 19c, version 19.1:

• 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 release 19c, version 19.1:

• 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 release 19c, version 19.1, and may be desupported in a future release:

• The CLUSTER_DATABASE_INSTANCES initialization parameter

• The SERVICE_NAMES initialization parameter

Desupported Features

The following features are desupported in Oracle Database release 19c, version 19.1:

• 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

See Also:

Oracle Database Upgrade Guide

Changes in Oracle Database Release 18c, Version 18.1

This section lists changes in Oracle Database Reference for Oracle Database release 18c, version 18.1.

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

New Features

This section lists describes new features in this manual for Oracle Database release 18c, version 18.1.

The following initialization parameters are new in Oracle Database release 18c, version 18.1:

• ADG_ACCOUNT_INFO_TRACKING

• FORWARD_LISTENER

• INMEMORY_AUTOMATIC_LEVEL

• INMEMORY_OPTIMIZED_ARITHMETIC

• MEMOPTIMIZE_POOL_SIZE

• MULTISHARD_QUERY_DATA_CONSISTENCY

• OPTIMIZER_IGNORE_HINTS

• OPTIMIZER_IGNORE_PARALLEL_HINTS

• PARALLEL_MIN_DEGREE

• PRIVATE_TEMP_TABLE_PREFIX

• STANDBY_PDB_SOURCE_FILE_DBLINK

• STANDBY_PDB_SOURCE_FILE_DIRECTORY

• TDE_CONFIGURATION

• UNIFIED_AUDIT_SYSTEMLOG

• WALLET_ROOT

See Also:

Initialization Parameters for more information about these initialization parameters

The following static data dictionary views are new in Oracle Database release 18c, version 18.1:

• ALL_JSON_DATAGUIDE_FIELDS, DBA_JSON_DATAGUIDE_FIELDS, and USER_JSON_DATAGUIDE_FIELDS

• ALL_MINING_ALGORITHMS

• DBA_CONNECTION_TESTS

• DBA_HIST_PROCESS_WAITTIME

• DBA_INMEMORY_AIMTASKDETAILS

• DBA_INMEMORY_AIMTASKS

• DBA_PDB_SNAPSHOTS

• DBA_PRIVATE_TEMP_TABLES and USER_PRIVATE_TEMP_TABLES

• DBA_WORKLOAD_DIV_SUMMARY

• DICTIONARY_CREDENTIALS_ENCRYPT

See Also:

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

The following dynamic performance views are new in Oracle Database release 18c, version 18.1:

• GV$AQ_IPC_ACTIVE_MSGS and V$AQ_IPC_ACTIVE_MSGS

• GV$AQ_IPC_MSG_STATS and V$AQ_IPC_MSG_STATS

• GV$AQ_IPC_PENDING_MSGS and V$AQ_IPC_PENDING_MSGS

• GV$ASM_DBCLONE_INFO and V$ASM_DBCLONE_INFO

• GV$LOCKDOWN_RULES and V$LOCKDOWN_RULES

• GV$QUARANTINE_SUMMARY and V$QUARANTINE_SUMMARY

• GV$SQL_SHARD and V$SQL_SHARD

See Also:

Dynamic Performance Views for more information about these dynamic performance views.

Deprecated Features

The following features are deprecated in Oracle Database release 18c, version 18.1, and may be desupported in a future release.

• The MAX_CONNECTIONS attribute of the LOG_ARCHIVE_DEST_n initialization parameter, for Oracle Data Guard redo transport

Desupported Features

The following features are desupported in Oracle Database release 18c, version 18.1:

• The STANDBY_ARCHIVE_DEST initialization parameter

• The UTL_FILE_DIR initialization parameter