1 Changes in This Release for Oracle Database Reference

This chapter lists changes in Oracle Database Reference:

• Changes in Oracle Database Release 21c, Version 21.5

• Changes in Oracle Database Release 21c

1.1 Changes in Oracle Database Release 21c, Version 21.5

New AE Analytic Views

Oracle Database release 21c, version 21.5, 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_ATRS_AE ALL_ANALYTIC_VIEW_DIM_CLS_AE ALL_ANALYTIC_VIEW_DIMS_AE ALL_ANALYTIC_VIEW_FCT_COLS_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

1.2 Changes in Oracle Database Release 21c

This section lists the following changes in Oracle Database Reference for Oracle Database 21c:

• New Features

• Deprecated Features

• Desupported Features

1.2.1 New Features

• The following feature is new in Oracle Database 21c:

  • You can specify an expression as the value for initialization parameters of type integer and big integer. See "Using Expressions for Parameter Values."

• The following initialization parameters are new in Oracle Database 21c:

  • BLOCKCHAIN_TABLE_MAX_NO_DROP

  • DBNEST_ENABLE

  • DBNEST_PDB_FS_CONF

  • DIAGNOSTICS_CONTROL

  • ENABLE_PER_PDB_DRCP

  • HEARTBEAT_BATCH_SIZE

  • MANDATORY_USER_PROFILE

  • OPTIMIZER_CAPTURE_SQL_QUARANTINE

  • OPTIMIZER_CROSS_SHARD_RESILIENCY

  • OPTIMIZER_USE_SQL_QUARANTINE

  • PMEM_FILESTORE

  • RESULT_CACHE_EXECUTION_THRESHOLD

  • RESULT_CACHE_MAX_TEMP_RESULT

  • RESULT_CACHE_MAX_TEMP_SIZE

  • TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM

  • TDE_KEY_CACHE

  • TIMEZONE_VERSION_UPGRADE_ONLINE

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

  • DBA_ACCHK_EVENTS

  • DBA_ACCHK_EVENTS_SUMMARY

  • DBA_ACCHK_STATISTICS

  • DBA_ACCHK_STATISTICS_SUMMARY

  • DBA_ACTIVITY_CONFIG

  • DBA_ACTIVITY_MVIEW

  • DBA_ACTIVITY_SNAPSHOT_META

  • DBA_ACTIVITY_TABLE

  • ALL_ANALYTIC_VIEW_DIM_ATTRS, DBA_ANALYTIC_VIEW_DIM_ATTRS, and USER_ANALYTIC_VIEW_DIM_ATTRS
  • ALL_ANALYTIC_VIEW_FACT_COLS, DBA_ANALYTIC_VIEW_FACT_COLS, and USER_ANALYTIC_VIEW_FACT_COLS

  • DBA_APP_ERRORS_HISTORY

  • USER_APPLICATION_ROLES

  • DBA_AUTO_MV_ANALYSIS_ACTIONS

  • DBA_AUTO_MV_ANALYSIS_EXECUTIONS

  • DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS

  • DBA_AUTO_MV_ANALYSIS_REPORT

  • DBA_AUTO_MV_ANALYSIS_TASK

  • DBA_AUTO_MV_CONFIG

  • DBA_AUTO_MV_MAINT_REPORT

  • DBA_AUTO_MV_REFRESH_HISTORY

  • DBA_AUTO_MV_VERIFICATION_REPORT

  • DBA_AUTO_MV_VERIFICATION_STATUS

  • DBA_AUTO_ZONEMAP_CONFIG

  • DBA_AUTOTASK_SETTINGS

  • ALL_BLOCKCHAIN_TABLES, DBA_BLOCKCHAIN_TABLES, and USER_BLOCKCHAIN_TABLES

  • ALL_CERTIFICATES, DBA_CERTIFICATES, and USER_CERTIFICATES

  • ALL_IMMUTABLE_TABLES, DBA_IMMUTABLE_TABLES, and USER_IMMUTABLE_TABLES

  • DBA_LOGMNR_DICTIONARY_BUILDLOG

  • DBA_LOGSTDBY_SUPPORT_MODE

  • DBA_OGG_AUTO_CAPTURED_TABLES and USER_OGG_AUTO_CAPTURED_TABLES

  • ALL_QUEUE_EVENT_STREAMS, DBA_QUEUE_EVENT_STREAMS, and USER_QUEUE_EVENT_STREAMS

  • DBA_ROLLING_SUPPORT_MODE

  • ALL_TAB_COL_STAT_MODELS, DBA_TAB_COL_STAT_MODELS, and USER_TAB_COL_STAT_MODELS

  • DBA_ZONEMAP_AUTO_ACTIONS

  • DBA_ZONEMAP_AUTO_FINDINGS

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

  • GV$ACTIVITY_MVIEW and V$ACTIVITY_MVIEW

  • GV$ACTIVITY_TABLE and V$ACTIVITY_TABLE

  • GV$AUTHPOOL_STATS and V$AUTHPOOL_STATS

  • GV$EQ_CACHED_PARTITIONS and V$EQ_CACHED_PARTITIONS

  • GV$EQ_CROSS_INSTANCE_JOBS and V$EQ_CROSS_INSTANCE_JOBS

  • GV$EQ_INACTIVE_PARTITIONS and V$EQ_INACTIVE_PARTITIONS

  • GV$EQ_MESSAGE_CACHE and V$EQ_MESSAGE_CACHE

  • GV$EQ_MESSAGE_CACHE_ADVICE and V$EQ_MESSAGE_CACHE_ADVICE

  • GV$EQ_MESSAGE_CACHE_STAT and V$EQ_MESSAGE_CACHE_STAT

  • GV$EQ_NONDUR_SUBSCRIBER and V$EQ_NONDUR_SUBSCRIBER

  • GV$EQ_NONDUR_SUBSCRIBER_LWM and V$EQ_NONDUR_SUBSCRIBER_LWM

  • GV$EQ_PARTITION_STATS and V$EQ_PARTITION_STATS

  • GV$EQ_REMOTE_DEQUEUE_AFFINITY and V$EQ_REMOTE_DEQUEUE_AFFINITY

  • GV$EQ_SUBSCRIBER_LOAD and V$EQ_SUBSCRIBER_LOAD

  • GV$EQ_SUBSCRIBER_STAT and V$EQ_SUBSCRIBER_STAT

  • GV$EQ_UNCACHED_PARTITIONS and V$EQ_UNCACHED_PARTITIONS

  • GV$LCR_CACHE and V$LCR_CACHE

  • GV$PKCS11_PATH and V$PKCS11_PATH

  • GV$PMEM_FILESTORE and V$PMEM_FILESTORE

  • GV$RESULT_SUBCACHE_STATISTICS and V$RESULT_SUBCACHE_STATISTICS

See Also:

Learning Database New Features for a complete list of new features for this release

1.2.2 Deprecated Features

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

• Traditional auditing is deprecated. As a result, the following initialization parameters and views are deprecated:

  • Initialization parameters:

    • AUDIT_FILE_DEST
    • AUDIT_SYS_OPERATIONS
    • AUDIT_SYSLOG_LEVEL
    • AUDIT_TRAIL

  • Static data dictionary views:

    • ALL_DEF_AUDIT_OPTS
    • AUDIT_ACTIONS
    • DBA_AUDIT_EXISTS
    • DBA_AUDIT_OBJECT
    • DBA_AUDIT_SESSION
    • DBA_AUDIT_STATEMENT
    • DBA_AUDIT_TRAIL
    • DBA_COMMON_AUDIT_TRAIL
    • DBA_FGA_AUDIT_TRAIL
    • DBA_OBJ_AUDIT_OPTS
    • DBA_PRIV_AUDIT_OPTS
    • DBA_STMT_AUDIT_OPTS
    • USER_AUDIT_OBJECT
    • USER_AUDIT_SESSION
    • USER_AUDIT_STATEMENT
    • USER_AUDIT_TRAIL
    • USER_OBJ_AUDIT_OPTS

  • Dynamic performance view:

    • V$XML_AUDIT_TRAIL

• AQ sharded queues are deprecated. As a result, the following dynamic performance views are deprecated:

  • V$AQ_CROSS_INSTANCE_JOBS
  • V$AQ_MESSAGE_CACHE
  • V$AQ_MESSAGE_CACHE_ADVICE
  • V$AQ_MESSAGE_CACHE_STAT
  • V$AQ_NONDUR_SUBSCRIBER
  • V$AQ_NONDUR_SUBSCRIBER_LWM
  • V$AQ_PARTITION_STATS
  • V$AQ_REMOTE_DEQUEUE_AFFINITY
  • V$AQ_SHARDED_SUBSCRIBER_STAT
  • V$AQ_SUBSCRIBER_LOAD

See Also:

Oracle Database Upgrade Guide for a complete list of deprecated features for this release

1.2.3 Desupported Features

The following features are desupported in Oracle Database 21c:

• Initialization parameters:

  • CLUSTER_DATABASE_INSTANCES
  • REMOTE_OS_AUTHENT
  • SEC_CASE_SENSITIVE_LOGON
  • UNIFIED_AUDIT_SGA_QUEUE_SIZE

• Dynamic performance views:

  • V$ASM_ACFS_SEC_ADMIN
  • V$ASM_ACFS_SEC_CMDRULE
  • V$ASM_ACFS_SEC_REALM
  • V$ASM_ACFS_SEC_REALM_FILTER
  • V$ASM_ACFS_SEC_REALM_GROUP
  • V$ASM_ACFS_SEC_REALM_USER
  • V$ASM_ACFS_SEC_RULE
  • V$ASM_ACFS_SEC_RULESET
  • V$ASM_ACFS_SEC_RULESET_RULE
  • V$ASM_ACFS_SECURITY_INFO
  • V$OBJECT_USAGE

See Also:

Oracle Database Upgrade Guide for a complete list of desupported features for this release