Overview|V4.1.0| docs|Distributed 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 all columns of the tables and views accessible to the current user.
ALL_TABLES	Displays all tables accessible to the current user.
ALL_TAB_COLS	Displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COLUMNS	Displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COMMENTS	Displays comments on tables and views accessible to the current user.
DBA_COL_COMMENTS	Displays the comments on all columns of all tables and views in the database.
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.
DBA_OB_TABLEGROUP_TABLES	Displays associations between table groups and tables. Tables that do not belong to a table group are not displayed.
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, views, and clusters in the database.
DBA_TAB_COLUMNS	Displays all columns of all tables, views, and clusters 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, views, and clusters owned by the current user.
USER_TAB_COLUMNS	Displays all columns of the tables, views, and clusters 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.
DICTIONARY	Displays the data dictionary tables and views.
DICT	Displays the data dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

View name	Description
DBA_OB_OUTLINES	Displays information about the execution plan outlines in the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the relevant information about the throttling rule outlines in the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and throttling rule outlines in the current tenant.

View name	Description
DBA_SQL_PLAN_BASELINES	Displays the SQL plan baseline in SQL Plan Management (SPM).
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
DBA_CONTEXT	Displays information about all context namespaces in the database.
DBA_OB_DATABASES	Displays the database metadata of a tenant.
DBA_OB_MAJOR_COMPACTION	Displays the global information about major compactions in the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays information about the major compactions of zones.
ALL_OBJECTS	Displays all database objects accessible to the current user.
DBA_OBJECTS	Displays all database objects in the database.
USER_OBJECTS	Displays all database objects owned by the current user.
ALL_DEPENDENCIES	Displays the dependencies among all the objects accessible to the current user.
DBA_DEPENDENCIES	Displays the dependencies among all objects in the database.
USER_DEPENDENCIES	Displays the dependencies among objects in the schema of the current user.
DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions.

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.
DBA_JOBS	Displays an overview of committed jobs.
USER_JOBS	Displays an overview of committed jobs.
DBA_JOBS_RUNNING	Displays the running jobs.

View name	Description
DBA_OB_BACKUP_JOBS	Displays the JOB-level backup tasks in the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	Displays the history of JOB-level backup tasks in the current tenant.
DBA_OB_BACKUP_TASKS	Displays the TASK-level backup tasks in the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	Displays the history of TASK-level backup tasks in the current tenant.
DBA_OB_BACKUP_SET_FILES	Displays the file status of backup sets.
DBA_OB_RESTORE_PROGRESS	Displays ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	Displays the restore tasks that have been completed.
DBA_OB_ARCHIVE_DEST	Displays the configuration of archive paths.
DBA_OB_BACKUP_STORAGE_INFO	Displays information about backup destinations of backup and restore in a tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations of backup and restore in a tenant.
DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup policy configured for cleanup upon expiration and automatic cleanup in the tenant.
DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of JOB-level backup cleanup tasks in the tenant.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of JOB-level backup cleanup tasks that have been executed in the tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set/backup_piece cleanup tasks that are being executed in the tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of the backup_set/backup_piece cleanup tasks that have been completed in the tenant.
DBA_OB_ARCHIVELOG	Displays the log backup status for each path.
DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all historical and current log backups.
DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of backup pieces in each backup set.
DBA_OB_BACKUP_PARAMETER	Displays the backup parameters.

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.
ALL_IND_STATISTICS	Displays the optimizer statistics on the indexes of tables accessible to the current user.
DBA_IND_STATISTICS	Displays the optimizer statistics of all indexes of the database.
USER_IND_STATISTICS	Displays the optimizer statistics on the indexes of tables owned by the current user.
ALL_TAB_MODIFICATIONS	Displays the modification history of tables accessible to the current user since the table statistics were collected the last time.
DBA_TAB_MODIFICATIONS	Displays the modification history of all tables of the database since the table statistics were collected the last time.
USER_TAB_MODIFICATIONS	Displays the modification history of tables owned by the current user since the table statistics were collected the last time.

View name	Description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Displays all database users in the database.
ALL_COL_PRIVS	Displays the column object grants for which the current user is the object owner, grantor, or grantee; displays the column object grants for which an enabled role or PUBLIC is the grantee.
ALL_TAB_PRIVS	Displays the object grants for which the current user is the object owner, grantor, or grantee; displays the object grants for which an enabled role or PUBLIC is the grantee.
DBA_COL_PRIVS	Displays all column object grants in the database.
DBA_SYS_PRIVS	Displays the system privileges granted to users and roles.
DBA_TAB_PRIVS	Displays all object grants in the database.
USER_TAB_PRIVS	Displays the object grants for which the current user is the object owner, grantor, or grantee.
USER_COL_PRIVS	Displays the column object grants 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.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.

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 for `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 columns of 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_EXPRESSIONS	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
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. In a user tenant, this view displays the history in the current tenant.

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.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays information about global variables.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays information about session variables.

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	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_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.
DBA_SEGMENTS	Displays the storage allocated for all segments in the database.
USER_SEGMENTS	Displays the storage allocated for the segments of the objects that are owned by 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
DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	Displays the metadata of a table group, mainly the partition information of the table group.
DBA_OB_TABLEGROUP_PARTITIONS	Displays information about the partitions of a partitioned table group.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays information about the subpartitions of a partitioned table group.
DBA_OB_TABLET_REPLICAS	Displays information about all TABLET replicas in the current tenant. Each TABLET replica is uniquely identified by the joint key string of `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	Displays the list of TABLETs in the current tenant and information about the log streams to which these TABLETs belong.
DBA_OB_LS	Displays the status and restore progress of log streams.

View name	Description
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.
USER_SCHEDULER_JOB_ARGS	Displays the arguments of scheduler jobs owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the arguments of all scheduler programs in the database.
USER_SCHEDULER_PROGRAM_ARGS	Displays the arguments of scheduler programs owned by the current user.
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

Applicability

Unsupported views

Overview

Applicability

Views related to tables and views

Views related to outlines

Views related to SPM

Views related to general database information

Views related to functions and procedures

Views related to backup and restore

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 sessions

Views related to sequences

Views related to synonyms

Views related to triggers

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

Views related to replicas and logs

Views related to scheduler programs

Unsupported views