系统视图

本节主要介绍 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

• 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