Overview|V3.2.4|OceanBase Database| docs|Distributed Database

View name	Description
DBA_CONTEXT	Displays information about all context namespaces in the database.

View name	Description
ALL_ALL_TABLES	Displays the object tables and relational tables accessible to the current user.
ALL_COL_COMMENTS	Displays comments on columns of tables accessible to the current user.
ALL_TABLES	Displays all tables accessible to the current user.
ALL_TAB_COLS	Displays all columns of the tables accessible to the current user.
ALL_TAB_COLUMNS	Displays all columns of the tables accessible to the current user.
ALL_TAB_COMMENTS	Displays comments on tables accessible to the current user.
DBA_TABLES	Displays all tables in the database.
DBA_ALL_TABLES	Displays all object tables and relational tables in the database. Its fields are the same as those of `ALL_ALL_TABLES`.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Displays all columns of all tables in the database.
DBA_TAB_COLUMNS	Displays all columns of all tables in the database.
USER_ALL_TABLES	Displays object tables and relational tables accessible to the current user. Its fields are the same as those of the ALL_ALL_TABLES view except that it does not have the OWNER field.
USER_TABLES	Displays all tables owned by the current user.
USER_TABLESPACES	Displays the tablespaces accessible to the current user. Its fields are the same as those of the `DBA_TABLESPACES` view, except that it does not have the `PLUGGED_IN` field.
USER_TAB_COLS	Displays all columns of the tables owned by the current user.
USER_TAB_COLUMNS	Displays all columns of the tables owned by the current user.
ALL_VIEWS	Displays the views accessible to the current user.
DBA_VIEWS	Displays all views in the database. Its fields are the same as those of `ALL_VIEWS`.
USER_VIEWS	Displays the views owned by the current user.

View name	Description
ALL_ARGUMENTS	Displays the arguments of the functions and procedures accessible to the current user.
ALL_PROCEDURES	Displays all functions and procedures accessible to the current user as well as their properties.
ALL_SOURCE	Displays the text sources of the stored objects accessible to the current user.
DBA_ARGUMENTS	Displays the arguments of the available functions and procedures in the database. Its fields are the same as those of `ALL_ARGUMENTS`.
DBA_PROCEDURES	Displays all available functions and procedures in the database as well as their properties. Its fields are the same as those of `ALL_PROCEDURES`.
DBA_SOURCE	Displays the text sources of all stored objects in the database. Its fields are the same as those of `ALL_SOURCE`.
USER_ARGUMENTS	Displays the arguments of the functions and procedures owned by the current user. Its fields are the same as those of the `ALL_ARGUMENTS` view, except that it does not have the `OWNER` field.
USER_PROCEDURES	Displays all functions and procedures owned by the current user, as well as their associated properties. Its fields are the same as those of the `ALL_PROCEDURES` view, except that it does not have the `OWNER` field.
USER_SOURCE	Displays the text sources of the stored objects owned by the current user. Its fields are the same as those of the `ALL_SOURCE` view, except that it does not have the `OWNER` field.

View name	Description
ALL_PART_COL_STATISTICS	Displays the column statistics and histograms on partitions in the partitioned tables accessible to the current user.
ALL_PART_HISTOGRAMS	Displays the histograms on all partitions.
ALL_SUBPART_COL_STATISTICS	Displays the column statistics and histograms on subpartitions in the partitioned tables accessible to the current user.
ALL_SUBPART_HISTOGRAMS	Displays the histograms on all subpartitions.
ALL_TAB_COL_STATISTICS	Displays the column statistics and histograms on tables accessible to the current user.
ALL_TAB_HISTOGRAMS	Displays all table-level histograms.
ALL_TAB_STATISTICS	Displays the optimizer statistics of tables accessible to the current user.
DBA_PART_COL_STATISTICS	Displays the column statistics and histograms on partitions in the partitioned tables of the database.
DBA_PART_HISTOGRAMS	Displays the histograms on partitions of the current database.
DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histograms on subpartitions in the partitioned tables of the database.
DBA_SUBPART_HISTOGRAMS	Displays the histograms on the subpartitions of the current database.
DBA_TAB_COL_STATISTICS	Displays the column statistics and histograms on all tables of the database.
DBA_TAB_HISTOGRAMS	Displays the table-level histograms on the current database.
DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables of the database.
USER_PART_COL_STATISTICS	Displays the column statistics and histograms on the partitions in the partitioned tables of the current user.
USER_PART_HISTOGRAMS	Displays the histograms on the partitions of the current user.
USER_SUBPART_COL_STATISTICS	Displays the column statistics and histograms on the subpartitions in the partitioned tables of the current user.
USER_SUBPART_HISTOGRAMS	Displays the histograms on the subpartitions of the current user.
USER_TAB_COL_STATISTICS	Displays the column statistics and histograms on the tables of the current user.
USER_TAB_HISTOGRAMS	Displays the table-level histograms on the current user.
USER_TAB_STATISTICS	Displays the optimizer statistics of all tables of the current user.
ALL_TAB_STATS_HISTORY	Displays the change history of the table statistics of all tables accessible to the current user.
DBA_TAB_STATS_HISTORY	Displays the change history of the table statistics of all tables in the database.
USER_TAB_STATS_HISTORY	Displays the change history of the table statistics of all tables owned by the current user.

View name	Description
ALL_USERS	Displays all database users visible to the current user.
DBA_COLL_TYPES	Displays user-defined collection types available in the database. Its fields are the same as those of the ALL_COLL_TYPES view.
DBA_USERS	Displays all database users in the database.
ALL_COL_PRIVS	Displays the granted column object privileges for which the current user is the object owner, grantor, or grantee. Displays the column object privileges for which an enabled role or PUBLIC is the grantee.
ALL_TAB_PRIVS	Object privileges for which the current user is the object owner, grantor, or grantee Object privileges for which an enabled role or PUBLIC is the grantee
DBA_COL_PRIVS	Displays all column object privileges in the database.
DBA_SYS_PRIVS	Displays the system privileges granted to users and roles.
DBA_TAB_PRIVS	Displays all object privileges in the database.
USER_COL_PRIVS	Displays the column object privileges for which the current user is the object owner, grantor, or grantee.
USER_ROLE_PRIVS	Displays the roles granted to the current user.
USER_SYS_PRIVS	Displays the system privileges granted to the current user.
ROLE_TAB_PRIVS	Displays the table privileges granted to roles. Information is provided only about roles to which the user has access.
ROLE_SYS_PRIVS	Displays the system privileges granted to roles.
ROLE_ROLE_PRIVS	Displays the roles granted to other roles. Information is provided only about roles to which the user has access.
DBA_ROLE_PRIVS	Displays the roles granted to all users and roles in the database.
DBA_ROLES	Displays all roles that exist in the database.

View name	Description
ALL_CONSTRAINTS	Displays the constraints on all tables accessible to the current user.
ALL_CONS_COLUMNS	Displays the columns that are specified in the constraints on all tables accessible to the current user.
DBA_CONSTRAINTS	Displays the constraints on all tables in the database.
DBA_CONS_COLUMNS	Displays the columns that are specified in the constraints on all tables in the database.
USER_CONSTRAINTS	Displays the constraints on all tables owned by the current user.
USER_CONS_COLUMNS	Displays the columns that are specified in the constraints on all tables owned by the current user.

View name	Description
ALL_DEF_AUDIT_OPTS	Displays the default object-auditing conditions for any object.
AUDIT_ACTIONS	Displays the action IDs and names in audit records.
DBA_AUDIT_EXISTS	Displays audit trail entries produced by `AUDIT EXISTS` and `AUDIT NOT EXISTS`.
DBA_AUDIT_OBJECT	Displays the audit trail records for all objects in the database.
DBA_AUDIT_SESSION	Displays all audit trail records concerning `CONNECT` and `DISCONNECT`.
DBA_AUDIT_STATEMENT	Displays audit trail records concerning the `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	Displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	Displays detailed auditing configurations at the object level.
DBA_STMT_AUDIT_OPTS	Displays detailed auditing configuration at the statement level.
STMT_AUDIT_OPTION_MAP	Displays statement-level auditing types, names, and priorities.
USER_AUDIT_OBJECT	Displays audit trail records for objects accessible to the current user.
USER_AUDIT_SESSION	Displays audit trail records for connections and disconnections of the current user.
USER_AUDIT_STATEMENT	Displays audit trail entries for the `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	Displays standard audit trail entries concerning the current user.

View name	Description
ALL_INDEXES	Displays the indexes on all tables accessible to the current user.
ALL_IND_COLUMNS	Displays the indexes on all tables accessible to the current user.
ALL_IND_EXPRESSIONS	Displays information about function-based indexes accessible to the current user in the database.
ALL_IND_PARTITIONS	Displays information about index partitions accessible to the current user in the database.
ALL_IND_SUBPARTITIONS	Displays information about all index subpartitions accessible to the current user in the database.
ALL_PART_INDEXES	Displays the partitioning information of all partitioned indexes accessible to the current user.
DBA_INDEXES	Displays the indexes on all tables in the database.
DBA_IND_COLUMNS	Displays the columns of indexes on all tables in the database.
DBA_IND_EXPRESSIONSc	Displays information about all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays information about all index partitions in the database.
DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
USER_INDEXES	Displays the indexes on all tables owned by the current user.
USER_IND_COLUMNS	Displays the columns of indexes on all tables owned by the current user.
USER_IND_EXPRESSIONS	Displays information about function-based indexes owned by the current user in the database.
USER_IND_PARTITIONS	Displays information about the index partitions owned by the current user in the database. This view does not have the `INDEX_OWNER` field compared with the `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS` views.
USER_IND_SUBPARTITIONS	Displays information about all index subpartitions owned by the current user in the database. This view does not have the `INDEX_OWNER` field compared with the `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS` views.
USER_PART_INDEXES	Displays the partitioning information of partitioned indexes owned by the current user.

View name	Description
ALL_PART_KEY_COLUMNS	Displays the partitioning key columns of all partitioned objects accessible to the current user.
ALL_PART_TABLES	Displays the partitioning information of all partitioned tables accessible to the current user.
ALL_SUBPARTITION_TEMPLATES	Displays information about all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	Displays the subpartitioning key columns of all partitioned objects accessible to the current user.
ALL_TAB_PARTITIONS	Displays the multi-level partitioning information, partition storage parameters, and partition statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	Displays the partition-level partitioning information, partition storage parameters, and partition statistics generated by the `DBMS_STATS` package for the partitions accessible to the current user.
DBA_PART_INDEXES	Displays the partitioning information of all partitioned indexes.
DBA_PART_KEY_COLUMNS	Displays the partitioning key columns of all partitioned objects in the database.
DBA_PART_TABLES	Displays the partitioning information of all partitioned tables accessible to the current user.
DBA_SUBPARTITION_TEMPLATES	Displays information about all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	Displays the subpartitioning key columns of all partitioned objects in the database.
DBA_TAB_PARTITIONS	Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user.
DBA_TAB_SUBPARTITIONS	Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	Displays the partitioning key columns in all partitioned objects owned by the current user.
USER_PART_TABLES	Displays the partitioning information of all partitioned tables owned by the current user.
USER_SUBPARTITION_TEMPLATES	Displays information about all subpartition templates.
USER_SUBPART_KEY_COLUMNS	Displays the subpartitioning key columns of all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	Displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes.
USER_TAB_PARTITIONS	Displays the multi-level partitioning information, partition storage parameters, and partition statistics of the current user.

View name	Description
ALL_SEQUENCES	Displays all sequences accessible to the current user.
DBA_SEQUENCES	Displays all sequences in the database.
USER_SEQUENCES	Displays all sequences owned by the current user.

View name	Description
ALL_SYNONYMS	Displays all synonyms accessible to the current user.
DBA_SYNONYMS	Displays all synonyms in the database.
USER_SYNONYMS	Displays all synonyms owned by the current user.

View name	Description
ALL_TRIGGERS DBA_TRIGGERS	Displays the triggers on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view displays all the triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.

View name	Description
DBA_COL_COMMENTS	Displays the comments on all columns of all tables and views in the database.
ALL_TAB_COMMENTS	Displays comments on tables and views accessible to the current user.
DBA_TAB_COMMENTS	Displays the comments on all tables and views in the database.
USER_COL_COMMENTS	Displays the comments on all columns of the tables and views owned by the current user.
USER_TAB_COMMENTS	Displays the comments on tables and views owned by the current user.

View name	Description
DBA_RECYCLEBIN	Displays information about all recycle bins in the database.
USER_RECYCLEBIN	Displays information about recycle bins owned by the current user. Its fields are the same as those of the `DBA_RECYCLEBIN` view, except that it does not have the `OWNER` field.

View name	Description
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationships between the user and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all resource management plans defined in the system.
DBA_RSRC_PLAN_DIRECTIVES	Displays the details of each group of resource plan directives in the database.

View name	Description
NLS_DATABASE_PARAMETERS	Displays the National Language Support (NLS) parameters at the OceanBase Database tenant level.
NLS_INSTANCE_PARAMETERS	Displays the NLS parameters at the instance level.
NLS_SESSION_PARAMETERS	Displays the NLS parameters at the session level.

View name	Description
ALL_COLL_TYPES	Displays user-defined collection types available in the database. Its fields are the same as those of the `DBA_COLL_TYPES` view.
ALL_TYPES	Displays the user-defined types available in the database.
ALL_TYPE_ATTRS	Displays the attributes of user-defined types available in the database.
DBA_COLL_TYPES	Displays user-defined collection types available in the database. Its fields are the same as those of the `ALL_COLL_TYPES` view.
DBA_TYPES	Displays the user-defined types available in the database.
DBA_TYPE_ATTRS	Displays the attributes of user-defined types available in the database.
USER_COLL_TYPES	Displays the user-defined collection types accessible to the current user.
USER_TYPES	Displays the user-defined types accessible to the current user.
USER_TYPE_ATTRS	Displays the attributes of user-defined types accessible to the current user.

View name	Description
ALL_ERRORS	Displays the current errors of all stored objects accessible to the current user.
DBA_ERRORS	Displays the current errors of all stored objects in the database.
USER_ERRORS	Displays the current errors of all stored objects accessible to the current user.

View name	Description
ALL_PROFILES	Displays all profiles accessible to the current user and their limitations.
DBA_PROFILES	Displays all profiles accessible to the current user and their limitations.
USER_PROFILES	Displays all profiles accessible to the current user and their limitations.

View name	Description
ALL_OBJECTS	Displays all database objects accessible to the current user.
ALL_DEPENDENCIES	Displays the dependencies among all the objects accessible to the current user. At present, only dependencies among Procedural Language (PL) objects are displayed.
DBA_OBJECTS	Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view.
DBA_SEGMENTS	Displays the storage allocated for all segments in the database.
DBA_DEPENDENCIES	Displays the dependencies among all objects in the database. At present, only dependencies among PL objects are displayed.
USER_OBJECTS	Displays all database objects owned by the current user. Its fields are the same as those of the ALL_OBJECTS view, except that it does not have the OWNER field. This is because the owner is the current user.
USER_SEGMENTS	Displays the storage allocated for the segments of the objects that are owned by the current user.
USER_DEPENDENCIES	Displays the dependencies among objects in the schema of the current user. At present, only dependencies among Procedural Language (PL) objects are displayed.
DICTIONARY	Displays the data dictionary tables and views.
DICT	Displays the data dictionary tables and views. Its fields are the same as those of the `DICTIONARY` view.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.
DBA_JOBS	Displays an overview of committed jobs.
DBA_JOBS_RUNNING	Displays the running jobs.
DBA_SCHEDULER_JOBS	Displays the scheduler jobs accessible to the current user.
DBA_SCHEDULER_PROGRAM	Displays all scheduler programs in the database.

View name	Description
ALL_METHOD_PARAMS	Displays the method parameters of the object types accessible to the current user.
ALL_SCHEDULER_JOB_ARGS	Displays the arguments of all scheduler jobs accessible to the current user.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the arguments of scheduler programs accessible to the current user.
ALL_TYPE_METHODS	Displays the methods of the object types accessible to the current user.
DBA_METHOD_PARAMS	Displays the method parameters of the object types in the database.
DBA_SCHEDULER_JOB_ARGS	Displays the arguments of all scheduler jobs in the database.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the arguments of all scheduler programs in the database.
DBA_TYPE_METHODS	Displays the methods of all object types in the database.
USER_TYPE_METHODS	Displays the methods of the object types accessible to the current user. Its fields are the same as those of the ALL_TYPE_METHODS view, except that it does not have the OWNER field.

Overview

Other views

Unsupported views

Overview

Views related to general database information

Views related to tables and views

Views related to functions and procedures

Views related to statistics and histograms

Views related to users and privileges

Views related to constraints

Views related to auditing

Views related to indexes

Views related to partitions

Views related to sequences

Views related to synonyms

Views related to triggers

Views related to comments

Views related to recycle bins

Views related to resource groups

Views related to NLS parameters

Views related to user-defined types

Views related to stored objects

Views related to profiles

Other views

Unsupported views