GotoDBA Features,Infrastructure 19.6 vs. 20.2 Data Dictionary Changes

19.6 vs. 20.2 Data Dictionary Changes

In this post I’ll show what’s new in 20.2 Data Dictionary. To see comparison between other versions, check this post.

Interesting additions are:

  • Blockchain tables
  • SQL macros
  • Some details related to sharding

20.2 New DBA Views

DBA_ANALYTIC_VIEW_AGGR_DIMS
DBA_ANALYTIC_VIEW_AGGR_FNS
DBA_ANALYTIC_VIEW_FACT_COLS
DBA_AUTOSQLSET_ATTRNAME
DBA_AUTOSQLSET_OPTENV
DBA_AUTOSQLSET_SNAPSHOT
DBA_AUTOSQLSET_SNAPSHOT_ERROR
DBA_AUTOSQLSET_SQLPLAN
DBA_AUTOSQLSET_SQLSTAT
DBA_AUTOSQLSET_SQLTEXT
DBA_AUTOTASK_SETTINGS
DBA_AW_OBJ
DBA_AW_PROP
DBA_BLOCKCHAIN_TABLES
DBA_CERTIFICATES
DBA_CONSENSUS_CONFIG_CHANGES
DBA_CONSENSUS_LOGS
DBA_CONSENSUS_PEERS
DBA_DV_STATUS
DBA_JAVA_ARGUMENTS
DBA_JAVA_CLASSES
DBA_JAVA_COMPILER_OPTIONS
DBA_JAVA_DERIVATIONS
DBA_JAVA_FIELDS
DBA_JAVA_IMPLEMENTS
DBA_JAVA_INNERS
DBA_JAVA_LAYOUTS
DBA_JAVA_METHODS
DBA_JAVA_NCOMPS
DBA_JAVA_POLICY
DBA_JAVA_RESOLVERS
DBA_JAVA_THROWS
DBA_LOGSTDBY_SUPPORT_MODE
DBA_OGG_AUTO_CAPTURED_TABLES
DBA_QUEUE_SHARDS
DBA_ROLLING_SUPPORT_MODE
DBA_SUBSCR_DUR_REGISTRATIONS
DBA_TAB_COL_STAT_MODELS
DBA_WORKLOAD_REPLAY_IFSLA
DBA_ZONEMAP_AUTO_ACTIONS
DBA_ZONEMAP_AUTO_FINDINGS

20.2 New V$ Views

V_$AQ_DEQUEUE_SESSIONS
V_$AUTHPOOL_STATS
V_$COMPATIBILITY_REQUIREMENT
V_$CONSENSUS_CLIENTS
V_$CONSENSUS_LOGS
V_$CONTAINER_TOPOLOGY
V_$CON_WAITCLASSMETRIC
V_$CON_WAITCLASSMETRIC_HISTORY
V_$DG_BROKER_PROPERTY
V_$DG_BROKER_PROPERTY_INT
V_$DIAG_SESS_USER_TRACE_RECORDS
V_$DIAG_USER_TRACE_RECORDS
V_$FOREIGN_DATAFILE_COPY
V_$GCS_LOCK_STATE_RESOLUTION_HISTORY
V_$LCR_CACHE
V_$LREG_UPDSTAT
V_$MDX_CURSORS
V_$MDX_CURSOR_DEPENDENCY
V_$PMEM_FILESTORE
V_$QUERY_BLOCK_ORIGIN
V_$RESULT_SUBCACHE_STATISTICS
V_$SECUREFILE_SHRINK

20.2 New Dictionary Column

DBA_ADVISOR_OBJECTS.ATTR22
DBA_ADVISOR_OBJECTS.ATTR21
DBA_ANALYTIC_VIEWS.IS_REMOTE
DBA_ANALYTIC_VIEWS.DEFAULT_AGGR_GROUP_NAME
DBA_ANALYTIC_VIEWS.QUERY_TRANSFORM_RELY
DBA_ANALYTIC_VIEWS.QUERY_TRANSFORM_ENABLED
DBA_ANALYTIC_VIEW_BASE_MEAS.AGGR_GROUP_NAME
DBA_ANALYTIC_VIEW_LVLGRPS.MAT_TABLE_NAME
DBA_ANALYTIC_VIEW_LVLGRPS.MAT_TABLE_OWNER
DBA_APP_VERSIONS.APP_ROOT_CLONE_NAME
DBA_ATTRIBUTE_DIMENSIONS.CACHE_STAR
DBA_ATTRIBUTE_DIMENSIONS.MAT_TABLE_OWNER
DBA_ATTRIBUTE_DIMENSIONS.MAT_TABLE_NAME
DBA_ATTRIBUTE_DIM_TABLES.IS_REMOTE
DBA_AUTOTASK_SCHEDULE_CONTROL.INSTANCE_NUMBER
DBA_AUTOTASK_SCHEDULE_CONTROL.LAST_EXEC_INSTNUM
DBA_DB_LINKS.CREDENTIAL_NAME
DBA_DB_LINKS.CREDENTIAL_OWNER
DBA_GG_AUTO_CDR_TABLES.ROW_RESOLUTION_METHOD
DBA_GG_AUTO_CDR_TABLES.KEY_VERSION_COLUMN
DBA_GG_AUTO_CDR_TABLES.IGNORE_SITE_PRIORITY
DBA_GG_AUTO_CDR_TABLES.DELETE_ALWAYS_WINS
DBA_GOLDENGATE_SUPPORT_MODE.EXPLANATION
DBA_HIST_INST_CACHE_TRANSFER.CR_RDMA
DBA_HIST_INST_CACHE_TRANSFER.CURRENT_RDMA_TIME
DBA_HIST_INST_CACHE_TRANSFER.CURRENT_RDMA
DBA_HIST_INST_CACHE_TRANSFER.CR_RDMA_TIME
DBA_INVALID_OBJECTS.IMPORTED_OBJECT
DBA_JSON_COLSTORAGE_STATS.JSON
DBA_LOBS.VALUE_BASED
DBA_LOBS.MAX_INLINE
DBA_LOB_PARTITIONS.MAX_INLINE
DBA_LOB_SUBPARTITIONS.MAX_INLINE
DBA_LOGSTDBY_UNSUPPORTED_TABLE.EXPLANATION
DBA_OBJECTS.IMPORTED_OBJECT
DBA_OBJECTS_AE.IMPORTED_OBJECT
DBA_PDBS.LAST_REFRESH_TIME
DBA_PROCEDURES.SQL_MACRO
DBA_PROCEDURES.BLOCKCHAIN_MANDATORY_VOTES
DBA_PROCEDURES.BLOCKCHAIN
DBA_TABLES.EXTERNALLY_DUPLICATED
DBA_TABLES.EXTERNALLY_SHARDED
DBA_USERS.EXTERNAL_SHARD
DBA_WORKLOAD_CAPTURES.STORAGE_TYPE
DBA_WORKLOAD_CAPTURES.PATCH_NAME
DBA_WORKLOAD_CAPTURES.ENCRYPTION_VERIFIER
DBA_WORKLOAD_DIV_SUMMARY.INSTANCE_NUMBER
DBA_WORKLOAD_DIV_SUMMARY.WRC_ID
DBA_WORKLOAD_DIV_SUMMARY.IS_CLIENT_FAILURE
DBA_WORKLOAD_REPLAYS.PATCH_NAME
DBA_WORKLOAD_REPLAYS.PDB_LEVEL
DBA_WORKLOAD_REPLAYS.NUM_CLIENTS_ABORTED
DBA_WORKLOAD_REPLAY_DIVERGENCE.INSTANCE_NUMBER
DBA_WORKLOAD_REPLAY_DIVERGENCE.WRC_ID
DBA_WORKLOAD_REPLAY_DIVERGENCE.IS_CLIENT_FAILURE
DBA_WORKLOAD_SCHEDULE_CAPTURES.NUM_CLIENTS_ABORTED
DBA_XSTREAM_OUT_SUPPORT_MODE.EXPLANATION
DBA_XTERNAL_TAB_PARTITIONS.INMEMORY_COMPRESSION
DBA_XTERNAL_TAB_PARTITIONS.INMEMORY
DBA_XTERNAL_TAB_PARTITIONS.PROPERTY
DBA_ZONEMAPS.AUTOMATIC
DBA_ZONEMAPS.INCOMPLETE
DBA_ZONEMAPS.PARTLY_STALE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_11_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_21_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_16_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_18_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_25_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_20_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_20_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_23_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_27_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_18_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_29_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_21_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_26_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_29_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_26_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_17_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_25_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_24_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_19_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_22_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_28_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_12_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_27_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_13_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_20_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_13_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_22_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_11_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_16_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_28_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_22_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_11_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_16_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_17_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_24_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_17_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_30_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_23_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_21_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_19_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_15_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_25_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_28_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_14_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_13_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_24_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_26_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_15_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_19_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_30_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_30_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_14_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_14_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_18_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_12_TYPE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_23_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_12_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_15_ID
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_27_VALUE
V_$ALL_SQL_PLAN_MONITOR.OTHERSTAT_29_VALUE
V_$AQ_MESSAGE_CACHE_STAT.NUM_PRERELOADED
V_$AQ_MESSAGE_CACHE_STAT.AVG_RELOAD_TIME
V_$AQ_MESSAGE_CACHE_STAT.NUM_FG_RELOADED
V_$AQ_SHARDED_SUBSCRIBER_STAT.MSG_SN
V_$AQ_SHARDED_SUBSCRIBER_STAT.DEQUEUE_POSITION
V_$ASM_AUDIT_CLEANUP_JOBS.USE_TIMESTAMP
V_$BACKUP_REDOLOG.SECTION_SIZE
V_$CHANNEL_WAITS.ADDR
V_$CON_SYSTEM_EVENT.CPU
V_$CON_SYSTEM_EVENT.CPU_FG
V_$CON_SYSTEM_WAIT_CLASS.TIME_WAITED_MICRO_FG
V_$CON_SYSTEM_WAIT_CLASS.CPU_FG
V_$CON_SYSTEM_WAIT_CLASS.CPU
V_$CON_SYSTEM_WAIT_CLASS.TIME_WAITED_MICRO
V_$DATABASE.GOLDENGATE_BLOCKING_MODE
V_$FS_FAILOVER_OBSERVERS.LOG_FILE
V_$FS_FAILOVER_OBSERVERS.STATE_FILE
V_$HANG_INFO.VICTIM_PDB_ID
V_$HANG_INFO.HANG_STATUS
V_$HANG_SESSION_INFO.WAIT_TIME
V_$HANG_SESSION_INFO.PDB_ID
V_$IM_COL_CU.ULEVEL
V_$INSTANCE_CACHE_TRANSFER.CURRENT_RDMA
V_$INSTANCE_CACHE_TRANSFER.CR_RDMA_TIME
V_$INSTANCE_CACHE_TRANSFER.CURRENT_RDMA_TIME
V_$INSTANCE_CACHE_TRANSFER.CR_RDMA
V_$KEY_VECTOR.COMPRESSED_SIZE
V_$KEY_VECTOR.OFFLOADED
V_$KEY_VECTOR.EFILTER_SIZE
V_$PASSWORDFILE_INFO.IS_EXC
V_$PDBS.RECOVERY_TARGET_PDB_INCARNATION#
V_$PROCESS_MEMORY_DETAIL.SQL_ID
V_$PROCESS_MEMORY_DETAIL.MOST_RECENT
V_$PROCESS_MEMORY_DETAIL.TOTAL_MB
V_$PROCESS_MEMORY_DETAIL.TIMESTAMP
V_$PWFILE_USERS.PASSWORD_VERSIONS
V_$RESULT_CACHE_MEMORY.SUBCACHE_ID
V_$RESULT_CACHE_OBJECTS.GLOBAL
V_$RESULT_CACHE_OBJECTS.SUBCACHE_ID
V_$SERVICE_EVENT.CPU
V_$SERVICE_WAIT_CLASS.TIME_WAITED_MICRO
V_$SERVICE_WAIT_CLASS.CPU
V_$SESSION_EVENT.CPU
V_$SESSION_WAIT_CLASS.CPU
V_$SESSION_WAIT_CLASS.TIME_WAITED_MICRO
V_$SQL_PLAN_MONITOR.OTHERSTAT_26_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_12_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_22_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_25_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_18_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_13_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_14_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_24_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_11_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_29_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_30_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_21_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_27_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_26_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_11_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_17_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_28_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_20_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_23_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_14_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_16_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_21_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_22_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_28_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_18_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_20_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_12_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_20_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_14_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_16_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_28_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_25_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_11_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_21_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_15_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_29_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_24_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_12_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_27_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_13_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_17_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_19_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_19_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_27_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_15_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_23_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_26_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_25_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_23_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_24_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_30_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_17_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_30_ID
V_$SQL_PLAN_MONITOR.OTHERSTAT_15_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_16_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_13_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_18_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_22_VALUE
V_$SQL_PLAN_MONITOR.OTHERSTAT_19_TYPE
V_$SQL_PLAN_MONITOR.OTHERSTAT_29_ID
V_$SYSTEM_EVENT.CPU
V_$SYSTEM_EVENT.CPU_FG
V_$SYSTEM_WAIT_CLASS.TIME_WAITED_MICRO
V_$SYSTEM_WAIT_CLASS.CPU_FG
V_$SYSTEM_WAIT_CLASS.TIME_WAITED_MICRO_FG
V_$SYSTEM_WAIT_CLASS.CPU
V_$UNIFIED_AUDIT_TRAIL.OBJECT_TYPE
V_$UNIFIED_AUDIT_TRAIL.DB_UNIQUE_NAME
V_$UNIFIED_AUDIT_TRAIL.DP_WARNINGS1

2 thoughts on “19.6 vs. 20.2 Data Dictionary Changes”

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post