This topic describes the dictionary views of OceanBase Database in detail.
Views related to the HELP command
| View name | Description |
|---|---|
| mysql.help_topic | mysql.help_topic is used to generate the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_relation, and mysql.help_keyword. |
| mysql.help_category | mysql.help_category is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | mysql.help_keyword is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | mysql.help_relation is used to generate the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
Views related to SPM
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the SQL plan baseline in the SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in the SPM. |
Views related to privileges
| View name | Description |
|---|---|
| mysql.db | Displays the information about system-level privileges. |
| mysql.user | Displays the information about user-level privileges. |
| information_schema.COLUMN_PRIVILEGES | Displays the column privilege information. |
| information_schema.SCHEMA_PRIVILEGES | Displays the information about database privileges. |
| information_schema.TABLE_PRIVILEGES | Displays the information about table privileges. |
| information_schema.USER_PRIVILEGES | Displays the information about user privileges. |
Views related to schedulers
| View name | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays all scheduler jobs in the database. |
Views related to storage
| View name | Description |
|---|---|
| mysql.proc | Displays the information about stored procedures. |
| information_schema.ENGINES | Displays the information about storage engines. |
| information_schema.PARAMETERS | Displays the information about parameters and returned values for stored procedures. |
| information_schema.ROUTINES | Displays the information about stored procedures. |
Views related to time zones
| View name | Description |
|---|---|
| mysql.time_zone | Displays the information about time zones. It is a system view. |
| mysql.time_zone_name | Displays the time zone name. It is a system view. |
| mysql.time_zone_transition | Displays time zone conversion information. It is a system view. |
| mysql.time_zone_transition_type | Displays the information about time zone conversion types. It is a system view. |
Views related to character sets
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | Displays the information about character sets in OceanBase Database. |
| information_schema.COLLATIONS | Displays the information about collations for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Displays the correspondence between character sets and collations. |
Views related to tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Displays information about columns in tables. |
| information_schema.STATISTICS | Displays the information about table indexes. |
| information_schema.TABLES | Displays the information about tables. |
| information_schema.VIEWS | Displays the information about views. |
| information_schema.VIEW_TABLE_USAGE | Displays the information of the table and view used in the view definition. |
| oceanbase.CDB_IND_COLUMNS | Displays the column information of the index tables of all tenants. |
| oceanbase.CDB_INDEXES | Displays the indexes of all tenants. |
| oceanbase.CDB_TABLES | Displays the information about tables in all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | Displays the tables that belong to a table group of all tenants under the sys tenant. |
| oceanbase.CDB_TAB_COLS | Displays the column information of the table and view objects in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information of the table and view objects in all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the tables that belong to a table group. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays the information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table. |
| 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. |
Views related to outlines
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the information about the execution plan outlines in the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the relevant information about the throttling rule outlines in the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plan and throttling rule outlines in the current tenant. |
Views related to general database information
| View name | Description |
|---|---|
| information_schema.GLOBAL_STATUS | Displays the global status information about OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Displays the information about global variables. |
| information_schema.SCHEMATA | Displays the metadata information of the database. |
| oceanbase.CDB_OB_DATABASES | Displays the database 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 compaction information of each zone in all tenants under the sys tenant. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global information about major compactions in the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the Root Service event history. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays all tasks related to OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays the information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the information about the major compactions of zones in the current tenant. |
| oceanbase.DBA_OB_ZONES | Displays the information about all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated by major freezes. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major freezes. |
Views related to partitions
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Displays the information about table partitions. |
| oceanbase.CDB_IND_PARTITIONS | Displays the partitioning information of the indexed tables of all tenants. |
| oceanbase.CDB_PART_INDEXES | Displays the partitioning information of the index tables of all tenants. |
| oceanbase.CDB_PART_TABLES | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the subpartitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | Displays the subpartitioning information of the partitioned tables of all tenants. |
| oceanbase.DBA_IND_PARTITIONS | Displays the information about the partition and subpartitions of an index. |
| oceanbase.DBA_PART_INDEXES | Displays the partitioning information of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays the information about a partitioned table. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| oceanbase.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. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
Views related to threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Displays the information about threads that are being executed. |
Views related to constraints
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Displays information about constraints on tables and columns in a CREATE TABLE operation. |
| information_schema.KEY_COLUMN_USAGE | Displays the information about key columns that have constraints. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Displays the table constraint information. |
Views related to sessions
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | Displays the session status, such as the number of active connections and the database active duration (uptime). |
| information_schema.SESSION_VARIABLES | Displays the session variables. |
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. Under the root tenant, this view shows the history of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. In a user tenant, this view shows the history in the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the OBServer event history. |
Views related to user logon
| View name | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed logon attempts of different users. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of physical recovery tasks. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the states of physical recovery tasks upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup JOB tasks of all tenants in the cluster. Each time a user initiates a backup task, a JOB task is recorded. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | Displays the history of backup JOB tasks of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the TASK-level backup tasks of all tenants in the cluster. Each TASK record corresponds to a backup_set backup. One TASK record corresponds to one JOB task record. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the history of TASK-level backup tasks of all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of TASK-level backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays ongoing recovery tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the recovery tasks that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progresses of tenant-level backup cleanup JOB tasks. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information about backup cleanup tasks that have been executed in a tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/backup piece cleanup tasks that are being executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of the backup set/backup piece cleanup tasks that have been completed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategy configured for cleanup upon expiration and automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in a tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information about backup destinations of backup and restore in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information about backup destinations of backup and restore in a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategy configured for cleanup upon expiration and automatic cleanup in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progresses of tenant-level backup cleanup JOB tasks. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information about backup cleanup tasks that have been executed in a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/backup piece cleanup tasks that are being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of the backup set/backup piece cleanup tasks that have been completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the log archive status for each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log archives. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables of the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms of all tables of the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of all subpartitioned tables of the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays the column histograms of all tables of the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitioned tables of the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the history of the table statistics of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes of the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification history of all tables of the database since the table statistics were collected the last time. |
| oceanbase.CDB_TAB_COL_STATISTICS | Displays column statistics for the sys tenant. |
| information_schema.QUERY_RESPONSE_TIME | Displays the data types of RESPONSE TIME histograms for Prometheus to monitor. |
Views related to tenants
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| oceanbase.CDB_OBJECTS | Displays information about objects in all tenants under the sys tenant. |
| oceanbase.DBA_OB_TENANTS | Displays the basic information of all tenants, including the sys tenant, user tenants, and Meta tenants. You can determine the tenant type based on the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays the tenant-level task information. |
| oceanbase.CDB_OB_SYS_VARIABLES | Displays the system variable information of all tenants in the sys tenant. |
Views related to resources
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays the information about the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related tasks. |
| oceanbase.DBA_OB_UNITS | Displays the information about the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the information about the unit specifications of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Views related to replicas and logs
| View name | Description |
|---|---|
| oceanbase.CDB_IND_SUBPARTITIONS | Displays all index subpartitions in the database. |
| oceanbase.CDB_OB_LS_LOCATIONS | Displays the distribution of the log stream (LS) replicas of all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | Displays the metadata of table groups of all tenants in the sys tenant, especially the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the partitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the list of TABLETs in all tenants under the sys tenant and the information about the log streams to which these TABLETs belong. |
| oceanbase.CDB_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>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the partitioning information of partitioned objects (tables and indexes) of all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning information of partitioned objects (tables and indexes) of all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the information about the partitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the information about the subpartitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of a table group, mainly the partition information of the table group. |
| oceanbase.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>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the list of TABLETs in the current tenant and the information about the log streams to which these TABLETs belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream (LS) replicas in the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | Displays information about data inconsistencies between TABLET replicas. |
| oceanbase.CDB_OB_LS | Displays the status and recovery progress of log streams. |
| oceanbase.DBA_OB_LS | Displays the status and recovery progress of log streams. |