Outline of system views|V4.3.3|OceanBase Database| docs|Distributed Database

View	Description
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 associations between table groups and tables of all tenants in the `sys` tenant. Tables that do not belong to a table group are not displayed.
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 associations between table groups and tables. Tables that do not belong to a table group are not displayed.
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.
information_schema.TABLESPACES	Displays the information about tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	Description
information_schema.INNODB_BUFFER_PAGE	Displays the information about all buffer pages in the buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_BUFFER_PAGE_LRU	Displays the least recently used (LRU) sorting information of pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_BUFFER_POOL_STATS	Displays the statistics of the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP	Displays the status of operations related to compressed InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_PER_INDEX	Displays the information about operations related to compressed InnoDB tables and indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_PER_INDEX_RESET	Displays the reset time of operations related to compressed InnoDB tables and indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_RESET	Displays the operation status of compressed InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMPMEM	Displays the status of compressed pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMPMEM_RESET	Displays the reset status of compressed pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_DATAFILES	Displays the data file paths of InnoDB files in each table and general tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_INDEXES	Displays the metadata of InnoDB indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLES	Displays the metadata of InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLESPACES	Displays the metadata of InnoDB table files and general tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLES	Displays the low-level status of InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_VIRTUAL	Displays the metadata of virtual columns generated in InnoDB. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_TEMP_TABLE_INFO	Displays the temporary InnoDB tables created by active users. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_METRICS	Displays the performance information of InnoDB. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	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 information about the throttling rule outlines in the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and throttling rule outlines in the current tenant.

View	Description
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 major compaction information of each zone of all tenants in the `sys` tenant.
oceanbase.DBA_OB_DATABASES	Displays the database metadata of tenants.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the RootService event history.
oceanbase.DBA_OB_SERVER_JOBS	Displays all jobs 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 of 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 compactions.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions.
information_schema.events	Displays the information about all events.

View	Description
oceanbase.CDB_IND_PARTITIONS	Displays the partitioning information of the index 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 partitions and subpartitions of indexes.
oceanbase.DBA_PART_INDEXES	Displays the information about partitions of all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays the information about partitioned tables.
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 the information about all subpartition templates.

View	Description
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	Displays the ongoing partition transfer tasks in all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the historical partition transfer tasks executed in all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the ongoing partition transfer tasks in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the historical partition transfer tasks executed in the current tenant.

View	Description
information_schema.INNODB_FT_BEING_DELETED	Displays the information about the full-text indexes that are being deleted. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_CONFIG	Displays the configuration information of the InnoDB full-text search engine. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_DELETED	Displays the information about the full-text indexes marked as deleted. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_INDEX_CACHE	Displays the cache status of InnoDB full-text indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_FIELDS	Displays the metadata of key columns related to InnoDB indexes. The information in this view is equivalent to that in the `SYS_FIELDS` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. After you log in as the root user to the `sys` tenant, you can view the deadlock event history of all tenants.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history on an OBServer node.

View	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the current execution progress of physical restore jobs.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the states of physical restore jobs 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 jobs in all tenants in the cluster. Each time a user initiates a backup job, a job record is generated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays the backup tasks in all tenants in the cluster. A task record is generated for each backup set. The task records and job records are in one-to-one mapping.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks in all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of 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 restore jobs.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the restore jobs 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 progress of backup cleanup jobs in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup jobs that have been executed in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of the backup set/piece cleanup tasks that have been completed in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations of backup and restore in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations of backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations of backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations of backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of backup cleanup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup jobs that have been executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of the backup set/piece cleanup tasks that have been completed in the current 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 archiving status for each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all historical and current log archiving tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	Displays the information about table-level restore jobs.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays the information about table-level restore jobs.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	Displays the information about import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays the information about import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	Displays the records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays the records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.

View	Description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays the column statistics and histograms on all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histograms of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histograms of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays the column histograms of all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histograms of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histograms of all subpartitioned tables in 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 in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification history of all tables in the database since the table statistics were collected the last time.
oceanbase.CDB_TAB_COL_STATISTICS	Displays column statistics for the `sys` tenant.

View	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 the information about objects of all tenants in the `sys` tenant.
oceanbase.DBA_OB_TENANTS	Displays the basic information of all tenants, including information about 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 job information.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the information about system variables of all tenants in the `sys` tenant.

View	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 jobs.
oceanbase.DBA_OB_UNITS	Displays the information about the units of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the information about the unit configs of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View	Description
oceanbase.CDB_IND_SUBPARTITIONS	Displays the information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the distribution of the log stream 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 of all tenants in the `sys` tenant and the log streams to which these tablets belong.
oceanbase.CDB_OB_TABLET_REPLICAS	Displays the 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 the information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the information about the partitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the information about the subpartitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays the 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 information about the log streams to which these tablets belong.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream replicas in the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays the information about data inconsistencies 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.

View	Description
oceanbase.DBA_WR_SNAPSHOT	Displays the snapshots of the current tenant.
oceanbase.CDB_WR_SNAPSHOT	Displays the snapshots of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persisted Active Session History (ASH) data of the current tenant.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	Displays the persisted ASH data of all tenants.
oceanbase.DBA_WR_STATNAME	Displays the names of system statistical items of the current tenant.
oceanbase.CDB_WR_STATNAME	Displays the names of system statistical items of all tenants.
oceanbase.DBA_WR_SYSSTAT	Displays the details about system statistical items of the current tenant.
oceanbase.CDB_WR_SYSSTAT	Displays the details about system statistical items of all tenants.
oceanbase.DBA_WR_CONTROL	Displays Workload Repository (WR) configurations.
oceanbase.CDB_WR_CONTROL	Displays WR configurations.
oceanbase.CDB_WR_SYSTEM_EVENT	Displays the persisted tenant-level wait events of all tenants.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the persisted tenant-level wait events of the current tenant.
oceanbase.CDB_WR_EVENT_NAME	Displays the persisted tenant-level wait events of all tenants.
oceanbase.DBA_WR_EVENT_NAME	Displays the persisted tenant-level wait events of the current tenant.
oceanbase.CDB_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in all tenants. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.
oceanbase.DBA_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.
oceanbase.CDB_WR_SYS_TIME_MODEL	Displays the WR data for the time model statistical items of all tenants.
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the WR data for the time model statistical items of the current tenant.
oceanbase.CDB_WR_SQLTEXT	Displays the SQL statements of all tenants collected by WR.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL statements of the current tenant collected by WR.

View	Description
information_schema.INNODB_SYS_FOREIGN	Displays the metadata of InnoDB foreign keys. The information in this view is equivalent to that in the `SYS_FOREIGN` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_FOREIGN_COLS	Displays the status of InnoDB foreign key columns. The information in this view is equivalent to that in the `SYS_FOREIGN_COLS` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	Description
oceanbase.CDB_OB_KV_TTL_TASKS	Displays the ongoing time-to-live (TTL) tasks in all tenants. You can query this view only from the `sys` tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks in all tenants. You can query this view only from the `sys` tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the ongoing TTL tasks in the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks in the current tenant.

View	Description
GV$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in tenants.
GV$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
GV$OB_PROCESSLIST	Displays the information about sessions on all OBServer nodes of tenants.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays the session-level wait events of all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting.
GV$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of all sessions on all OBServer nodes.
GV$SYSTEM_EVENT	Displays all tenant-level wait events in the cluster.
GV$SESSTAT	Displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	Displays the information about tenant-level statistical events on all OBServer nodes.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in tenants.
V$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
V$OB_PROCESSLIST	Displays the information about sessions on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
V$STATNAME	Displays the definitions of all statistical events.
V$EVENT_NAME	Displays the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	Displays the details about the current wait events in each session. Each wait event has three parameters.
V$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of each session.
V$SESSTAT	Displays an overview of session-level statistical events.
V$SYSSTAT	Displays the information about tenant-level statistical events on the current OBServer node.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the progress of index creation in the cluster.
V$SESSION_LONGOPS	Displays the progress of index creation on the current OBServer node.

View	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the data transfer layer (DTL) intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View	Description
GV$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
V$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
GV$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.
V$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.

View	Description
GV$OB_MEMORY	Displays the tenant-level memory statistics.
V$OB_MEMORY	Displays the tenant-level memory statistics.
GV$OB_MEMSTORE	Displays the memory usage of all MemTables of all tenants on all OBServer nodes.
V$OB_MEMSTORE	Displays session-level MemStore statistics.
GV$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
V$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
GV$OB_SSTABLES	Displays the SSTables of tenants.
V$OB_SSTABLES	Displays the SSTables of tenants.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View	Description
GV$OB_PLAN_CACHE_STAT	Displays the outlines of the current tenant. It is used for outline migration.
V$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache of the current tenant on all OBServer nodes.
GV$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan caches of all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans that are cached in the plan cache on the current OBServer node.
GV$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
V$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
GV$OB_PX_P2P_DATAHUB	Displays the information about data transmission operations that are executed in parallel.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on the current OBServer node.
GV$OB_SQL_AUDIT	Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status.
V$OB_SQL_AUDIT	Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status.
GV$SQL_PLAN_MONITOR	Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan.
V$SQL_PLAN_MONITOR	Displays the operation-level statistics of slow queries. Each operation corresponds to one row in this view.
V$SQL_MONITOR_STATNAME	Displays the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	Displays the information about end-to-end diagnostics.
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.
V$OB_SQLSTAT	Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.

View	Description
GV$OB_LOG_STAT	Displays the Palf status.
GV$OB_LS_SNAPSHOTS	Displays the information about persisted log stream snapshots in all units.
V$OB_LOG_STAT	Displays the Palf status.

View	Description
GV$OB_RPC_OUTGOING	Displays the emote procedure call (RPC) sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the RPC receiving statistics of all OBServer nodes.
V$OB_RPC_OUTGOING	Displays the data sending status of all RPC packet codes in each tenant on the current OBServer node.
V$OB_RPC_INCOMING	Displays the data receiving status of all RPC packet codes in each tenant on the current OBServer node.

View	Description
GV$OB_SESSION	Displays the information about sessions created on all OBServer nodes.

View	Description
GV$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
GV$OB_PARAMETERS	Displays the parameters on all OBServer nodes of tenants.
GV$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
GV$OB_SERVERS	Displays the information about all OBServer nodes.
GV$OB_UNITS	Displays the information about the units on the OBServer nodes where tenants reside. You can view the units of all OBServer nodes in the current cluster from the `sys` tenant.
V$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
V$OB_PARAMETERS	Displays the parameters on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
V$OB_SERVERS	Displays the information about the current OBServer node.
V$OB_UNITS	Displays the information about the units on the current OBServer node.
GV$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$OB_COMPATIBILITY_CONTROL	Displays all features that support product behavior compatibility control based on the released OceanBase Database versions.

View	Description
GV$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the current OBServer node.
GV$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the cluster.
V$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the current OBServer node.

View	Description
GV$OB_MERGE_INFO	Displays the statistics of compactions that are completed in the cluster.
V$OB_MERGE_INFO	Displays the statistics of compactions that are completed in the cluster.

View	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.
V$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.
GV$OB_TENANT_RUNTIME_INFO	Displays the information about quotas of queues and threads in tenant threads.
V$OB_TENANT_RUNTIME_INFO	Displays the information about quotas of queues and threads in tenant threads.

View	Description
GV$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory.
V$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
V$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
V$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode.
V$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory.

View	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with encryption enabled.

View	Description
GV$LATCH	Displays the information about the latches on all OBServer nodes in the cluster.
V$LATCH	Displays the information about the latches on all OBServer nodes in the cluster.

View	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 tables`.
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`.

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

View	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 information about column privileges.
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.

View	Description
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the ongoing TTL tasks in the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks in the current tenant.

View	Description
oceanbase.DBA_SCHEDULER_JOBS	Displays all scheduler jobs in the database.

View	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 return values for stored procedures.
information_schema.ROUTINES	Displays the information about routines.

View	Description
mysql.time_zone	Displays the information about time zones. It is a system view.
mysql.time_zone_name	Displays the names of time zones. It is a system view.
mysql.time_zone_transition	Displays the information about time zone conversions. It is a system view.
mysql.time_zone_transition_type	Displays the information about time zone conversion types. It is a system view.

View	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.

View	Description
information_schema.COLUMNS	Displays the 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 about tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the associations between table groups and tables. Tables that do not belong to a table group are not displayed.
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.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	Displays the information about tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	Description
information_schema.INNODB_BUFFER_PAGE	Displays the information about all buffer pages in the buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_BUFFER_PAGE_LRU	Displays the LRU sorting information of pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_BUFFER_POOL_STATS	Displays the statistics of the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP	Displays the status of operations related to compressed InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_PER_INDEX	Displays the information about operations related to compressed InnoDB tables and indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_PER_INDEX_RESET	Displays the reset time of operations related to compressed InnoDB tables and indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMP_RESET	Displays the operation status of compressed InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMPMEM	Displays the status of compressed pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_CMPMEM_RESET	Displays the reset status of compressed pages in the InnoDB buffer pool. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_DATAFILES	Displays the data file paths of InnoDB files in each table and general tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_INDEXES	Displays the metadata of InnoDB indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLES	Displays the metadata of InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLESPACES	Displays the metadata of InnoDB table files and general tablespaces. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_TABLES	Displays the low-level status of InnoDB tables. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_VIRTUAL	Displays the metadata of virtual columns generated in InnoDB. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_TEMP_TABLE_INFO	Displays the temporary InnoDB tables created by active users. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_METRICS	Displays the performance information of InnoDB. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	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 information about the throttling rule outlines in the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and throttling rule outlines in the current tenant.

View	Description
information_schema.GLOBAL_STATUS	Displays the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Displays the information about global variables.
information_schema.SCHEMATA	Displays the database metadata.
oceanbase.DBA_OB_DATABASES	Displays the database metadata of the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the information about the major compactions of zones.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions.
information_schema.events	Displays the information about all events.

View	Description
information_schema.PARTITIONS	Displays the information about table partitions.
oceanbase.DBA_IND_PARTITIONS	Displays the information about the partitions and subpartitions of indexes.
oceanbase.DBA_PART_INDEXES	Displays the information about partitions of all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays the information about partitioned tables.
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 the information about all subpartition templates.

View	Description
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the ongoing partition transfer tasks in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the historical partition transfer tasks executed in the current tenant.

View	Description
information_schema.PROCESSLIST	Displays the information about threads that are being executed.

View	Description
information_schema.CHECK_CONSTRAINTS	Displays the constraints on tables and columns when the `CREATE TABLE` operation is performed.
information_schema.KEY_COLUMN_USAGE	Displays the information about key columns that have constraints.
information_schema.REFERENTIAL_CONSTRAINTS	Displays the metadata of `FOREIGN KEY` constraints.
information_schema.TABLE_CONSTRAINTS	Displays the information about table constraints.

View	Description
information_schema.INNODB_FT_BEING_DELETED	Displays the information about the full-text indexes that are being deleted. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_CONFIG	Displays the configuration information of the InnoDB full-text search engine. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_DELETED	Displays the information about the full-text indexes marked as deleted. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_FT_INDEX_CACHE	Displays the cache status of InnoDB full-text indexes. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_FIELDS	Displays the metadata of key columns related to InnoDB indexes. The information in this view is equivalent to that in the `SYS_FIELDS` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	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 information about session variables.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant.

View	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts of different users.

View	Description
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of 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 restore jobs.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the restore jobs that have been completed.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configuration of archive paths.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations of backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations of backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of backup cleanup jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup jobs that have been executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of the backup set/piece cleanup tasks that have been completed in the current 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.DBA_OB_RECOVER_TABLE_JOBS	Displays the information about table-level restore jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays the information about import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays the records of table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.

View	Description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays the column statistics and histograms on all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histograms of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histograms of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays the column histograms of all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histograms of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histograms of all subpartitioned tables in 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 in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification history of all tables in the database since the table statistics were collected the last time.
information_schema.QUERY_RESPONSE_TIME	Displays the data types of `RESPONSE TIME` histograms for Prometheus to monitor.

View	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.DBA_OB_TENANTS	Displays the basic information of all tenants, including information about the `sys` tenant, user tenants, and meta tenants. You can determine the tenant type based on the `TENANT_TYPE` column.

View	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View	Description
oceanbase.DBA_IND_SUBPARTITIONS	Displays the information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the information about the partitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the information about the subpartitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays the 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 information about the log streams to which these tablets belong.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream replicas in the current tenant.

View	Description
oceanbase.DBA_WR_SNAPSHOT	Displays the snapshots of the current tenant.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persisted ASH data of the current tenant.
oceanbase.DBA_WR_STATNAME	Displays the names of system statistical items of the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays the details about system statistical items of the current tenant.
oceanbase.DBA_WR_CONTROL	Displays WR configurations.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the persisted tenant-level wait events of the current tenant.
oceanbase.DBA_WR_EVENT_NAME	Displays the persisted tenant-level wait events of the current tenant.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL statements of the current tenant collected by WR.

View	Description
information_schema.INNODB_SYS_FOREIGN	Displays the metadata of InnoDB foreign keys. The information in this view is equivalent to that in the `SYS_FOREIGN` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.
information_schema.INNODB_SYS_FOREIGN_COLS	Displays the status of InnoDB foreign key columns. The information in this view is equivalent to that in the `SYS_FOREIGN_COLS` table in the `InnoDB` data dictionary. Note This view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view.

View	Description
oceanbase.DBA_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.

View	Description
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the WR data for the time model statistical items of the current tenant.

View	Description
GV$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in the current tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
GV$OB_PROCESSLIST	Displays the information about sessions on all OBServer nodes of the current tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays the session-level wait events of all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting.
GV$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of all sessions on all OBServer nodes.
GV$SYSTEM_EVENT	Displays all tenant-level wait events in the cluster.
GV$SESSTAT	Displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	Displays the information about tenant-level statistical events on all OBServer nodes.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in the current tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
V$OB_PROCESSLIST	Displays the information about sessions on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
V$STATNAME	Displays the definitions of all statistical events.
V$EVENT_NAME	Displays the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	Displays the details about the current wait events in each session. Each wait event has three parameters.
V$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of each session.
V$SESSTAT	Displays an overview of session-level statistical events.
V$SYSSTAT	Displays the information about tenant-level statistical events on the current OBServer node.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the progress of index creation in the cluster.
V$SESSION_LONGOPS	Displays the progress of index creation on the current OBServer node.

View	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View	Description
GV$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
V$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
GV$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.
V$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.

View	Description
GV$OB_MEMORY	Displays the tenant-level memory statistics.
V$OB_MEMORY	Displays the tenant-level memory statistics.
GV$OB_MEMSTORE	Displays the memory usage of all MemTables of all tenants on all OBServer nodes.
V$OB_MEMSTORE	Displays session-level MemStore statistics.
GV$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
V$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
GV$OB_SSTABLES	Displays the SSTables of the current tenant.
V$OB_SSTABLES	Displays the SSTables of the current tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View	Description
GV$OB_PLAN_CACHE_STAT	Displays the outlines of the current tenant. It is used for outline migration.
V$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache of the current tenant on all OBServer nodes.
GV$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan caches of all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans that are cached in the plan cache on the current OBServer node.
GV$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
V$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on the current OBServer node.
GV$OB_SQL_AUDIT	Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status.
V$OB_SQL_AUDIT	Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status.
GV$SQL_PLAN_MONITOR	Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan.
V$SQL_PLAN_MONITOR	Displays the operation-level statistics of slow queries. Each operation corresponds to one row in this view.
V$SQL_MONITOR_STATNAME	Displays the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	Displays the information about end-to-end diagnostics.

View	Description
GV$OB_LOG_STAT	Displays the Palf status.
V$OB_LOG_STAT	Displays the Palf status.

View	Description
GV$OB_RPC_OUTGOING	Displays the RPC sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the RPC receiving statistics of all OBServer nodes.
V$OB_RPC_OUTGOING	Displays the data sending status of all RPC packet codes in the current tenant on the current OBServer node.
V$OB_RPC_INCOMING	Displays the data receiving status of all RPC packet codes in the current tenant on the current OBServer node.

View	Description
GV$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
GV$OB_PARAMETERS	Displays the parameters on all OBServer nodes of the current tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
GV$OB_SERVERS	Displays the information about all OBServer nodes.
GV$OB_UNITS	Displays the information about the units on the OBServer nodes where the current tenant resides. You can view the units of all OBServer nodes in the current cluster from the `sys` tenant.
V$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
V$OB_PARAMETERS	Displays the parameters on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
V$OB_SERVERS	Displays the information about the current OBServer node.
V$OB_UNITS	Displays the information about the units on the current OBServer node.
GV$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$OB_COMPATIBILITY_CONTROL	Displays all features that support product behavior compatibility control based on the released OceanBase Database versions.

View	Description
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.
V$OB_SQLSTAT	Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.

View	Description
GV$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the current OBServer node.
GV$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the cluster.
V$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the current OBServer node.

View	Description
GV$OB_MERGE_INFO	Displays the statistics of compactions that are completed in the cluster.
V$OB_MERGE_INFO	Displays the statistics of compactions that are completed in the cluster.

View	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.
V$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.

View	Description
GV$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory.
V$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
V$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
V$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode.
V$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory.

View	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with encryption enabled.

View	Description
GV$LATCH	Displays the information about the latches on all OBServer nodes in the cluster.
V$LATCH	Displays the information about the latches on all OBServer nodes in the cluster.

View	Description
ALL_ALL_TABLES	Displays the object tables and relational tables accessible to the current user.
ALL_COL_COMMENTS	Displays the 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 the 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 the 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 columns are the same as those of the `ALL_ALL_TABLES` view.
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 columns are the same as those of the `ALL_ALL_TABLES` view except that it does not have the `OWNER` column.
USER_TABLES	Displays all tables owned by the current user.
USER_TABLESPACES	Displays the tablespaces accessible to the current user. Its columns are the same as those of the `DBA_TABLESPACES` view, except that it does not have the `PLUGGED_IN` column.
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 all views accessible to the current user.
DBA_VIEWS	Displays all views in the database. Its columns are the same as those of the `ALL_VIEWS` view.
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.
DBA_OB_SPATIAL_COLUMNS	Displays the database names, table names, data types, and spatial reference system (SRS) information corresponding to spatial index columns.

View	Description
DBA_OB_OUTLINES	Displays the information about the execution plan outlines in the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the 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	Description
DBA_SQL_PLAN_BASELINES	Displays the SQL plan baseline in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View	Description
DBA_CONTEXT	Displays the information about all context namespaces in the database.
DBA_OB_DATABASES	Displays the database metadata of the current tenant.
DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays the 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	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 columns are the same as those of the `ALL_ARGUMENTS` view.
DBA_PROCEDURES	Displays all available functions and procedures in the database as well as their properties. Its columns are the same as those of the `ALL_PROCEDURES` view.
DBA_SOURCE	Displays the text sources of all stored objects in the database. Its columns are the same as those of the `ALL_SOURCE` view.
USER_ARGUMENTS	Displays the arguments of the functions and procedures owned by the current user. Its columns are the same as those of the `ALL_ARGUMENTS` view, except that it does not have the `OWNER` column.
USER_PROCEDURES	Displays all functions and procedures owned by the current user, as well as their associated properties. Its columns are the same as those of the `ALL_PROCEDURES` view, except that it does not have the `OWNER` column.
USER_SOURCE	Displays the text sources of the stored objects owned by the current user. Its columns are the same as those of the `ALL_SOURCE` view, except that it does not have the `OWNER` column.
DBA_JOBS	Displays an overview of committed jobs.
USER_JOBS	Displays an overview of committed jobs.
DBA_JOBS_RUNNING	Displays ongoing jobs.

View	Description
DBA_OB_BACKUP_JOBS	Displays the backup jobs in the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs in the current tenant.
DBA_OB_BACKUP_TASKS	Displays the backup tasks in the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	Displays the history of 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 jobs.
DBA_OB_RESTORE_HISTORY	Displays the restore jobs that have been completed.
DBA_OB_ARCHIVE_DEST	Displays the configuration of archive paths.
DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations of backup and restore in the current tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations of backup and restore in the current tenant.
DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant.
DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of backup cleanup jobs in the current tenant.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup jobs that have been executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of the backup set/piece cleanup tasks that have been completed in the current 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.
DBA_OB_RECOVER_TABLE_JOBS	Displays the information about table-level restore jobs.
DBA_OB_IMPORT_TABLE_JOBS	Displays the information about import jobs.
DBA_OB_IMPORT_TABLE_TASKS	Displays the records of table-level import tasks.
DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.

View	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 subpartitions of the current database.
DBA_TAB_COL_STATISTICS	Displays the column statistics and histograms on all tables in the database.
DBA_TAB_HISTOGRAMS	Displays the table-level histograms on the current database.
DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
USER_PART_COL_STATISTICS	Displays the column statistics and histograms on partitions in the partitioned tables of the current user.
USER_PART_HISTOGRAMS	Displays the histograms on partitions of the current user.
USER_SUBPART_COL_STATISTICS	Displays the column statistics and histograms on subpartitions in the partitioned tables of the current user.
USER_SUBPART_HISTOGRAMS	Displays the histograms on subpartitions of the current user.
USER_TAB_COL_STATISTICS	Displays the column statistics and histograms on 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 in 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 in 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	Description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Displays all users in the database.
USER_USERS	Displays the information about the current user.
ALL_COL_PRIVS	Displays the column object grants for which the current user is the object owner, grantor, or grantee, and 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, and 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	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	Description
ALL_DEF_AUDIT_OPTS	Displays the default object-auditing options 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 the `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 and their corresponding 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	Description
ALL_INDEXES	Displays the columns of 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 the information about function-based indexes accessible to the current user in the database.
ALL_IND_PARTITIONS	Displays the information about index partitions accessible to the current user in the database.
ALL_IND_SUBPARTITIONS	Displays the 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 the information about all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays the information about all index partitions in the database.
DBA_IND_SUBPARTITIONS	Displays the 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 the information about function-based indexes owned by the current user in the database.
USER_IND_PARTITIONS	Displays the information about the index partitions owned by the current user in the database. This view does not have the `INDEX_OWNER` column compared with the `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS` views.
USER_IND_SUBPARTITIONS	Displays the information about all index subpartitions owned by the current user in the database. This view does not have the `INDEX_OWNER` column 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	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 the 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 information about partitions 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 the 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 of 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 the 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	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant.

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

View	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	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 triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.

View	Description
DBA_RECYCLEBIN	Displays the information about all recycle bins in the database.
USER_RECYCLEBIN	Displays the information about recycle bins owned by the current user. Its columns are the same as those of the `DBA_RECYCLEBIN` view, except that it does not have the `OWNER` column.

View	Description
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationships between the user and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays the 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 about each group of resource plan directives in the database.

View	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	Description
ALL_COLL_TYPES	Displays the user-defined collection types available in the database. Its columns 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 the user-defined collection types available in the database. Its columns 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	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	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	Description
DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream replicas in the current tenant.
DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of the table groups.
DBA_OB_TABLEGROUP_PARTITIONS	Displays the information about the partitions of partitioned table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the information about the subpartitions of partitioned table groups.
DBA_OB_TABLET_REPLICAS	Displays the 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	Description
DBA_WR_SNAPSHOT	Displays the snapshots of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persisted ASH data of the current tenant.
DBA_WR_STATNAME	Displays the names of system statistical items of the current tenant.
DBA_WR_SYSSTAT	Displays the details about system statistical items of the current tenant.
DBA_WR_CONTROL	Displays WR configurations.
DBA_WR_SYSTEM_EVENT	Displays the persisted tenant-level wait events of the current tenant.
DBA_WR_EVENT_NAME	Displays the persisted tenant-level wait events of the current tenant.
DBA_WR_SQLTEXT	Displays the SQL statements of the current tenant collected by WR.

View	Description
DBA_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in the current tenant.

View	Description
DBA_WR_SYS_TIME_MODEL	Displays the WR data for the time model statistical items of the current tenant.

View	Description
DBA_OB_TRANSFER_PARTITION_TASKS	Displays the ongoing partition transfer tasks in the current tenant.
DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the historical partition transfer tasks executed in the current tenant.

View	Description
DBA_SCHEDULER_JOBS	Displays the scheduler jobs accessible to the current user.
DBA_SCHEDULER_PROGRAM	Displays all scheduler programs in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	Displays all scheduler jobs in the current tenant.

View	Description
ALL_DB_LINKS	Displays all DBLinks accessible to the current user.
DBA_DB_LINKS	Displays all DBLinks created in the current tenant.
USER_DB_LINKS	Displays the DBLinks created by the current user.

View	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 all 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 columns are the same as those of the `ALL_TYPE_METHODS` view, except that it does not have the `OWNER` column.

View	Description
GV$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
GV$OB_PARAMETERS	Displays the parameters on all OBServer nodes of the current tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
V$OB_SERVER_SCHEMA_INFO	Displays the information about schemas on all OBServer nodes.
GV$OB_UNITS	Displays the information about the units on the OBServer nodes where the current tenant resid. You can view the units of all OBServer nodes in the current cluster from the `sys` tenant.
GV$SYSSTAT	Displays the system-level statistical events on all OBServer nodes.
GV$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$DML_STATS	Displays the information about the DML operations performed in the current user table.
V$GLOBALCONTEXT	Displays the `CLIENT_IDENTIFIER` values of the global context attributes accessible to the current session.
V$OB_KVCACHE	Displays the information about the KV cache on each OBServer node.
V$OB_PARAMETERS	Displays the parameters on the current OBServer node.
V$SYSSTAT	Displays the system-level statistical events on the current OBServer node.
V$OB_UNITS	Displays the information about the units on the current OBServer node.
V$VERSION	Displays the names and versions of all components of the database.
V$STATNAME	Displays the statistical items.

View	Description
GV$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View	Description
GV$OB_MEMORY	Displays the memory usage of each tenant on all OBServer nodes.
GV$OB_MEMSTORE	Displays the memory usage of all MemTables of all tenants on all OBServer nodes.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory.
GV$OB_SSTABLES	Displays the SSTables of the current tenant.
GV$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
V$OB_MEMSTORE_INFO	Displays the details about MemTables of all partitions of all tenants on all OBServer nodes.
V$OB_MEMORY	Displays the tenant-level memory statistics.
V$OB_MEMSTORE	Displays the memory usage of all MemTables of all tenants on the current OBServer node.
V$OB_SSTABLES	Displays the SSTables of the current tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan caches of all OBServer nodes.
GV$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes.
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache of the current tenant on all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans that are cached in the plan cache on the current OBServer node.
V$OB_PLAN_CACHE_PLAN_STAT	Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node.
V$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache of the current tenant on all OBServer nodes.
V$RSRC_PLAN	Displays the active resource plans on the current OBServer node.

View	Description
GV$OB_LOG_STAT	Displays the Palf status.
V$OB_LOG_STAT	Displays the Palf status.

View	Description
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on all OBServer nodes.
GV$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
GV$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX worker threads on the current OBServer node.
V$OB_PS_ITEM_INFO	Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
V$OB_PS_STAT	Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
V$SQL_MONITOR_STATNAME	Displays the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.

View	Description
GV$OB_PROCESSLIST	Displays the information about sessions on all OBServer nodes of the current tenant.
GV$SESSION_WAIT	Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting.
GV$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of all sessions on all OBServer nodes.
GV$SESSTAT	Displays the session-level statistics on all OBServer nodes.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$NLS_PARAMETERS	Displays the NLS parameters at the session level.
V$OB_PROCESSLIST	Displays the information about sessions on the current OBServer node.
V$SESSION_WAIT	Displays the information about the current or last wait events of all sessions on the current OBServer node, such as the event name and the amount of time spent on waiting.
V$SESSION_WAIT_HISTORY	Displays the latest 10 wait events of all sessions on the current OBServer node.
V$SESSTAT	Displays the session-level statistics on the current OBServer node.
V$EVENT_NAME	Displays the definitions of all wait events on the current OBServer node.

View	Description
GV$OB_SQL_AUDIT	Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status.
V$OB_SQL_AUDIT	Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status.
GV$SQL_PLAN_MONITOR	Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan.
V$SQL_PLAN_MONITOR	Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan.
GV$OB_FLT_TRACE_CONFIG	Displays the information about end-to-end diagnostics.

View	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.
V$OB_PX_WORKER_STAT	Displays the execution information of each PX worker thread in parallel execution.

View	Description
GV$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas.
V$OB_SQL_WORKAREA_MEMORY_INFO	Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory.
V$SQL_WORKAREA	Displays the workarea statistics of all operators previously subject to automatic SQL memory management.
V$SQL_WORKAREA_ACTIVE	Displays the workarea information of active operators.
V$SQL_WORKAREA_HISTOGRAM	Displays the cumulative execution statistics of all workareas.

View	Description
GV$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in the current tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays the system wait events of the current tenant on all OBServer nodes, including the number of occurrences, wait time, and number of timeouts of each type of wait event.
GV$GLOBAL_TRANSACTION	Displays the information about currently active global transactions.
V$OB_COMPACTION_PROGRESS	Displays the progress of OBServer node-level compactions in the current tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the suggestions on compactions.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level compaction history.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the information about the transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	Displays the system wait events of the current tenant on the current OBServer node, including the number of occurrences, wait time, and number of timeouts of each type of wait event.
V$GLOBAL_TRANSACTION	Displays the information about currently active global transactions.
GV$OB_GLOBAL_TRANSACTION	Displays the information about all eXtended Architecture (XA) transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	Displays the information about all XA transactions whose original scheduler is the current OBServer node.

View	Description
V$TIMEZONE_NAMES	Displays the valid time zone names.

View	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with encryption enabled.

View	Description
GV$DBLINK	Displays all DBLinks (the links with `IN_TRANSACTION` set to `YES`) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed.
V$DBLINK	Displays all DBLinks (the links with `IN_TRANSACTION` set to `YES`) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed.

View	Description
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.
V$OB_SQLSTAT	Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by `SQL_ID` and `Plan_Hash`.

View	Description
GV$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistical items of the current OBServer node.
GV$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the cluster.
V$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistical items of the current OBServer node.

Customer Stories

Documentation

Outline of system views

Views in the sys tenant

Dictionary views

Views related to tables and columns

Note

Views related to the InnoDB storage engine

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Views related to outlines

Views related to general database information

Views related to partitions

Views related to load balancing

Views related to full-text indexes

Note

Note

Note

Note

Note

Views related to sessions

Views related to backup and restore

Views related to statistics and histograms

Views related to tenants

Views related to resources

Views related to replicas and logs

Views related to WR

Views related to foreign keys

Note

Note

Views related to OBKV

Performance views

Views related to event statistics

Views related to monitoring statistics

Views related to I/O statistics

Views related to cache statistics

Views related to SQL statistics

Views related to log statistics

Views related to network statistics

Views related to sessions

Views related to database statistics

Views related to time model statistics

Views related to minor compactions

Views related to threads

Views related to workareas

Views related to encrypted tables

Views related to transactions

Views in a MySQL tenant

Dictionary views

Views related to the HELP command

Views related to SPM

Views related to privileges

Views related to OBKV

Views related to schedulers

Views related to storage

Views related to time zones

Views related to character sets

Views related to tables and columns

Note

Views related to the InnoDB storage engine

Note

Note

Note

Note

Note

Views in the `sys` tenant