GotoDBA Features,Infrastructure 12.2.0.1 vs. 18.9 Data Dictionary Changes

12.2.0.1 vs. 18.9 Data Dictionary Changes

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

Leave a Reply

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

Related Post