教学文章
Technology Exchange
Technology Exchange
热门课程
400电话
免费咨询热线
400-090-9964
OceanBase 数据库兼容了部分 Oracle 数据库的系统视图，其中：
兼容字典视图 195 个。
兼容性能视图(以 v$ 开头)20 个。
字典视图
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
性能视图
OceanBase 数据库兼容 Oracle 数据库的性能视图列表如下：
V$NLS_PARAMETERS
V$SESSION_WAIT
V$SESSION_WAIT_HISTORY
V$SESSTAT
V$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE
V$SQL_WORKAREA_HISTOGRAM
V$SYSSTAT
V$SYSTEM_EVENT
V$VERSION
V$SQL_MONITOR_STATNAME
V$GLOBAL_TRANSACTION
V$TIMEZONE_NAMES
V$ENCRYPTED_TABLESPACES
V$RSRC_PLAN
V$GLOBALCONTEXT
V$INSTANCE
V$ACTIVE_SESSION_HISTORY
V$EVENT_NAME
V$SQL_PLAN_MONITOR