阿里云首页 云数据库 OceanBase

系统视图

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

  • AUDIT_ACTIONS

  • ALL_PART_INDEXES

  • ALL_DEPENDENCIES

  • 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

  • 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

  • ROLE_TAB_PRIVS

  • ROLE_SYS_PRIVS

  • ROLE_ROLE_PRIVS

  • DICTIONARY

  • DICT

性能视图

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$RESTORE_POINT

  • V$GLOBAL_TRANSACTION

  • V$TIMEZONE_NAMES

  • V$LOCK

  • V$ENCRYPTED_TABLESPACES

  • V$OPEN_CURSOR

  • V$RSRC_PLAN