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 value of the PRE_PAGE_SGA initialization parameter is always set to
true
on Exadata systems. Any attempt to set this parameter tofalse
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_ATTRIBUTE_DIM_ATTR_CLS_AE | ALL_HIER_CLASS_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 SERVICE_NAMES initialization parameter
Desupported Features
The following features are desupported in Oracle Database 19c:
-
The
MAX_CONNECTIONS
attribute of theLOG_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