This topic provides an overview of dictionary views in OceanBase Database.
Views related to the HELP command
| View name | Description |
|---|---|
| mysql.help_topic | Generates the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_relation, and mysql.help_keyword tables. |
| mysql.help_category | Generates the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | Generates the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | Generates the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
Views related to privileges
| View name | Description |
|---|---|
| mysql.db | Displays information about system-level privileges. |
| mysql.user | Displays information about user-level privileges. |
| information_schema.SCHEMA_PRIVILEGES | Displays information about database privileges. |
| information_schema.TABLE_PRIVILEGES | Displays information about table privileges. |
| information_schema.USER_PRIVILEGES | Displays information about user privileges. |
Views related to storage
| View name | Description |
|---|---|
| mysql.proc | Displays information about stored procedures. |
| information_schema.ENGINES | Displays information about storage engines. |
| information_schema.PARAMETERS | Displays information about parameters and returns values for stored procedures. |
| information_schema.ROUTINES | Displays information about stored procedures. |
Views related to time zones
| View name | Description |
|---|---|
| mysql.time_zone | Displays information about time zones. It is a system view. |
| mysql.time_zone_name | Displays time zone information. 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 information about time zone conversion types. It is a system view. |
Views related to character sets
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | Displays information about character sets in OceanBase Database. |
| information_schema.COLLATIONS | Displays 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.CHECK_CONSTRAINTS | Displays information about constraints on tables and columns in a CREATE TABLE operation. |
| information_schema.COLUMNS | Displays information about columns in tables. |
| information_schema.STATISTICS | Displays information about table indexes. |
| information_schema.TABLES | Displays information about tables. |
| information_schema.VIEWS | Displays information about views. |
| information_schema.ST_GEOMETRY_COLUMNS | Displays tables with spatial data columns and spatial data types. |
| information_schema.ST_SPATIAL_REFERENCE_SYSTEMS | Displays information about the current spatial reference coordinate system supported by the system. |
Views related to resource groups
| View name | Description |
|---|---|
| oceanbase.DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationships between the user and resource groups. |
| oceanbase.DBA_RSRC_CONSUMER_GROUPS | Displays information about all resource groups in the database. |
| oceanbase.DBA_RSRC_PLANS | Displays all resource management plans defined in the system. |
| oceanbase.DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each group of resource plan directives in the database. |
Views related to outlines
| View name | Description |
|---|---|
| information_schema.DBA_OUTLINES | Displays information about outlines. |
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 information about global variables. |
| information_schema.SCHEMATA | Displays the metadata information of the database. |
Views related to partitions
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Displays information about table partitions. |
Views related to threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Displays information about threads that are being executed. |
Views related to constraints
| View name | Description |
|---|---|
| information_schema.KEY_COLUMN_USAGE | Displays 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. |
Views related to recycle bins
| View name | Description |
|---|---|
| information_schema.USER_RECYCLEBIN | Displays information about recycle bins. |
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_BACKUP_ARCHIVELOG_SUMMARY | Displays the log backup task information. |
| oceanbase.CDB_OB_BACKUP_JOB_DETAILS | Displays the details of backup jobs. |
| oceanbase.CDB_OB_BACKUP_SET_DETAILS | oceanbase.CDB_OB_BACKUP_SET_DETAILS displays detailed information about the backup sets. |
| oceanbase.CDB_OB_BACKUP_PROGRESS | Displays the progress of database backup tasks. |
| oceanbase.CDB_OB_BACKUP_SET_EXPIRED | Displays information about expired backup sets. |
| oceanbase.CDB_OB_BACKUP_ARCHIVELOG_PROGRESS | Displays the backup progress of a single partition group. |
| oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY | oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY displays the backup data cleanup history of each tenant. |
| oceanbase.CDB_OB_BACKUP_TASK_CLEAN_HISTORY | Displays information about backups that have been cleaned up. |
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of physical restore tasks. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the states of physical restore tasks upon completion. |
| oceanbase.CDB_OB_BACKUP_VALIDATION_JOB | Displays the execution progress and details of backup validation tasks on OceanBase Cloud Platform (OCP) and stores only tasks in progress. |
| oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY | Displays the execution progress and details of backup validation jobs on OCP and stores all historical jobs. |
| oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK | Displays information about backup validation tasks of each tenant. |
| oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY | Provides the history table of oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK. |
| oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB | Displays information about backup baseline backup jobs. Each SQL statement corresponds to one job. |
| oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY | Displays the historical information about backup baseline backup jobs. |
| oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK | Displays information about backup baseline backup tasks that are being normally executed. The tasks are displayed by job. |
| oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY | Displays information about completed backup baseline backup tasks. |
| oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY | Displays information about completed secondary backup rounds of the archived logs. |
| oceanbase.CDB_OB_BACKUP_SET_OBSOLETE | Displays information about expired backup sets. |
| oceanbase.CDB_OB_BACKUP_BACKUPPIECE_TASK_HISTORY | Displays the historical information about a completed task for backing up a backup piece. |
| oceanbase.CDB_OB_BACKUP_BACKUPPIECE_TASK | Displays the details of a task for backing up a backup piece. |
| oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY | Displays the historical information about a completed task for backing up a group of backup pieces. |
| oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB | Displays the progress of a backup piece backup job. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.CDB_OB_BACKUP_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG | Displays information about ongoing secondary backup rounds of the archived logs. |
| oceanbase.CDB_OB_BACKUP_ARCHIVELOG | Displays the status of the logs being backed up. |
Views related to checkpoints
| View name | Description |
|---|---|
| oceanbase.CDB_CKPT_HISTORY | Displays information about the execution of checkpoints by each tenant in the system, including the type, version number, cluster version, start time, and end time of each checkpoint. |