1 Changes in Oracle Database Reference for Oracle Database 20c

This chapter lists the following changes in Oracle Database Reference for Oracle Database 20c:

1.1 New Features

See Also:

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

1.2 Deprecated Features

The following features are deprecated in Oracle Database 20c, 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.3 Desupported Features

The following feature is desupported in Oracle Database 20c:

  • The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter

See Also:

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