Dictionary views overview|V4.1.0|OceanBase Database| docs|Distributed Database

View name	Description
mysql.help_topic	Works with the other three tables `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` to generate the Help command.
mysql.help_category	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.
mysql.help_keyword	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` to generate the Help command.
mysql.help_relation	Works with the other three tables `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.

View name	Description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baselines of SQL statements in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
mysql.db	Displays database-level privileges (VIRTUAL_TABLE).
mysql.user	Records user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Describes database privileges.
information_schema.TABLE_PRIVILEGES	Records table privileges.
information_schema.USER_PRIVILEGES	Records user privileges.

View name	Description
oceanbase.DBA_SCHEDULER_JOBS	Displays information about all scheduled jobs in the database.

View name	Description
mysql.proc	Displays information about stored procedures.
information_schema.ENGINES	Records information about storage engines.
information_schema.PARAMETERS	Provides information about parameters and return values of stored procedures.
information_schema.ROUTINES	Provides information about stored procedures.

View name	Description
mysql.time_zone	Displays time zone information (SYSTEM_VIEW).
mysql.time_zone_name	Records the names of time zones (SYSTEM_VIEW).
mysql.time_zone_transition	The `mysql.time_zone_transition` view records information about time zone transitions.
mysql.time_zone_transition_type	Provides information about time zone transition types (SYSTEM_VIEW).

View name	Description
information_schema.CHARACTER_SETS	Records the character sets supported by OceanBase Database.
information_schema.COLLATIONS	Records the collations for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Records the correspondence between character sets and collations.

View name	Description
information_schema.COLUMNS	Records information about columns.
information_schema.STATISTICS	Records information about indexes of tables.
information_schema.TABLES	Records information about tables.
information_schema.VIEWS	Records information about views.
information_schema.VIEW_TABLE_USAGE	Displays information about tables and views used in view definitions.
oceanbase.CDB_IND_COLUMNS	Displays the columns of index tables of all tenants.
oceanbase.CDB_INDEXES	Displays the indexes of all tenants.
oceanbase.CDB_TABLES	Displays the tables of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	Displays the relationships between tablegroups and tables of all tenants in the sys tenant. Tables not in a tablegroup are not displayed.
oceanbase.CDB_TAB_COLS	Displays the columns of tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the columns of tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the relationships between tablegroups and tables. Tables not in a tablegroup are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all subpartitioned objects in the database.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	Displays the information about column checksum inconsistencies between index tables (including global indexes and local indexes) and primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of concurrency limit rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and concurrency limit rules for the current tenant.

View name	Description
information_schema.GLOBAL_STATUS	Records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Records the global variables.
information_schema.SCHEMATA	Records the metadata of the database.
oceanbase.CDB_OB_DATABASES	Displays the metadata of all tenants in the sys tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	Displays the global major compaction information of all tenants in the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone of all tenants in the sys tenant.
oceanbase.DBA_OB_DATABASES	Displays the metadata of the tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the major compaction information of the tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	Displays the related tasks of all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays the information of all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone of the tenant.
oceanbase.DBA_OB_ZONES	Displays the information of all zones.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).

View name	Description
information_schema.PARTITIONS	Records partition information.
oceanbase.CDB_IND_PARTITIONS	Displays the partition information of index tables across all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of index tables across all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables across all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the template-based subpartition information of partitioned tables across all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of partitioned tables across all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the subpartition information of partitioned tables across all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the partition and subpartition information of indexes.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the partition and subpartition information that the current user has access to, along with the partition storage parameters and statistics.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, the table name, the partition name to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by the `DBMS_STATS` package for the subpartition.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the template description of subpartitions.

View name	Description
information_schema.PROCESSLIST	Provides information about running threads.

View name	Description
information_schema.CHECK_CONSTRAINTS	Displays the constraints on tables and columns when you execute the `CREATE TABLE` statement.
information_schema.KEY_COLUMN_USAGE	Records the key constraints on columns.
information_schema.REFERENTIAL_CONSTRAINTS	Displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Describes the constraints on tables.

View name	Description
information_schema.SESSION_STATUS	Records the status information of sessions, such as the number of current active connections and the up time of the database.
information_schema.SESSION_VARIABLES	Records the variables of sessions.
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of all tenants in the SYS tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of the current tenant in non-SYS tenants.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history of OBServer nodes.

View name	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts for each user.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the progress of ongoing physical restore tasks.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the status of completed physical restore tasks.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.CDB_OB_BACKUP_JOBS	Displays backup jobs for all tenants in the cluster. A backup job record is generated after a backup job is initiated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs for all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays backup tasks for all tenants in the cluster. A backup task record is generated for each backup set. A backup task record corresponds to a backup job record.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks for all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays backup jobs for the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays the backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups, both historical and current.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_ARCHIVELOG	Displays the status of log archiving for each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all log archivings, both historical and current.

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histogram information for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays column statistics and histogram information for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms of columns of all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays histogram endpoint data for all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays histogram endpoint data for all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays table statistics history for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays modification information for all tables in the database since the last time statistics were collected on those tables.
oceanbase.CDB_TAB_COL_STATISTICS	Displays column-level statistics in the sys tenant.
information_schema.QUERY_RESPONSE_TIME	Displays data types (histograms) such as the RESPONSE TIME histogram for monitoring by Prometheus.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects in the current tenant. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	Displays the objects of all tenants in the sys tenant.
oceanbase.DBA_OB_TENANTS	Displays basic information about all tenants, including the sys tenant, user tenants, and meta tenants. You can identify the tenant type by using the `TENANT_TYPE` column.
oceanbase.DBA_OB_TENANT_JOBS	Displays information about tenant-level scheduled jobs.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the system variables of all tenants in the sys tenant.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays information about all resource pools of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays information about all unit-related tasks.
oceanbase.DBA_OB_UNITS	Displays information about all units of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the specifications of all units of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
oceanbase.CDB_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the distribution information of log stream (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	Displays the metadata of all tenant table groups in the sys tenant. The main information displayed is the partition information of table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	Displays the partitions of all tenant table groups in the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of all tenant table groups in the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in all tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	Displays the partitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	Displays the subpartitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the partitions of all tenant table groups in the sys tenant.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of all tenant table groups in the sys tenant.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of all tenant table groups in the sys tenant. The main information displayed is the partition information of table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in all tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution information of log stream (LS) replicas for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays information about data inconsistencies detected between tablet replicas.
oceanbase.CDB_OB_LS	Displays the status and restore progress of log streams.
oceanbase.DBA_OB_LS	Displays the status and restore progress of log streams.

Dictionary views overview

Help command

Scheduler

Character sets

Tables and columns

Outline

Basic information about the database

Partition views

Threads

Constraints

Statistics and histograms

Dictionary views overview

Help command

SPM-related views

Privilege-related

Scheduler

Storage-related

Time zone-related

Character sets

Tables and columns

Outline

Basic information about the database

Partition views

Threads

Constraints

Session-related views

User login-related views

Backup and restore-related views

Statistics and histograms

Tenant-related

Resource-related

Views related to replicas and logs