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_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_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