---
title: "系统视图 - OceanBase 数据库 V4.2.4 | OceanBase 文档中心"
description: 系统视图 本节主要介绍 OceanBase 数据库与原生 Oracle 数据库中字典视图和性能视图的详细兼容列表。 字典视图 OceanBase 数据库兼容 Oracle 数据库的字典视图列表如下： ALL_TAB_PARTITIONS ALL_ARGUMENTS ALL_TAB_SUBPARTITIONS ALL_…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.4

# 系统视图

更新时间：2024-07-11 00:04:56

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.4/zh-CN/100.learn-more-about-oceanbase/400.compatibility-with-oracle/400.system-view.md)  

本节主要介绍 OceanBase 数据库与原生 Oracle 数据库中字典视图和性能视图的详细兼容列表。

## 字典视图

OceanBase 数据库兼容 Oracle 数据库的字典视图列表如下：

- ALL_TAB_PARTITIONS
 - ALL_ARGUMENTS
 - ALL_TAB_SUBPARTITIONS
 - ALL_COLL_TYPES
 - ALL_COL_PRIVS
 - ALL_CONSTRAINTS
 - ALL_CONS_COLUMNS
 - ALL_DEF_AUDIT_OPTS
 - ALL_ERRORS
 - ALL_INDEXES
 - ALL_IND_COLUMNS
 - ALL_IND_EXPRESSIONS
 - ALL_IND_PARTITIONS
 - ALL_IND_SUBPARTITIONS
 - ALL_METHOD_PARAMS
 - ALL_OBJECTS
 - DBA_TAB_PARTITIONS
 - ALL_PART_KEY_COLUMNS
 - DBA_TAB_SUBPARTITIONS
 - ALL_PROCEDURES
 - ALL_SCHEDULER_JOB_ARGS
 - ALL_SCHEDULER_PROGRAM_ARGS
 - ALL_SEQUENCES
 - ALL_SOURCE
 - USER_TAB_SUBPARTITIONS
 - ALL_SUBPART_KEY_COLUMNS
 - ALL_SYNONYMS
 - ALL_TABLES
 - ALL_TAB_COLS
 - ALL_TAB_COLUMNS
 - USER_TAB_PARTITIONS
 - ALL_ALL_TABLES
 - ALL_TAB_PRIVS
 - ALL_COL_COMMENTS
 - ALL_TRIGGERS
 - ALL_TYPES
 - ALL_TYPE_ATTRS
 - ALL_TYPE_METHODS
 - ALL_USERS
 - ALL_VIEWS
 - ALL_DIRECTORIES
 - ALL_PART_COL_STATISTICS
 - ALL_PART_HISTOGRAMS
 - ALL_SUBPART_COL_STATISTICS
 - ALL_SUBPART_HISTOGRAMS
 - ALL_TAB_COL_STATISTICS
 - ALL_TAB_HISTOGRAMS
 - ALL_TAB_STATISTICS
 - AUDIT_ACTIONS
 - ALL_PART_INDEXES
 - ALL_DEPENDENCIES
 - ALL_TAB_STATS_HISTORY
 - DBA_TAB_STATS_HISTORY
 - USER_TAB_STATS_HISTORY
 - DBA_ARGUMENTS
 - DBA_AUDIT_EXISTS
 - DBA_AUDIT_OBJECT
 - DBA_AUDIT_SESSION
 - DBA_AUDIT_STATEMENT
 - DBA_AUDIT_TRAIL
 - DBA_COLL_TYPES
 - ALL_PART_TABLES
 - DBA_COL_PRIVS
 - DBA_CONSTRAINTS
 - DBA_CONS_COLUMNS
 - DBA_ERRORS
 - DBA_INDEXES
 - DBA_IND_COLUMNS
 - DBA_IND_EXPRESSIONS
 - DBA_IND_PARTITIONS
 - DBA_IND_SUBPARTITIONS
 - DBA_METHOD_PARAMS
 - DBA_OBJECTS
 - DBA_OBJ_AUDIT_OPTS
 - ALL_SUBPARTITION_TEMPLATES
 - DBA_PART_KEY_COLUMNS
 - ALL_TAB_COMMENTS
 - DBA_PROCEDURES
 - DBA_PROFILES
 - DBA_ROLES
 - DBA_ROLE_PRIVS
 - DBA_SCHEDULER_JOB_ARGS
 - DBA_SCHEDULER_PROGRAM_ARGS
 - DBA_SEGMENTS
 - DBA_SEQUENCES
 - DBA_SOURCE
 - DBA_STMT_AUDIT_OPTS
 - DBA_ALL_TABLES
 - DBA_SUBPART_KEY_COLUMNS
 - DBA_SYNONYMS
 - DBA_SYS_PRIVS
 - DBA_TABLES
 - DBA_TABLESPACES
 - DBA_TAB_COLS
 - DBA_TAB_COLUMNS
 - DBA_COL_COMMENTS
 - DBA_PART_INDEXES
 - DBA_TAB_PRIVS
 - DBA_PART_TABLES
 - DBA_TRIGGERS
 - DBA_TYPES
 - DBA_TYPE_ATTRS
 - DBA_TYPE_METHODS
 - DBA_USERS
 - DBA_VIEWS
 - DBA_DEPENDENCIES
 - NLS_DATABASE_PARAMETERS
 - NLS_INSTANCE_PARAMETERS
 - NLS_SESSION_PARAMETERS
 - STMT_AUDIT_OPTION_MAP
 - DBA_SUBPARTITION_TEMPLATES
 - DBA_RECYCLEBIN
 - DBA_RSRC_CONSUMER_GROUPS
 - DBA_RSRC_GROUP_MAPPINGS
 - DBA_RSRC_PLANS
 - DBA_RSRC_PLAN_DIRECTIVES
 - DBA_DIRECTORIES
 - DBA_JOBS
 - DBA_JOBS_RUNNING
 - DBA_PART_COL_STATISTICS
 - DBA_PART_HISTOGRAMS
 - DBA_SUBPART_COL_STATISTICS
 - DBA_SUBPART_HISTOGRAMS
 - DBA_TAB_COL_STATISTICS
 - DBA_TAB_HISTOGRAMS
 - DBA_TAB_STATISTICS
 - USER_ARGUMENTS
 - USER_AUDIT_OBJECT
 - USER_AUDIT_SESSION
 - USER_AUDIT_STATEMENT
 - USER_AUDIT_TRAIL
 - USER_COLL_TYPES
 - DBA_TAB_COMMENTS
 - USER_COL_PRIVS
 - USER_CONSTRAINTS
 - USER_CONS_COLUMNS
 - USER_ERRORS
 - USER_INDEXES
 - USER_IND_COLUMNS
 - USER_IND_EXPRESSIONS
 - USER_IND_PARTITIONS
 - USER_IND_SUBPARTITIONS
 - USER_OBJECTS
 - USER_ALL_TABLES
 - USER_PART_KEY_COLUMNS
 - USER_COL_COMMENTS
 - USER_PROCEDURES
 - USER_ROLE_PRIVS
 - USER_SCHEDULER_JOB_ARGS
 - USER_SCHEDULER_PROGRAM_ARGS
 - USER_SEGMENTS
 - USER_SEQUENCES
 - USER_SOURCE
 - USER_PART_INDEXES
 - USER_SUBPART_KEY_COLUMNS
 - USER_SYNONYMS
 - USER_SYS_PRIVS
 - USER_PART_TABLES
 - USER_TRIGGERS
 - USER_TABLES
 - USER_TABLESPACES
 - USER_TAB_COLS
 - USER_TAB_COLUMNS
 - USER_SUBPARTITION_TEMPLATES
 - USER_TAB_COMMENTS
 - USER_TYPES
 - USER_TYPE_ATTRS
 - USER_TYPE_METHODS
 - USER_VIEWS
 - USER_RECYCLEBIN
 - USER_DEPENDENCIES
 - USER_JOBS
 - USER_PART_COL_STATISTICS
 - USER_PART_HISTOGRAMS
 - USER_SUBPART_COL_STATISTICS
 - USER_SUBPART_HISTOGRAMS
 - USER_TAB_COL_STATISTICS
 - USER_TAB_HISTOGRAMS
 - USER_TAB_STATISTICS
 - ROLE_TAB_PRIVS
 - ROLE_SYS_PRIVS
 - ROLE_ROLE_PRIVS
 - DICTIONARY
 - DICT
 - DBA_SQL_PLAN_BASELINES
 - ALL_IND_STATISTICS
 - ALL_IND_STATISTICS
 - DBA_IND_STATISTICS
 - USER_IND_STATISTICS
 - ALL_TAB_MODIFICATIONS
 - DBA_TAB_MODIFICATIONS
 - USER_TAB_MODIFICATIONS
 - USER_TAB_PRIVS
 - USER_PROFILES
 - DBA_SCHEDULER_JOBS
 - DBA_SCHEDULER_PROGRAM
 - DBA_CONTEXT
 - DBA_POLICIES
 - ALL_POLICIES
 - USER_POLICIES
 - DBA_POLICY_GROUPS
 - ALL_POLICY_GROUPS
 - USER_POLICY_GROUPS
 - DBA_POLICY_CONTEXTS
 - ALL_POLICY_CONTEXTS
 - USER_POLICY_CONTEXTS
 - DBA_SEC_RELEVANT_COLS
 - ALL_SEC_RELEVANT_COLS
 - USER_SEC_RELEVANT_COLS
 - ALL_TRIGGER_ORDERING
 - DBA_TRIGGER_ORDERING
 - USER_TRIGGER_ORDERING
 - ALL_DB_LINKS
 - DBA_DB_LINKS
 - USER_DB_LINKS
 - DBA_SCHEDULER_JOB_RUN_DETAILS
 - DBA_WR_SNAPSHOT
 - DBA_WR_ACTIVE_SESSION_HISTORY
 - DBA_WR_STATNAME
 - DBA_WR_SYSSTAT
 - DBA_WR_CONTROL
 - DBMS_LOCK_ALLOCATED
 - USER_USERS
 - DBA_WR_SYSTEM_EVENT
 - DBA_WR_EVENT_NAME
 - DBA_WR_SQLSTAT
 - DBA_WR_SYS_TIME_MODEL
 - DBA_WR_SQLTEXT
 - DBA_OB_LS_REPLICA_TASK_HISTORY
 - DBA_INDEX_USAGE
 - GV$OB_SESSION_PS_INFO
 - V$OB_SESSION_PS_INFO
 - PROXY_USERS

## 性能视图

OceanBase 数据库兼容 Oracle 数据库的性能视图列表如下：

- V$NLS_PARAMETERS
 - V$DBLINK
 - V$INSTANCE
 - V$SESSION_WAIT
 - V$SESSION_WAIT_HISTORY
 - V$SESSTAT
 - V$SYSTEM_EVENT
 - V$VERSION
 - V$SQL_MONITOR_STATNAME
 - V$GLOBAL_TRANSACTION
 - V$TIMEZONE_NAMES
 - V$ENCRYPTED_TABLESPACES
 - V$RSRC_PLAN
 - V$SYSSTAT
 - V$EVENT_NAME
 - V$ACTIVE_SESSION_HISTORY
 - V$DML_STATS
 - V$OPEN_CURSOR
 - V$SQL_JOIN_FILTER
 - V$STATNAME

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线