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
“19.6 New DBA Views” probably should be “20.2 New DBA Views”
Wow, you’re the only one that noticed that.
Fixed, thanks!