In this post I’ll show what’s new in 19.6 Data Dictionary. To see comparison between other versions, check this post.
Interesting additions are:
- Views/columns related to automatic indexing
- Some V$ALL views (allow users to see stats and plan of their own SQLs without specific permissions)
- V$DUAL
19.6 New DBA Views
DBA_AUTOTASK_SCHEDULE_CONTROL
DBA_AUTO_INDEX_CONFIG
DBA_AUTO_INDEX_EXECUTIONS
DBA_AUTO_INDEX_IND_ACTIONS
DBA_AUTO_INDEX_SQL_ACTIONS
DBA_AUTO_INDEX_STATISTICS
DBA_AUTO_INDEX_VERIFICATIONS
DBA_AUTO_STAT_EXECUTIONS
DBA_HIST_TABLE_SETTINGS
DBA_JSON_COLSTORAGE_STATS
DBA_JSON_TABLE_COLS_COUNT
DBA_JSON_VIEW_COLS_COUNT
DBA_LOGMNR_PROFILE_PLSQL_STATS
DBA_LOGMNR_PROFILE_TABLE_STATS
DBA_PDB_SNAPSHOTFILE
DBA_RAT_CAPTURE_SCHEMA_INFO
DBA_SQL_QUARANTINE
DBA_TRIGGERS_AE
19.6 New V$ Views
V_$ALL_ACTIVE_SESSION_HISTORY
V_$ALL_SQL_MONITOR
V_$ALL_SQL_PLAN
V_$ALL_SQL_PLAN_MONITOR
V_$AQ_PARTITION_STATS
V_$ASM_ACFSAUTORESIZE
V_$DIAG_VADR_CONTROL
V_$DUAL
V_$MY_NOLOGGING_STANDBY_TXN
V_$NOLOGGING_STANDBY_TXN
V_$SHARED_SERVER_STAT
V_$SQL_TESTCASES
19.6 New Dictionary Column
DBA_ADDM_TASKS.CDB_TYPE_ANALYZED
DBA_ADDM_TASKS.CDB_TYPE_DETECTED
DBA_ADDM_TASKS.DB_TYPE_ANALYZED
DBA_ADDM_TASKS.DB_TYPE_DETECTED
DBA_ADVISOR_ACTIONS.RESULT_LAST_MODIFIED
DBA_ADVISOR_ACTIONS.RESULT_MESSAGE
DBA_ADVISOR_ACTIONS.RESULT_STATUS
DBA_ADVISOR_OBJECTS.ADV_SQL_ID
DBA_ADVISOR_SQLPLANS.OUTROWS
DBA_ADVISOR_SQLPLANS.STARTS
DBA_ALL_TABLES.HYBRID
DBA_ALL_TABLES.LOGICAL_REPLICATION
DBA_APPLICATIONS.APP_CAPTURE_ERROR
DBA_APPLY_KEY_COLUMNS.APPLY_NAME
DBA_APP_ERRORS.SYSTEM_IGNORABLE
DBA_APP_ERRORS.USER_IGNORABLE
DBA_CONTEXT.TRACKING
DBA_DB_LINKS.INTRA_CDB
DBA_HIST_DYN_REMASTER_STATS.PERSISTENT_OBJECTS
DBA_HIST_RSRC_PDB_METRIC.MAX_AVG_RUNNING_SESSIONS
DBA_HIST_SEG_STAT.IM_MEMBYTES
DBA_IDENTIFIERS.DECLARED_OBJECT_NAME
DBA_IDENTIFIERS.DECLARED_OBJECT_TYPE
DBA_IDENTIFIERS.DECLARED_OWNER
DBA_IDENTIFIERS.IMPLICIT
DBA_INDEXES.AUTO
DBA_INDEXES.CONSTRAINT_INDEX
DBA_LOCKDOWN_PROFILES.EXCEPT_USERS
DBA_MVIEW_DETAIL_PARTITION.LAST_REFRESH_TIME
DBA_OBJECT_TABLES.HYBRID
DBA_OBJECT_TABLES.LOGICAL_REPLICATION
DBA_PDBS.CREDENTIAL_NAME
DBA_SEQUENCES.SHARDED_FLAG
DBA_SERVICES.NSPARE1
DBA_SERVICES.PLACEMENT_POLICY
DBA_SERVICES.RESET_STATE
DBA_SERVICES.TABLE_FAMILY_ID
DBA_SERVICES.VCSPARE1
DBA_SUPPLEMENTAL_LOGGING.SUBSET_REP
DBA_TABLES.ADMIT_NULL
DBA_TABLES.DATA_LINK_DML_ENABLED
DBA_TABLES.HYBRID
DBA_TABLES.LOGICAL_REPLICATION
DBA_TAB_COLS_V$.OWNER_ID
DBA_TAB_STATISTICS.NOTES
DBA_USERS.PASSWORD_CHANGE_DATE
DBA_VIEWS.ADMIT_NULL
DBA_VIEWS.PDB_LOCAL_ONLY
DBA_VIEWS_AE.ADMIT_NULL
DBA_VIEWS_AE.PDB_LOCAL_ONLY
V_$ACTIVE_SERVICES.TABLE_FAMILY_ID
V_$AQ_SUBSCRIBER_LOAD.DEQUEUE_SESSIONS
V_$ASM_ACFSSNAPSHOTS.REPL
V_$ASM_ACFSSNAPSHOTS.ADDITIONAL_STORAGE
V_$ASM_ACFSSNAPSHOTS.LINK
V_$ASM_ACFSSNAPSHOTS.QUOTA
V_$ASM_ACFSSNAPSHOTS.STATE
V_$ASM_AUDIT_CONFIG_PARAMS.PARAMETER_UNIT
V_$ASM_FILESYSTEM.METADATA_BLOCK_SIZE
V_$ASM_FILESYSTEM.FROZEN_STATE
V_$ASM_FILESYSTEM.COMPRESS_STATE
V_$ASM_FILESYSTEM.ACFS_COMPATIBILITY
V_$ASM_FILESYSTEM.RESIZE_STATE
V_$CIRCUIT.BOUND_REASON
V_$CIRCUIT.BOUND_TIME
V_$DATABASE.FS_FAILOVER_MODE
V_$DATABASE.SUPPLEMENTAL_LOG_DATA_SR
V_$DYNAMIC_REMASTER_STATS.PERSISTENT_OBJECTS
V_$GG_APPLY_RECEIVER.CURRENT_POSITION
V_$GG_APPLY_RECEIVER.OS_PROCESS_ID
V_$GG_APPLY_RECEIVER.TOTAL_COMMITS
V_$GG_APPLY_RECEIVER.TOTAL_ERRORS
V_$GG_APPLY_RECEIVER.TOTAL_TRANSACTIONS_RECEIVED
V_$IMHMSEG.N_ROWS_UPDATE
V_$IMHMSEG.N_ROWS_INSERT
V_$IMHMSEG.N_ROWS_DELETE
V_$IMHMSEG.N_SEGMENT_DELETE
V_$IMHMSEG.N_SEGMENT_UPDATE
V_$IMHMSEG.N_SEGMENT_INSERT
V_$IM_GLOBALDICT.NUM_SYMBOLS
V_$IM_GLOBALDICT.TOTAL_LENGTH
V_$IM_GLOBALDICT_PIECEMAP.HTNUM
V_$KCCDI.DIFMOD
V_$KCCFE.FERFNO
V_$RESTORE_POINT.REPLICATED
V_$RMAN_OUTPUT.GUID
V_$SERVICES.TABLE_FAMILY_ID
V_$SHARED_SERVER.BOUND_REASON
V_$SHARED_SERVER.BOUND_TIME
V_$SQL.AVOIDED_EXECUTIONS
V_$SQL.SQL_QUARANTINE
V_$SQLSTATS.DELTA_AVOIDED_EXECUTIONS
V_$SQLSTATS.AVOIDED_EXECUTIONS
V_$SQL_MONITOR.CURRENT_USERNAME
V_$SQL_MONITOR.CURRENT_USER#
V_$SUBSCR_REGISTRATION_STATS.SHARD_ID
V_$UNIFIED_AUDIT_TRAIL.PROTOCOL_RETURN_CODE
V_$UNIFIED_AUDIT_TRAIL.PROTOCOL_SESSION_ID
V_$UNIFIED_AUDIT_TRAIL.PROTOCOL_MESSAGE
V_$UNIFIED_AUDIT_TRAIL.PROTOCOL_ACTION_NAME
V_$UNIFIED_AUDIT_TRAIL.PROTOCOL_USERHOST
V_$UNIFIED_AUDIT_TRAIL.EVENT_TIMESTAMP_OLD