This topic describes the dictionary views in OceanBase Database, categorized by their purposes.
Help command
| 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. |
SPM-related views
| 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. |
Privilege-related
| 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. |
Scheduler
| View name | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays information about all scheduled jobs in the database. |
Storage-related
| 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. |
Time zone-related
| 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). |
Character sets
| 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. |
Tables and columns
| 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. |
Outline
| 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. |
Basic information about the database
| 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). |
Partition views
| 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. |
Threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraints
| 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. |
Session-related views
| 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. |
User login-related views
| View name | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts for each user. |
Backup and restore-related views
| 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. |
Statistics and histograms
| 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. |
Tenant-related
| 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. |
Resource-related
| 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. |
Views related to replicas and logs
| 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. |