• 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

  • DRCP_DEDICATED_OPT

  • ENABLE_PER_PDB_DRCP

  • HEARTBEAT_BATCH_SIZE

  • MANDATORY_USER_PROFILE

  • MAX_AUTH_SERVERS

  • MIN_AUTH_SERVERS

  • OPTIMIZER_CAPTURE_SQL_QUARANTINE

  • 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_SCHEDULE_CONTROL

  • 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

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

The following features are desupported in Oracle Database 21c:

• The REMOTE_OS_AUTHENT initialization parameter

• The SEC_CASE_SENSITIVE_LOGON initialization parameter

• The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter