All Products
Search
Document Center

System views

Last Updated: Aug 19, 2021

This topic describes the compatibility of OceanBase Database with native Oracle Database in terms of dictionary views and performance views.

Dictionary views

OceanBase Database is compatible with the following dictionary views in Oracle Database:

  • 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

  • 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

  • NLS_DATABASE_PARAMETERS

  • NLS_INSTANCE_PARAMETERS

  • NLS_SESSION_PARAMETERS

  • STMT_AUDIT_OPTION_MAP

  • DBA_SUBPARTITION_TEMPLATES

  • DBA_RECYCLEBIN

  • 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

  • ROLE_TAB_PRIVS

  • ROLE_SYS_PRIVS

  • ROLE_ROLE_PRIVS

  • DICTIONARY

  • DICT

Performance views

OceanBase Database is compatible with the following performance views in Oracle Database:

  • 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