Oracle 21C 新增系统视图

在Oracle 21c 数据库，Oracle 12.1中新增的数据字典视图如下:

• DBA_ACCHK_EVENTS
• DBA_ACCHK_EVENTS_SUMMARY
• DBA_ACCHK_STATISTICS
• DBA_ACCHK_STATISTICS_SUMMARY
• DBA_ACTIVITY_CONFIG
• DBA_ACTIVITY_MVIEW
• DBA_ACTIVITY_SNAPSHOT_META
• DBA_ACTIVITY_TABLE
• ALL_ANALYTIC_VIEW_DIM_ATTRS, DBA_ANALYTIC_VIEW_DIM_ATTRS, and USER_ANALYTIC_VIEW_DIM_ATTRS
• ALL_ANALYTIC_VIEW_FACT_COLS, DBA_ANALYTIC_VIEW_FACT_COLS, and USER_ANALYTIC_VIEW_FACT_COLS
• DBA_APP_ERRORS_HISTORY
• USER_APPLICATION_ROLES
• DBA_AUTO_MV_ANALYSIS_ACTIONS
• DBA_AUTO_MV_ANALYSIS_EXECUTIONS
• DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS
• DBA_AUTO_MV_ANALYSIS_REPORT
• DBA_AUTO_MV_ANALYSIS_TASK
• DBA_AUTO_MV_CONFIG
• DBA_AUTO_MV_MAINT_REPORT
• DBA_AUTO_MV_REFRESH_HISTORY
• DBA_AUTO_MV_VERIFICATION_REPORT
• DBA_AUTO_MV_VERIFICATION_STATUS
• DBA_AUTOTASK_SCHEDULE_CONTROL
• DBA_AUTOTASK_SETTINGS
• ALL_BLOCKCHAIN_TABLES, DBA_BLOCKCHAIN_TABLES, and USER_BLOCKCHAIN_TABLES
• DBA_CERTIFICATES and USER_CERTIFICATES
• DBA_LOGMNR_DICTIONARY_BUILDLOG
• DBA_LOGSTDBY_SUPPORT_MODE
• DBA_OGG_AUTO_CAPTURED_TABLES and USER_OGG_AUTO_CAPTURED_TABLES
• ALL_QUEUE_EVENT_STREAMS, DBA_QUEUE_EVENT_STREAMS, and USER_QUEUE_EVENT_STREAMS
• DBA_ROLLING_SUPPORT_MODE
• ALL_TAB_COL_STAT_MODELS, DBA_TAB_COL_STAT_MODELS, and USER_TAB_COL_STAT_MODELS
• DBA_ZONEMAP_AUTO_ACTIONS
• DBA_ZONEMAP_AUTO_FINDINGS

在Oracle 21c 数据库，Oracle 12.1中新增的动态性能视图如下:

• GV$ACTIVITY_MVIEW and V$ACTIVITY_MVIEW
• GV$ACTIVITY_TABLE and V$ACTIVITY_TABLE
• GV$AUTHPOOL_STATS and V$AUTHPOOL_STATS
• GV$EQ_CACHED_PARTITIONS and V$EQ_CACHED_PARTITIONS
• GV$EQ_CROSS_INSTANCE_JOBS and V$EQ_CROSS_INSTANCE_JOBS
• GV$EQ_INACTIVE_PARTITIONS and V$EQ_INACTIVE_PARTITIONS
• GV$EQ_MESSAGE_CACHE and V$EQ_MESSAGE_CACHE
• GV$EQ_MESSAGE_CACHE_ADVICE and V$EQ_MESSAGE_CACHE_ADVICE
• GV$EQ_MESSAGE_CACHE_STAT and V$EQ_MESSAGE_CACHE_STAT
• GV$EQ_NONDUR_SUBSCRIBER and V$EQ_NONDUR_SUBSCRIBER
• GV$EQ_NONDUR_SUBSCRIBER_LWM and V$EQ_NONDUR_SUBSCRIBER_LWM
• GV$EQ_PARTITION_STATS and V$EQ_PARTITION_STATS
• GV$EQ_REMOTE_DEQUEUE_AFFINITY and V$EQ_REMOTE_DEQUEUE_AFFINITY
• GV$EQ_SUBSCRIBER_LOAD and V$EQ_SUBSCRIBER_LOAD
• GV$EQ_SUBSCRIBER_STAT and V$EQ_SUBSCRIBER_STAT
• GV$EQ_UNCACHED_PARTITIONS and V$EQ_UNCACHED_PARTITIONS
• GV$PKCS11_PATH and V$PKCS11_PATH
• GV$PMEM_FILESTORE and V$PMEM_FILESTORE
• GV$RESULT_SUBCACHE_STATISTICS and V$RESULT_SUBCACHE_STATISTICS