GotoDBA Features,Infrastructure 18.9 vs. 19.6 Data Dictionary Changes

18.9 vs. 19.6 Data Dictionary Changes

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

Leave a Reply

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

Related Post