In this post I’ll compare the Data Dictionary tables and columns between 12.2.0.1 and 18.9. To see comparison between other versions, check this post.
18.9 New DBA Views
DBA_CONNECTION_TESTS
DBA_GOLDENGATE_CONTAINER_RULES
DBA_HIST_ASM_DISK_STAT_SUMMARY
DBA_HIST_PROCESS_WAITTIME
DBA_INMEMORY_AIMTASKDETAILS
DBA_INMEMORY_AIMTASKS
DBA_JSON_DATAGUIDE_FIELDS
DBA_PDB_SNAPSHOTS
DBA_PRIVATE_TEMP_TABLES
DBA_REGISTRY_BACKPORTS
DBA_REGISTRY_SQLPATCH_RU_INFO
DBA_WORKLOAD_CAPTURE_SQLTEXT
DBA_WORKLOAD_DIV_SUMMARY
DBA_WORKLOAD_LONG_SQLTEXT
18.9 New V$ Views
V_$AQ_IPC_ACTIVE_MSGS
V_$AQ_IPC_MSG_STATS
V_$AQ_IPC_PENDING_MSGS
V_$ASM_AUDIT_LOAD_JOBS
V_$ASM_CACHE_EVENTS
V_$DATABASE_REPLAY_PROGRESS
V_$IMHMSEG
V_$IM_DELTA_HEADER
V_$IM_GLOBALDICT
V_$IM_GLOBALDICT_PIECEMAP
V_$IM_GLOBALDICT_SORTORDER
V_$IM_GLOBALDICT_VERSION
V_$IM_SMU_DELTA
V_$JAVA_PATCHING_STATUS
V_$JAVA_SERVICES
V_$LOCKDOWN_RULES
V_$MEMOPTIMIZE_WRITE_AREA
V_$QUARANTINE_SUMMARY
V_$SQL_SHARD
V_$WLM_PCSERVICE
18.9 New Dictionary Column
DBA_ADVISOR_EXECUTIONS.ACTUAL_DOP
DBA_ADVISOR_EXECUTIONS.CONCURRENT_EXECUTION
DBA_ADVISOR_EXECUTIONS.REQUESTED_DOP
DBA_ADVISOR_SQLSTATS.DIRECT_GETS
DBA_ADVISOR_SQLSTATS.CACHED_GETS
DBA_ADVISOR_SQLSTATS.ATTR3
DBA_ADVISOR_SQLSTATS.ATTR2
DBA_ALL_TABLES.MEMOPTIMIZE_WRITE
DBA_ALL_TABLES.HAS_SENSITIVE_COLUMN
DBA_ALL_TABLES.MEMOPTIMIZE_READ
DBA_ANALYTIC_VIEWS.DYN_ALL_CACHE
DBA_ANALYTIC_VIEW_DIMENSIONS.REFERENCES_DISTINCT
DBA_APP_PATCHES.PATCH_CHECKSUM
DBA_APP_STATEMENTS.VERSION_NUMBER
DBA_APP_STATEMENTS.OPCODE
DBA_APP_STATEMENTS.SESSION_ID
DBA_APP_VERSIONS.APP_VERSION_CHECKSUM
DBA_ARGUMENTS.TYPE_OBJECT_TYPE
DBA_CPOOL_INFO.CON_ID
DBA_DB_LINKS.VALID
DBA_DB_LINKS.SHARD_INTERNAL
DBA_EXTERNAL_TABLES.INMEMORY_COMPRESSION
DBA_EXTERNAL_TABLES.INMEMORY
DBA_HIST_ASM_DISKGROUP_STAT.NUM_FAILGROUP
DBA_HIST_ASM_DISKGROUP_STAT.STATE
DBA_HIST_CELL_DB.IS_CURRENT_SRC_DB
DBA_HIST_CELL_DISKTYPE.CONFVAL
DBA_HIST_DATABASE_INSTANCE.STARTUP_TIME_TZ
DBA_HIST_PDB_INSTANCE.SNAP_ID
DBA_HIST_PDB_INSTANCE.OPEN_TIME_TZ
DBA_HIST_PDB_INSTANCE.STARTUP_TIME_TZ
DBA_HIST_PDB_IN_SNAP.OPEN_TIME_TZ
DBA_HIST_SEG_STAT.REPOPULATE_CUS_TOTAL
DBA_HIST_SEG_STAT.REPOPULATE_CUS_DELTA
DBA_HIST_SEG_STAT.POPULATE_CUS_TOTAL
DBA_HIST_SEG_STAT.POPULATE_CUS_DELTA
DBA_HIST_SEG_STAT.IM_SCANS_DELTA
DBA_HIST_SEG_STAT.IM_DB_BLOCK_CHANGES_TOTAL
DBA_HIST_SEG_STAT.IM_DB_BLOCK_CHANGES_DELTA
DBA_HIST_SEG_STAT.GC_REMOTE_GRANTS_TOTAL
DBA_HIST_SEG_STAT.GC_REMOTE_GRANTS_DELTA
DBA_HIST_SEG_STAT.IM_SCANS_TOTAL
DBA_HIST_SNAPSHOT.END_INTERVAL_TIME_TZ
DBA_HIST_SNAPSHOT.BEGIN_INTERVAL_TIME_TZ
DBA_HIST_SNAP_ERROR.STEP_ID
DBA_HIST_SQLSTAT.OBSOLETE_COUNT
DBA_HIST_WR_CONTROL.SRC_DBNAME
DBA_HIST_WR_CONTROL.SRC_DBID
DBA_IDENTIFIERS.ATTRIBUTE
DBA_IDENTIFIERS.CHARACTER_SET
DBA_IDENTIFIERS.CHAR_USED
DBA_IDENTIFIERS.LENGTH
DBA_IDENTIFIERS.LOWER_RANGE
DBA_IDENTIFIERS.NULL_CONSTRAINT
DBA_IDENTIFIERS.PRECISION
DBA_IDENTIFIERS.PRECISION2
DBA_IDENTIFIERS.SCALE
DBA_IDENTIFIERS.SQL_BUILTIN
DBA_IDENTIFIERS.UPPER_RANGE
DBA_IND_SUBPARTITIONS.DOMIDX_OPSTATUS
DBA_JSON_COLUMNS.OBJECT_TYPE
DBA_LOCKDOWN_PROFILES.USERS
DBA_LOGMNR_SESSION.PURGE_SCN
DBA_MINING_MODELS.ALGORITHM_TYPE
DBA_OBJECT_TABLES.HAS_SENSITIVE_COLUMN
DBA_OBJECT_TABLES.MEMOPTIMIZE_WRITE
DBA_OBJECT_TABLES.MEMOPTIMIZE_READ
DBA_PDBS.LAST_REFRESH_SCN
DBA_PDBS.SNAPSHOT_INTERVAL
DBA_PDBS.SNAPSHOT_MODE
DBA_PDBS.TEMPLATE
DBA_PDBS.TENANT_ID
DBA_PLSQL_COLL_TYPES.CHAR_USED
DBA_PRIV_CAPTURES.RUN_NAME
DBA_PROCEDURES.POLYMORPHIC
DBA_QUEUE_TABLES.REPLICATION_MODE
DBA_REFRESH.JOB_NAME
DBA_REFRESH_CHILDREN.JOB_NAME
DBA_REGISTRY.VERSION_FULL
DBA_REGISTRY_HIERARCHY.VERSION_FULL
DBA_REGISTRY_HISTORY.BUNDLE_SERIES
DBA_REGISTRY_SQLPATCH.PATCH_TYPE
DBA_REGISTRY_SQLPATCH.RU_LOGFILE
DBA_REGISTRY_SQLPATCH.SOURCE_BUILD_DESCRIPTION
DBA_REGISTRY_SQLPATCH.SOURCE_BUILD_TIMESTAMP
DBA_REGISTRY_SQLPATCH.SOURCE_VERSION
DBA_REGISTRY_SQLPATCH.TARGET_BUILD_DESCRIPTION
DBA_REGISTRY_SQLPATCH.TARGET_BUILD_TIMESTAMP
DBA_REGISTRY_SQLPATCH.TARGET_VERSION
DBA_RGROUP.JOB_NAME
DBA_ROLES.EXTERNAL_NAME
DBA_RSRC_IO_CALIBRATE.ADDITIONAL_INFO
DBA_RSRC_PLAN_DIRECTIVES.PQ_TIMEOUT_ACTION
DBA_SERVER_REGISTRY.VERSION_FULL
DBA_TABLES.MEMOPTIMIZE_READ
DBA_TABLES.HAS_SENSITIVE_COLUMN
DBA_TABLES.MEMOPTIMIZE_WRITE
DBA_TAB_COLS_V$.COLUMN_INT_ID
DBA_TAB_COLS_V$.TABLE_ID
DBA_TAB_PARTITIONS.MEMOPTIMIZE_WRITE
DBA_TAB_PARTITIONS.MEMOPTIMIZE_READ
DBA_TAB_SUBPARTITIONS.MEMOPTIMIZE_WRITE
DBA_TAB_SUBPARTITIONS.MEMOPTIMIZE_READ
DBA_TYPES.PERSISTABLE
DBA_VIEWS.HAS_SENSITIVE_COLUMN
DBA_VIEWS_AE.HAS_SENSITIVE_COLUMN
DBA_WORKLOAD_CAPTURES.ENCRYPTION
DBA_WORKLOAD_REPLAYS.REPLAY_DEADLOCKS
DBA_WORKLOAD_REPLAY_THREAD.IS_SCALE_UP_SESS
V_$AQ_MESSAGE_CACHE_STAT.MIN_EVICT_PERCENT
V_$AQ_MESSAGE_CACHE_STAT.LAST_AVG_MEMORY_HORIZON
V_$AQ_MESSAGE_CACHE_STAT.LAST_AVG_CACHED_HORIZON
V_$AQ_MESSAGE_CACHE_STAT.AVG_OPT_TIME_ERROR
V_$AQ_MESSAGE_CACHE_STAT.AVG_OPTTIME_DRIFT
V_$AQ_MESSAGE_CACHE_STAT.LAST_LEEWAY_SHIFT
V_$AQ_MESSAGE_CACHE_STAT.MAX_OPT_TIME_DRIFT
V_$AQ_MESSAGE_CACHE_STAT.MAX_OPT_TIME_ERROR
V_$AQ_MESSAGE_CACHE_STAT.LAST_AVG_SUBSHARD_HORIZON
V_$AQ_MESSAGE_CACHE_STAT.NUM_THRESHOLD_DRIFT
V_$AQ_MESSAGE_CACHE_STAT.MIN_OPT_TIME_ERROR
V_$AQ_MESSAGE_CACHE_STAT.MIN_OPT_TIME_DRIFT
V_$AQ_MSGBM.ENQ_TIME
V_$AQ_MSGBM.PRIORITY
V_$AQ_MSGBM.CORRELATION
V_$AQ_MSGBM.DELIVERY_TIME
V_$AQ_MSGBM.STATE
V_$AQ_MSGBM.EXPIRATION
V_$AQ_MSGBM.LCK_BITMAP
V_$ASM_FILE.PARENT_FILNUMINC
V_$ASM_FILE.PARENT_FILNUM
V_$BGPROCESS.PRIORITY
V_$CONTAINERS.GUID_BASE64
V_$CONTAINERS.LAST_CHANGED_BY
V_$CONTAINERS.MEMBER_CDB
V_$CONTAINERS.TENANT_ID
V_$CONTAINERS.UPGRADE_LEVEL
V_$DATABASE_KEY_INFO.MASTERKEY_ACTIVATED
V_$ENCRYPTION_WALLET.KEYSTORE_MODE
V_$EVENT_OUTLIERS.IS_DEFINITE
V_$EVENT_OUTLIERS.OUTLIER_WAIT_TIME
V_$EVENT_OUTLIERS.P1
V_$EVENT_OUTLIERS.P2
V_$EVENT_OUTLIERS.WAIT_ID
V_$EVENT_OUTLIERS.PNAME
V_$EVENT_OUTLIERS.P3
V_$IM_COL_CU.DSB_WIDTH
V_$IM_COL_CU.DSB_EXPONENT
V_$IM_HEADER.TOTAL_DELTA
V_$IM_HEADER.NUM_DELTA
V_$IM_HEADER.IS_EXTERNAL
V_$IM_IMECOL_CU.DSB_EXPONENT
V_$IM_IMECOL_CU.DSB_WIDTH
V_$IM_IMECOL_CU.IMEFLAG
V_$IM_SEGMENTS.IS_EXTERNAL
V_$IM_SEGMENTS_DETAIL.XMEMMEMBYTES
V_$IM_SEGMENTS_DETAIL.IS_EXTERNAL
V_$IM_SEGMENTS_DETAIL.DRAMMEMBYTES
V_$IM_SMU_HEAD.NUMDELTA
V_$INSTANCE.VERSION_LEGACY
V_$INSTANCE.VERSION_FULL
V_$KEY_VECTOR.CREATION_DURATION
V_$KEY_VECTOR.PAYLOAD_COLUMN_COUNT
V_$PDBS.TENANT_ID
V_$PDBS.LAST_CHANGED_BY
V_$PDBS.GUID_BASE64
V_$PDBS.TEMPLATE
V_$PDBS.UPGRADE_LEVEL
V_$PROCESS.CPU_USED
V_$SQL.RESULT_CACHE
V_$VERSION.BANNER_LEGACY
V_$VERSION.BANNER_FULL