Overview of system views|V4.4.2|OceanBase Database|docs|OceanBase Documentations

View name	Feature description
mysql.columns_priv	Query column privileges granted to a user.
mysql.default_roles	Displays the information about the role that is enabled by default for the user.
mysql.procs_priv	Stores the privilege information of stored procedures and functions.
mysql.role_edges	Displays the grant relationships between roles and users.
oceanbase.CDB_OB_DATABASE_PRIVILEGE	Displays the database privileges owned by users of each tenant.
oceanbase.CDB_OB_USERS	Displays user or role information under all tenants in the cluster.
oceanbase.DBA_OB_DATABASE_PRIVILEGE	Displays the database privileges owned by users in the current tenant.
oceanbase.DBA_OB_USERS	Displays the user and role information under the current tenant.
oceanbase.CDB_OB_SENSITIVE_COLUMNS	Displays all columns protected by sensitive data rules.
oceanbase.CDB_OB_SENSITIVE_RULES	Displays the definitions and attributes of all sensitive rules.
oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS	Displays all users or roles that have plaintext data access permissions on columns associated with a sensitive rule.

View name	Feature description
oceanbase.CDB_OB_AI_MODELS	Displays the AI model information for all tenants.
oceanbase.CDB_OB_AI_MODEL_ENDPOINTS	Displays the model access information for all tenants.
oceanbase.DBA_OB_AI_MODELS	Displays the AI model information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_ENDPOINTS	Displays the access information of queries in the current tenant model.

View name	Feature description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the current execution progress of a physical restore task.
oceanbase.CDB_OB_RESTORE_HISTORY	Indicates the status when a physical restore task is completed.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in a backup set.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the file status of the backup set.
oceanbase.CDB_OB_BACKUP_JOBS	Displays the backup job tasks for all tenants in the cluster. Each time a user initiates a backup task, a corresponding job record is created.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup job tasks for all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays the task-level backup tasks for all tenants in the cluster. Each task record corresponds to a backup set. There is a one-to-one correspondence between task records and job records.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the historical records of task-level backup tasks for all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup job tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the historical records of the tenant's own task-level backup tasks.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the file status of the backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the archive path configuration.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the archive path configuration.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the historical information about backup cleanup tasks executed under a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore operations under a tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the historical information about backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information of completed backup_set and backup_piece cleanup tasks for a 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 pieces in a 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 archives.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	Displays information related to table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information related to table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	Displays information related to the import task.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays information related to the import task.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	Displays records for table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of a table-level restore task.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of a table-level restore task.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	Displays the result of the import task.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the result of the import task.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	Displays the historical records of cross-tenant import tasks at the table level.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the historical records of cross-tenant import tasks at the table level.
oceanbase.CDB_OB_LS_HISTORY	Accessible only to the system tenant, displays all log streams that have existed in the history of all tenants.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS	Displays the log stream archiving progress for all tenants.
oceanbase.DBA_OB_LS_HISTORY	Displays the log streams that have existed in this tenant's history.
oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS	Displays the log stream archiving progress for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASKS	Displays the disaster recovery tasks at the replica level currently running for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY	Displays the execution history of disaster recovery tasks for the current tenant.

View name	Feature description
oceanbase.CDB_IND_COLUMNS	Displays the column information of index tables for all tenants.
oceanbase.CDB_INDEXES	Displays the index information for all tenants.
oceanbase.CDB_TABLES	Displays the TABLE information for all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	In the sys tenant, the TABLEGROUP and TABLE relationships of all tenants are displayed. Tables that are not part of a TABLEGROUP are not shown.
oceanbase.CDB_TAB_COLS	Displays the column information for tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the column information for tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns contained in the partitioning key for all partition objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	View the columns contained in the subpartitioning key for all partition objects in the database.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	Displays column validation and inconsistency information between index tables (including global indexes and local indexes) and the primary table.
oceanbase.CDB_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
information_schema.TABLESPACES	Information related to tablespaces. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

View name	Feature description
oceanbase.CDB_OB_CCL_RULES	Records the throttling rules for all tenants.
oceanbase.DBA_OB_CCL_RULES	Records the throttling rules for all tenants.

View name	Feature description
oceanbase.CDB_OB_CS_REPLICA_STATS	Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node for all tenants.
oceanbase.CDB_IND_SUBPARTITIONS	Query all index subpartitions in a database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the replica distribution information of log stream (LS) for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	The system tenant displays the meta information of table groups for all tenants, primarily showing the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	The system tenant displays the partition information of all tenant's partitioned table groups.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	The system tenant displays the subpartition information for all tenant's partitioned table groups.
oceanbase.CDB_OB_TABLET_TO_LS	The system tenant displays the tablet list for all tenants and the log stream information to which each tablet belongs.
oceanbase.CDB_OB_TABLET_REPLICAS	This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:`<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:`<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays a list of all tablets in the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the replica distribution information of log streams (LS) for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	Displays the status and recovery progress of the log stream.
oceanbase.DBA_OB_LS	Displays the status and recovery progress of the log stream.
oceanbase.CDB_OB_TABLE_SPACE_USAGE	Displays the size of all user tables under all tenants (based on the leader replica in a multi-replica environment).
oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN	Displays information about each log compaction in all tenants of the cluster.
oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN	Displays information about each log truncation for the current tenant.

View name	Feature description
oceanbase.CDB_IND_PARTITIONS	Displays the partition information of all tenant index tables.
oceanbase.CDB_IND_SUBPARTITIONS	Query all index subpartitions in a database.
oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information for all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of index tables for all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables for all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the subpartition information of partitioned tables for all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of partitioned tables for all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the subpartition information of partitioned tables for all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the partition information of an index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information of the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information for all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays user table partition information.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS	It displays the subpartition name, the table and partition names, their storage attributes, and`DBMS_STATS`The package generates statistics.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.
oceanbase.CDB_PART_KEY_COLUMNS	Displays the partitioning key information of all tenant's partition objects (partitioned tables and partitioned indexes).
oceanbase.CDB_SUBPART_KEY_COLUMNS	Displays the subpartitioning key information for partition objects (partitioned tables and partitioned indexes) of all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartition information of a table group with partitions.
oceanbase.DBA_OB_TABLEGROUPS	Displays the meta information of a table group, mainly its partition information.

View name	Feature description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights under all user tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	Displays the partition transfer tasks currently in progress for all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of all partition transfer tasks executed by tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the current partition transfer tasks being processed under this tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of transfer partition tasks executed for this tenant.
oceanbase.CDB_OB_BALANCE_JOBS	Displays all current load balancing jobs being executed by tenants. Each tenant can only have one load balancing job running at a time. Each load balancing job generates multiple load balancing tasks to perform specific load balancing operations.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY	Displays the load balancing work history executed by all tenants.
oceanbase.CDB_OB_BALANCE_TASKS	Displays all current load balancing tasks being executed by tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY	Displays the history of all load balancing tasks executed by tenants.
oceanbase.CDB_OB_TRANSFER_TASKS	Displays all current transfer tasks for all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY	Displays the history of all transfer tasks executed by tenants.
oceanbase.DBA_OB_BALANCE_JOBS	Displays the current load balancing job being executed by a tenant. Each tenant can only run one load balancing job at a time. Each load balancing job generates multiple load balancing tasks to perform specific load balancing operations.
oceanbase.DBA_OB_BALANCE_JOB_HISTORY	Displays the history of all current load balancing operations for a tenant.
oceanbase.DBA_OB_BALANCE_TASKS	Displays the current load balancing tasks being executed for the tenant. A tenant may have multiple load balancing tasks running concurrently, and these tasks all belong to the same load balancing job.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY	Displays the history of all load balancing tasks executed under a tenant.
oceanbase.DBA_OB_TRANSFER_TASKS	Displays the current transfer tasks being executed under this tenant.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY	Displays the history of all transfer tasks executed under this tenant.

View name	Feature description
CDB_OB_STORAGE_IO_USAGE	Displays the I/O operation statistics of all tenant object storage and cloud disks.

View name	Feature description
information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP	This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_TRX	This view displays information about current active transactions. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_LOCK_WAITS	This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_LOCKS	This view displays information about all locks currently held or waiting to be acquired. Note This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE	This view displays information about all cached pages in the buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE_LRU	This view displays the LRU sorted information of pages in the InnoDB buffer pool. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_POOL_STATS	Displays InnoDB buffer pool statistics. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP	Displays and compresses the status information related to InnoDB tables. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX	This view displays information related to operations on InnoDB tables and indexes. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX_RESET	Displays and resets the time information for InnoDB table and index-related operations, including display and compression. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_RESET	Displays the operation status related to compressing an InnoDB table. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMPMEM	This view displays the status of compressed pages in the InnoDB buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMPMEM_RESET	Displays the reset time of compressed pages in the InnoDB buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_DATAFILES	Displays the data file path information for the InnoDB files of each table and general tablespace. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_INDEXES	Displays InnoDB index metadata information. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_TABLES	Displays the metadata of an InnoDB table. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_COLUMNS	No feature description is provided in the document.
information_schema.INNODB_SYS_TABLESPACES	Displays the metadata of InnoDB table files and general tablespaces. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_TABLESTATS	Displays low-level status information of an InnoDB table. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_VIRTUAL	Displays the metadata of virtually generated columns in InnoDB. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_TEMP_TABLE_INFO	Displays information about InnoDB temporary tables created by active users. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_METRICS	Displays InnoDB performance information. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

View name	Feature description
oceanbase.CDB_OB_TEMP_FILES	view`CDB_OB_TEMP_FILES`Displays information related to temporary files.
oceanbase.DBA_OB_TEMP_FILES	view`DBA_OB_TEMP_FILES`Displays information about temporary files.

View name	Feature description
oceanbase.CDB_OB_KV_TTL_TASKS	Displays all the TTL tasks being executed by tenants under the current tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	This API is used to query the historical TTL tasks of all tenants under the system tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks currently being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	Displays the configuration parameter information for all OBKV tenant client connections on the current node.
GV$OB_KV_CLIENT_INFO	Displays the configuration parameter information for all OBKV tenant client connections.
oceanbase.CDB_OB_KV_REDIS_TABLE	It stores the specific commands for various data structures in Redis of all tenants and their corresponding storage table names.
oceanbase.DBA_OB_KV_REDIS_TABLE	Used to store the specific commands for various Redis data structures of the current tenant and their corresponding storage table names.

View name	Feature description
oceanbase.DBA_OB_OUTLINES	Displays the execution plan outline information for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the throttling rule outline information for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan and throttling rule outline historical information for this tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

View name	Feature description
information_schema.INNODB_FT_BEING_DELETED	Displays information about full-text indexes being dropped. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_CONFIG	This view displays the configuration information of the InnoDB full-text search engine. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_DELETED	Displays information about full-text indexes that have been marked for deletion. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_INDEX_CACHE	This view displays the cache status information of InnoDB full-text indexes. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_FIELDS	This view displays the metadata of key columns for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary. Note This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

View name	Feature description
oceanbase.DBA_INDEX_USAGE	Displays the data usage of indexes.
oceanbase.CDB_INDEX_USAGE	Displays the data usage of indexes.

View name	Feature description
oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS	view`CDB_SCHEDULER_JOB_RUN_DETAILS`Displays information about all scheduler jobs under all tenants.
oceanbase.DBA_SCHEDULER_WINDOWS	Displays information for all scheduler windows under the current tenant.
oceanbase.CBA_SCHEDULER_RUNNING_JOBS	Displays all jobs running under the tenant.
oceanbase.DBA_SCHEDULER_RUNNING_JOBS	Displays all jobs running under the tenant.

View name	Feature description
oceanbase.CDB_OB_SYNC_STANDBY_DEST	Displays the strong sync downstream information for all tenants.
oceanbase.CDB_OB_ACCESS_POINT	Displays the list of servers for the tenant entry. In a network-based physical standby database scenario, it is primarily used to obtain the IP address and SQL port number of the OBServer node where the primary tenant's replica resides.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE	Displays the log restore sources for all physical restore tenants and standby tenants.
oceanbase.CDB_OB_LS_REPLICA_TASKS	Displays the disaster recovery tasks at the replica level currently running for all tenants. This view is available only to the system tenant.
oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY	Displays the execution history of all tenant disaster recovery tasks.
oceanbase.DBA_OB_LOG_RESTORE_SOURCE	Displays the log restore source for this tenant.
oceanbase.DBA_OB_ACCESS_POINT	Displays the list of servers at the tenant entry for this tenant. In a network-based physical standby database scenario, it is primarily used to obtain the IP address and SQL port number of the OBServer node where the primary tenant's replica resides.
oceanbase.DBA_OB_SYNC_STANDBY_DEST	Displays the strong sync downstream information of the current tenant.

View name	Feature description
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the root service.

View name	Feature description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baseline of the SQL statement in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.
oceanbase.CDB_OB_SPM_EVO_RESULT	Displays the SPM plan evolution information for all tenants.
oceanbase.DBA_OB_SPM_EVO_RESULT	Displays the SPM plan evolution information of a tenant.

View name	Feature description
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	Accessible only to the system tenant, this view displays important cluster-level events. Currently, it only supports displaying cluster upgrade-related events.

View name	Feature description
information_schema.events	Records all event information.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history of an OBServer node.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY	Displays the historical operation records of all tenants in this cluster.
oceanbase.DBA_OB_TENANT_EVENT_HISTORY	Displays the historical operation records of the current tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants.

View name	Feature description
oceanbase.CDB_OB_DATABASES	The system tenant displays the database metadata of all tenants.
oceanbase.DBA_OB_DATABASES	Displays the database metadata of a tenant.
oceanbase.DBA_OB_ZONES	Displays information for all zones.

View name	Feature description
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG	Records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary.
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG	Records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary.

View name	Feature description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. This view shows the historical records of all tenants under the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants.

View name	Feature description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) on all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the historical table statistics for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays the optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS	Column-level statistics are displayed under the sys tenant.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	Query the historical collection execution of a table.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO	Displays the number of DML operations performed on each table under the current tenant since the last statistics collection, and indicates whether the current statistics have expired.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	Displays the execution status of historical collection tasks for the current tenant.

View name	Feature description
oceanbase.CDB_OB_EXTERNAL_RESOURCES	Displays all uploaded resource files under the sys tenant.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES	Displays the file list of external tables created by all tenants.
oceanbase.DBA_OB_EXTERNAL_RESOURCES	Displays the uploaded resource files.
oceanbase.DBA_OB_EXTERNAL_TABLE_FILES	Displays the file list corresponding to all external tables created under the current tenant.

View name	Feature description
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	Displays the persisted ASH data for all tenants.
oceanbase.CDB_WR_CONTROL	Displays the configuration information related to write requests.
oceanbase.CDB_WR_EVENT_NAME	Displays the names of persistent tenant-level wait events for all tenants.
oceanbase.CDB_WR_SNAPSHOT	Display all tenants'`SNAPSHOT`Information.
oceanbase.CDB_WR_SQLSTAT	This view displays basic performance statistics for all SQL statements executed by tenants. Each SQL statement is represented as a row (that is, each`SQL_ID` + `Plan_Hash`(The unique value of is one row.)
oceanbase.CDB_WR_SQLTEXT	Displays the SQL text collected for write operations of all tenants.
oceanbase.CDB_WR_STATNAME	Displays the names of system statistics for all tenants.
oceanbase.CDB_WR_SYS_TIME_MODEL	This API is used to display the write data of all tenant time model statistics.
oceanbase.CDB_WR_SYSSTAT	Displays detailed system statistics for all tenants.
oceanbase.CDB_WR_SYSTEM_EVENT	This API is used to display the persistent tenant-level wait event information for all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persistent ASH data for this tenant.
oceanbase.DBA_WR_CONTROL	Displays the configuration information related to write requests.
oceanbase.DBA_WR_EVENT_NAME	Displays the names of persistent tenant-level wait events for the current tenant.
oceanbase.DBA_WR_SNAPSHOT	Display the of this tenant.`SNAPSHOT`Information.
oceanbase.DBA_WR_SQLSTAT	This view displays basic performance statistics for SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table.`SQL_ID` + `Plan_Hash`Each unique value corresponds to one row.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL text collected for write operations of the current tenant.
oceanbase.DBA_WR_STATNAME	Displays the name of the system statistic item for the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the write data statistics of the time model for the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays detailed system statistics for the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT	This API is used to display the persistent tenant-level wait event information for the current tenant.
oceanbase.CDB_WR_SQL_PLAN	This view displays the GV$OB_SQL_PLAN data collected by WR.
oceanbase.DBA_WR_SQL_PLAN	This view displays the GV$OB_SQL_PLAN data collected by WR.

View name	Feature description
information_schema.INNODB_SYS_FOREIGN	Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_FOREIGN_COLS	This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

View name	Feature description
oceanbase.CDB_MVIEW_DEPS	Displays the relationships between materialized views and their dependent objects across all tenants.
oceanbase.CDB_MVIEW_RUNNING_JOBS	This API is used to display all materialized view-related tasks currently in progress for all tenants, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays materialized view log information.
oceanbase.DBA_MVIEW_RUNNING_JOBS	Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	Displays information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays basic timing statistics for materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	The system-wide default value for the historical statistics refresh attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.
oceanbase.CDB_MVIEW_LOGS	This API is used to display the materialized view log information of all tenants.
oceanbase.CDB_MVIEWS	Displays information about all materialized views.
oceanbase.CDB_MVREF_CHANGE_STATS	This view displays statistics related to materialized view refreshes.
oceanbase.CDB_MVREF_RUN_STATS	It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
oceanbase.CDB_MVREF_STATS	This view displays basic timing statistics for materialized view refreshes.
oceanbase.CDB_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS	The system-wide default value for the historical statistics refresh attribute of materialized views.
oceanbase.CDB_MVREF_STMT_STATS	Describes the information associated with the refresh statement.

View name	Feature description
oceanbase.CDB_OB_VECTOR_INDEX_TASKS	view`CDB_OB_VECTOR_INDEX_TASKS`Displays information about all vector index partition rebuilding tasks under all tenants in the cluster.
oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY	view`CDB_OB_VECTOR_INDEX_TASK_HISTORY`Displays the historical information of all vector index partition rebuilding tasks under all tenants in the cluster.
oceanbase.DBA_OB_VECTOR_INDEX_TASKS	View`DBA_OB_VECTOR_INDEX_TASKS`Displays information about all vector index partition rebuilding tasks under the current tenant.
oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY	view`DBA_OB_VECTOR_INDEX_TASK_HISTORY`Displays the historical information of all vector index partition rebuilding tasks for the current tenant.

View name	Feature description
oceanbase.CDB_OB_MAJOR_COMPACTION	The system tenant displays the global major compaction information for all tenants.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	The system tenant displays the major compaction information for each zone of all tenants.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the tenant.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated during a major freeze.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated during a major freeze.

View name	Feature description
oceanbase.DBA_OBJECTS	Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	The system tenant displays the object information for all tenants.
oceanbase.DBA_OB_TENANTS	This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by`TENANT_TYPE`Columns are used to distinguish tenant types.
oceanbase.DBA_OB_TENANT_JOBS	Displays task information at the tenant level.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the system variable information of all tenants under the sys tenant.
oceanbase.DBA_OB_SYS_VARIABLES	Displays the configurations of system variables for the current tenant, including hidden variables that start with an underscore (_).

View name	Feature description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays the resource pool information for all tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays all UNIT-related tasks.
oceanbase.DBA_OB_UNITS	Display the UNIT information of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.
CDB_OB_RSRC_DIRECTIVES	Displays the resource configuration parameters of all tenants in the Resource Manager.

View name	Feature description
oceanbase.CDB_OB_AUTO_INCREMENT	Displays information about all auto-increment columns in the cluster. This view is visible only to the system tenant.
oceanbase.DBA_OB_AUTO_INCREMENT	Displays information about all auto-increment columns in the current tenant.

View name	Feature description
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS	Accessible only by the system tenant, this view displays the arbitration service tasks currently running for the current tenant and its corresponding user tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY	Accessible only to the system tenant, this view displays the history of arbitration service tasks executed by all tenants.
oceanbase.DBA_OB_ARBITRATION_SERVICE	This API is accessible only by the system tenant and displays the arbitration service configuration information of the current cluster.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS	Displays the arbitration service tasks currently running for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	Displays the history of arbitration service tasks executed by the current tenant.

View name	Feature description
GV$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
GV$OB_ACTIVE_SESSION_HISTORY	This API is used to display the active session history of all OBServer nodes under all tenants.
V$OB_ACTIVE_SESSION_HISTORY	This API is used to display the active session history on the current OBServer node for all tenants.

View name	Feature description
GV$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client for all tenants.
V$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client for all tenants.

View name	Feature 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 name	Feature description
GV$OB_LOG_STAT	Displays the status of Palf.
GV$OB_LS_SNAPSHOTS	Displays information about the log stream snapshots stored persistently in all units.
V$OB_LOG_STAT	Displays the status of Palf.

View name	Feature description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information for all tenants.

View name	Feature description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on the current OBServer node.
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 name	Feature description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache for the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache across all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of the current server.

View name	Feature 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 name	Feature description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	This API is used to display the memory usage of the MemTable for all tenants on all servers.
V$OB_MEMSTORE	Displays the statistics of the tenant-level MemStore.
GV$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
GV$OB_SSTABLES	Displays the SSTable information of a tenant.
V$OB_SSTABLES	Displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	It displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This API is used to display the memory usage of each tenant in the current observer process.

View name	Feature description
GV$OB_KV_GROUP_COMMIT_STATUS	In the sys tenant, view`GV$OB_KV_GROUP_COMMIT_STATUS`You can access the group commit status information for all OBKV tenant client connections.
V$OB_KV_GROUP_COMMIT_STATUS	In the sys tenant, view`V$OB_KV_GROUP_COMMIT_STATUS`You can access the group commit status information for all OBKV tenant client connections on the current node.
V$OB_VECTOR_MEMORY	Displays detailed statistics on the memory usage of vector indexes for all tenants.

View name	Feature description
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.

View name	Feature description
GV$OB_PX_P2P_DATAHUB	Displays information related to data transfer operations during parallel execution.
GV$OB_PX_TARGET_MONITOR	Displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the PX thread usage on the OBServer node.

View name	Feature description
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.

View name	Feature description
GV$LATCH	View the latch information of all OBServer nodes in the cluster.
V$LATCH	A view showing the latch information of all OBServer nodes in the cluster.

View name	Feature description
GV$OB_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays session-level wait events for all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	This view displays information about the last 10 wait events for all sessions on all servers.
GV$SYSTEM_EVENT	Displays wait events at the tenant level for all tenants in the cluster.
GV$SESSTAT	Statistics events at the session level for all OBServer nodes.
GV$SYSSTAT	Displays tenant-level statistical event information on all servers.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
V$STATNAME	This topic describes all statistical events.
V$EVENT_NAME	The following table describes the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	The following table describes the parameters of each event.
V$SESSION_WAIT_HISTORY	Details of the events currently being waited on by each session, including the last 10 such events.
V$SESSTAT	Displays the overview of statistical events at the session level.
V$SYSSTAT	Displays tenant-level statistical event information on the current server.
V$SYSTEM_EVENT	Statistics on tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in a cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Feature description
GV$OB_SQL_AUDIT	It displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on the current server.

View name	Feature description
GV$OB_SESSION	Records session information created on all servers.
V$SESSION_EVENT	Displays the wait events that occur for each session.

View name	Feature description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_SERVERS	Displays information about all OBServer nodes.
GV$OB_UNITS	Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on this OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVERS	Displays information about the current OBServer node.
V$OB_UNITS	Displays the unit information of the current OBServer node.
GV$DML_STATS	Displays DML information in the current user's tables.
V$DML_STATS	Displays DML information in the current user's tables.
V$OB_COMPATIBILITY_CONTROL	This topic describes the features that can be controlled for compatibility with product behavior based on the OceanBase Database release version.

View name	Feature description
GV$OB_RPC_OUTGOING	The RPC sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING	This API is used to display the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics on the number of RPC packets sent by different tenant RPC packet codes on the OBServer node.
V$OB_RPC_INCOMING	This metric is used to count the number of RPC packets received by different tenant RPC packet codes on the OBServer node.

View name	Feature description
GV$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays statistics from all workareas executed previously, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This API is used to query general information about the SQL Workarea, such as the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory management.
V$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays statistics from all previous workareas, such as the number of times operations were processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
V$OB_SQL_WORKAREA_MEMORY_INFO	This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory.

View name	Feature description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	A histogram that shows the query execution time of all nodes in all tenants.
GV$OB_RES_MGR_SYSSTAT	This API is used to display the statistics of resource groups in all OBServer nodes of all tenants.
GV$OB_SESS_TIME_MODEL	Displays time model statistics at the session level in the cluster.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in a cluster. Each SQL statement is represented by a row.`SQL_ID` + `Plan_Hash`Each unique value corresponds to one row.
GV$OB_SYS_TIME_MODEL	This API is used to display time model statistics at the tenant level in a cluster.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	A histogram that shows the query execution time of current nodes for all tenants.
V$OB_RES_MGR_SYSSTAT	This API is used to display the statistics of resource groups in the current OBServer for all tenants.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (that is, each`SQL_ID` + `Plan_Hash`The unique value of the primary key is one row).
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.

View name	Feature description
GV$OB_HNSW_INDEX_INFO	This view displays the basic information and real-time status of HNSW vector indexes for all tenants across all OBServer nodes.
GV$OB_IVF_INDEX_INFO	This view displays the basic information and real-time status of IVF vector indexes for all tenants across all OBServer nodes.
GV$OB_VECTOR_MEMORY	Displays detailed statistics on the memory usage of vector indexes for all tenants.
V$OB_HNSW_INDEX_INFO	This view displays the basic information and real-time status of HNSW vector indexes for all tenants on the current OBServer node.
V$OB_IVF_INDEX_INFO	This view displays the basic information and real-time status of IVF vector indexes for all tenants on the current OBServer node.

View name	Feature description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
GV$OB_TENANT_RUNTIME_INFO	Displays information related to queues and thread quotas in the tenant's thread pool.
V$OB_TENANT_RUNTIME_INFO	Displays information related to queues and thread quotas in the tenant's thread pool.

View name	Feature description
GV$SQL_PLAN_MONITOR	This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan.
V$SQL_PLAN_MONITOR	Statistics at the operation level for slow queries, with one statistic record per operation.
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of the`OTHERSTAT_X_ID`The meaning of the numbers in the fields.

View name	Feature description
GV$OB_MERGE_INFO	Displays statistics related to completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics related to completed compactions in the OceanBase cluster.
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress information of a tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress information of a tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.

View name	Feature description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of all tenants.
GV$OB_FUNCTION_IO_STAT	Displays the IO statistics at the function level for all tenants across all OBServer nodes.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group for all tenants on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the I/O statistics at the function level for all tenants on the current OBServer node.

View name	Feature description
mysql.db	Displays database-level privilege information (VIRTUAL_TABLE).
mysql.user	Used to record user-level privilege information (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privilege information.
information_schema.SCHEMA_PRIVILEGES	Describes database privilege information.
information_schema.TABLE_PRIVILEGES	Records table privilege information.
information_schema.USER_PRIVILEGES	Records user permission information.
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts for different users.
information_schema.ROLE_TABLE_GRANTS	It displays the table-level privileges of activated roles granted to the user in the current session, as well as the table-level privileges of other roles granted to these roles.
information_schema.ROLE_COLUMN_GRANTS	It displays the column privileges of activated roles granted to the user in the current session, as well as the column privileges of other roles granted to these roles.
information_schema.ROLE_ROUTINE_GRANTS	It displays the routine permission information of activated roles granted to the user in the current session, as well as the routine permission information of other roles granted to these roles.
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	This API is used to display information such as the list of CA root certificates trusted by the OBServer cluster and their expiration dates.
oceanbase.DBA_OB_SENSITIVE_COLUMNS	Displays all columns protected by sensitive data rules.
oceanbase.DBA_OB_SENSITIVE_RULES	Displays the definitions and attributes of all sensitive rules.
oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS	Displays all users or roles that have plaintext data access permissions on columns associated with a sensitive rule.

View name	Feature description
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup job tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the historical records of backup job tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the historical records of the tenant's own task-level backup tasks.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the file status of the backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the archive path configuration.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information of backup destinations used for backup and restore operations under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the historical information about backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information of completed backup_set and backup_piece cleanup tasks for a 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 pieces in a backup set.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information related to table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays information related to the import task.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of a table-level restore task.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the result of the import task.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the historical records of cross-tenant import tasks at the table level.

View name	Feature description
information_schema.COLUMNS	Records column information.
information_schema.STATISTICS	Records table index information.
information_schema.TABLES	Records table information.
information_schema.VIEWS	Record view information.
information_schema.VIEW_TABLE_USAGE	Displays information about the tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns contained in the partitioning key for all partition objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	View the columns contained in the subpartitioning key for all partition objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
oceanbase.DBA_OB_TABLE_SPACE_USAGE	Displays the size of all user tables under the current tenant (based on the leader replica in a multi-replica environment).
information_schema.TABLESPACES	Information related to tablespaces. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

View name	Feature description
information_schema.TRIGGERS	Displays the CREATE TRIGGER statement used to create a trigger.

View name	Feature description
mysql.proc	Displays information about the stored procedure.
mysql.func	No feature description is provided in the document.
information_schema.ENGINES	Records information related to the storage engine.
information_schema.PARAMETERS	Provides information about stored procedure parameters and return values.
information_schema.ROUTINES	Provides information related to stored procedures.

View name	Feature description
oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights set under the current user tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the current partition transfer tasks being processed under this tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of transfer partition tasks executed for this tenant.

View name	Feature description
information_schema.PARTITIONS	Records partition information.
oceanbase.DBA_IND_PARTITIONS	Displays the partition information of an index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information of the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information for all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays user table partition information.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS	It displays the subpartition name, the name of the table and its partition, its storage attributes, and`DBMS_STATS`The package generates statistics.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartition information of a table group with partitions.
oceanbase.DBA_OB_TABLEGROUPS	Displays the meta information of a table group, mainly its partition information.

View name	Feature description
oceanbase.DBA_OB_CS_REPLICA_STATS	Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node of the tenant.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:`<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays a list of all tablets in the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the replica distribution information of log streams (LS) for the current tenant.

View name	Feature description
mysql.help_topic	With the other three tables`mysql.help_category`、`mysql.help_relation`、`mysql.help_keyword`Generate help commands together.
mysql.help_category	With the other three tables`mysql.help_relation`、`mysql.help_topic`、`mysql.help_keyword`Collaborate to generate Help commands.
mysql.help_keyword	With the other three tables`mysql.help_relation`、`mysql.help_topic`、`mysql.help_category`Generate the help command together.
mysql.help_relation	With the other three tables`mysql.help_category`、`mysql.help_topic`、`mysql.help_keyword`Generate the help command together.

View name	Feature description
DBA_OB_STORAGE_IO_USAGE	Displays the I/O operation statistics of the current tenant's object storage and cloud disk.

View name	Feature description
information_schema.INNODB_LOCK_WAITS	This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_LOCKS	This view displays information about all locks currently held or waiting to be acquired. Note This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP	This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_TRX	This view displays information about current active transactions. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE	This view displays information about all cached pages in the buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE_LRU	This view displays the LRU sorted information of pages in the InnoDB buffer pool. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_BUFFER_POOL_STATS	Displays InnoDB buffer pool statistics. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP	Displays and compresses the status information related to InnoDB tables. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX	This view displays information related to operations on InnoDB tables and indexes. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX_RESET	Displays and resets the time information for InnoDB table and index-related operations, including display and compression. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_RESET	Displays the operation status related to compressing an InnoDB table. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMPMEM	This view displays the status of compressed pages in the InnoDB buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMPMEM_RESET	Displays the reset time of compressed pages in the InnoDB buffer pool. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_DATAFILES	Displays the data file path information for the InnoDB files of each table and general tablespace. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_INDEXES	Displays InnoDB index metadata information. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_TABLES	Displays the metadata of an InnoDB table. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_TABLESPACES	Displays the metadata of InnoDB table files and general tablespaces. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_TABLESTATS	Displays low-level status information of an InnoDB table. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_VIRTUAL	Displays the metadata of virtually generated columns in InnoDB. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_TEMP_TABLE_INFO	Displays information about InnoDB temporary tables created by active users. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_METRICS	Displays InnoDB performance information. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

View name	Feature description
information_schema.ST_GEOMETRY_COLUMNS	Displays tables that contain spatial data columns and spatial data types.
information_schema.ST_SPATIAL_REFERENCE_SYSTEMS	Displays the spatial reference coordinate systems currently supported by the system.

View name	Feature description
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks currently being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	Displays the configuration parameter information of the current node's OBKV tenant client connection.
GV$OB_KV_CLIENT_INFO	Displays the configuration parameters of the client connection for this OBKV tenant.
oceanbase.DBA_OB_KV_REDIS_TABLE	Used to store the specific commands for various Redis data structures of the current tenant and their corresponding storage table names.

View name	Feature description
oceanbase.DBA_OB_OUTLINES	Displays the execution plan outline information for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the throttling rule outline information for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan and throttling rule outline historical information for this tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

View name	Feature description
information_schema.INNODB_FT_BEING_DELETED	Displays information about full-text indexes being dropped. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_CONFIG	This view displays the configuration information of the InnoDB full-text search engine. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_DELETED	Displays information about full-text indexes that have been marked for deletion. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_FT_INDEX_CACHE	This view displays the cache status information of InnoDB full-text indexes. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_FIELDS	This view displays the metadata of key columns for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary. Note This view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.

View name	Feature description
DBA_OB_SYNC_STANDBY_DEST	Displays the strong sync downstream information of the current tenant.

View name	Feature description
oceanbase.DBA_SCHEDULER_JOBS	Displays information about all scheduler jobs in the database.
oceanbase.DBA_SCHEDULER_RUNNING_JOBS	Displays all jobs running under the tenant.

View name	Feature description
information_schema.events	Records all event information.

View name	Feature description
mysql.time_zone	Used to display time zone-related information (SYSTEM_VIEW).
mysql.time_zone_name	Used to record the name of the time zone (SYSTEM_VIEW).
mysql.time_zone_transition	`mysql.time_zone_transition`is a system view used to record timezone conversion information.
mysql.time_zone_transition_type	Used to record the time zone conversion type (SYSTEM_VIEW).

View name	Feature description
information_schema.GLOBAL_STATUS	Records the global state information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Records global variable information.
information_schema.SCHEMATA	Records database metadata.
oceanbase.DBA_OB_DATABASES	Displays the database metadata of a tenant.

View name	Feature description
mysql.audit_log_filter	Displays the definition of an audit filter.
mysql.audit_log_user	Displays the mapping relationship between audit filters and users.

View name	Feature description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baseline of the SQL statement in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.
oceanbase.DBA_OB_SPM_EVO_RESULT	Displays the SPM plan evolution information of a tenant.

View name	Feature description
information_schema.SESSION_STATUS	Records session status information, such as the current number of active connections and database uptime.
information_schema.SESSION_VARIABLES	Variable information of the session.

View name	Feature description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) on all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the historical table statistics for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays the optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of tables in the database.
information_schema.QUERY_RESPONSE_TIME	It displays data types such as RESPONSE TIME histograms for monitoring by Prometheus.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	Query the historical collection execution of a table.
oceanbase.CDB_OB_AUX_STATISTICS	Displays auxiliary statistics for all tenants.
information_schema.OPTIMIZER_TRACE	This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

View name	Feature description
oceanbase.DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays materialized view log information.
oceanbase.DBA_MVIEW_RUNNING_JOBS	Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	Displays information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays basic timing statistics for materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	The system-wide default value for the historical statistics refresh attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.

View name	Feature description
oceanbase.DBA_WR_SNAPSHOT	Displays the of the current tenant.`SNAPSHOT`Information.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persistent ASH data for this tenant.
oceanbase.DBA_WR_STATNAME	Displays the name of the system statistic item for the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays detailed system statistics for the current tenant.
oceanbase.DBA_WR_CONTROL	Displays the configuration information related to write requests.
oceanbase.DBA_WR_SYSTEM_EVENT	This API is used to display the persistent tenant-level wait event information for the current tenant.
oceanbase.DBA_WR_EVENT_NAME	Displays the names of persistent tenant-level wait events for the current tenant.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL text collected for write operations of the current tenant.
oceanbase.DBA_WR_SQLSTAT	This view displays basic performance statistics for SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table.`SQL_ID` + `Plan_Hash`The unique value of the column is one row).
oceanbase.DBA_WR_SYS_TIME_MODEL	This table displays the write data of time model statistics for the current tenant.
oceanbase.DBA_WR_SQL_PLAN	This view displays the GV$OB_SQL_PLAN data collected by WR.

View name	Feature description
information_schema.INNODB_SYS_FOREIGN	Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure.
information_schema.INNODB_SYS_FOREIGN_COLS	This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.

View name	Feature description
information_schema.PROCESSLIST	Provides information about running threads.

View name	Feature description
information_schema.CHECK_CONSTRAINTS	Display`CREATE TABLE`During operations, the constraint information related to the table and columns.
information_schema.KEY_COLUMN_USAGE	Records the constraint information of the key in the column.
information_schema.REFERENTIAL_CONSTRAINTS	Displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Describes the table constraints.

View name	Feature description
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information for this tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the tenant.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated during a major freeze.

View name	Feature description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.
DBA_OB_RSRC_DIRECTIVES	Displays the resource configuration parameters of the current tenant in the Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	Displays the I/O resource configuration of the current tenant in the Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationship between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all system-defined resource management plans.
DBA_RSRC_PLAN_DIRECTIVES	Displays the details of each set of resource plan directives in the database.

View name	Feature description
oceanbase.DBA_OBJECTS	Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by`TENANT_TYPE`Columns are used to distinguish tenant types.
oceanbase.DBA_OB_LICENSE	Displays the information about the license currently loaded by the user.

View name	Feature description
information_schema.CHARACTER_SETS	Records the character set information of OceanBase Database.
information_schema.COLLATIONS	Records the comparison method information for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Records the correspondence between characters and collations.

View name	Feature description
GV$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
V$OB_ACTIVE_SESSION_HISTORY	This API is used to display the active session history on the current OBServer node for the current tenant.
GV$OB_ACTIVE_SESSION_HISTORY	This API is used to query the active session history of all OBServer nodes in the current tenant.

View name	Feature description
GV$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client by the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client by the current tenant.

View name	Feature 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 name	Feature description
GV$OB_LOG_STAT	Displays the status of Palf.
V$OB_LOG_STAT	Displays the status of Palf.

View name	Feature description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information of the current tenant.

View name	Feature description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on the current OBServer node.

View name	Feature 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 name	Feature description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	This API is used to display the memory usage of the MemTable for all tenants on all servers.
V$OB_MEMSTORE	Displays the statistics of the tenant-level MemStore.
GV$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
GV$OB_SSTABLES	Displays the SSTable information of a tenant.
V$OB_SSTABLES	Displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	It displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This API is used to display the memory usage of each tenant in the current observer process.

View name	Feature description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.

View name	Feature description
GV$OB_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays session-level wait events for all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	This view displays information about the last 10 wait events for all sessions on all servers.
GV$SYSTEM_EVENT	Displays wait events at the tenant level for all tenants in the cluster.
GV$SESSTAT	Statistics events at the session level for all OBServer nodes.
GV$SYSSTAT	Displays tenant-level statistical event information on all servers.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$STATNAME	This topic describes all statistical events.
V$EVENT_NAME	The following table describes the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	The following table describes the parameters of each event.
V$SESSION_WAIT_HISTORY	Details of the events currently being waited on by each session, including the last 10 such events.
V$SESSTAT	Displays the overview of statistical events at the session level.
V$SYSSTAT	Displays tenant-level statistical event information on the current server.
V$SYSTEM_EVENT	Statistics on tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in a cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Feature description
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
V$OB_PARAMETERS	Displays the parameter information on this OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_UNITS	Displays the unit information of the current OBServer node.
GV$DML_STATS	Displays DML information in the current user's tables.
V$DML_STATS	Displays DML information in the current user's tables.
V$OB_COMPATIBILITY_CONTROL	This topic describes the features that can be controlled for compatibility with product behavior based on the OceanBase Database release version.
GV$OB_KV_CONNECTIONS	This view is used to view the statistics of OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	This view is used to view the statistics of OBKV connections held by the current server.

View name	Feature description
GV$LATCH	View the latch information of all OBServer nodes in the cluster.
V$LATCH	A view showing the latch information of all OBServer nodes in the cluster.

View name	Feature description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache for the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache across all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_SESSION_PS_INFO	Displays the PS information opened by all sessions of the current tenant.
V$OB_SESSION_PS_INFO	This API is used to display the PS information opened by all sessions of the current OBServer tenant.
GV$OB_PX_TARGET_MONITOR	Displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the PX thread usage on the OBServer node.
GV$OB_SQL_AUDIT	It displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	It displays statistics such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan.
V$SQL_PLAN_MONITOR	Statistics at the operation level for slow queries, with one statistic record per operation.
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of the`OTHERSTAT_X_ID`The meaning of the numbers in the fields.
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.
GV$OB_PLAN_CACHE_REFERENCE_INFO	Displays the plan cache reference information for all tenants across all OBServer nodes.
V$OB_PLAN_CACHE_REFERENCE_INFO	Displays the plan cache reference information for all tenants on the current OBServer node.

View name	Feature description
GV$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays statistics from all workareas executed previously, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This API is used to query general information about the SQL Workarea, such as the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory management.
V$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays statistics from all previous workareas, such as the number of times operations were processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions.
V$OB_SQL_WORKAREA_MEMORY_INFO	This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory.

View name	Feature description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	A histogram that shows the query execution time of all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistical information of resource groups on all OBServer nodes in the current tenant.
GV$OB_SQLSTAT	This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented by a row (that is, each`SQL_ID` + `Plan_Hash`The unique value of the column is one row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented as a row (that is, each`SQL_ID` + `Plan_Hash`Each unique value corresponds to one row.
GV$OB_SESS_TIME_MODEL	Displays time model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This API is used to display time model statistics at the tenant level in a cluster.
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT	This API is used to display the statistics of resource groups in the current OBServer node under the current tenant.

View name	Feature description
GV$OB_RPC_OUTGOING	The RPC sending statistics of all OBServer nodes.
GV$OB_RPC_INCOMING	This API is used to display the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics on the number of RPC packets sent by different tenant RPC packet codes on the OBServer node.
V$OB_RPC_INCOMING	This metric is used to count the number of RPC packets received by different tenant RPC packet codes on the OBServer node.

View name	Feature description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.

View name	Feature description
GV$OB_MERGE_INFO	Displays statistics related to completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics related to completed compactions in the OceanBase cluster.
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress information of a tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress information of a tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.
V$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.

View name	Feature description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	Displays the I/O statistics at the function level for the current tenant across all OBServer nodes.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group for the current tenant on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the IO statistics at the function level for the current tenant on the current OBServer node.
GV$OB_CGROUP_CONFIG	Quickly query the cgroup configurations of all OBServer nodes.
V$OB_CGROUP_CONFIG	This API is used to quickly query the cgroup configuration of the current OBServer node.

View name	Feature description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Display all users in the database.
USER_USERS	Displays information about the current user.
ALL_COL_PRIVS	The current user has column object privileges on the object as the owner, grantor, or grantee. Column object privileges have been granted to the role or the grantee with PUBLIC.
ALL_TAB_PRIVS	The current user is the owner of the object, or the grantor of the object privilege, or the grantee of the object privilege. The grantee of the object privilege is an activated role or the PUBLIC role.
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 privileges currently held by the user.
USER_COL_PRIVS	Displays the columns that indicate whether the current user is the object owner, grantor, or grantee for the column object.
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 a role. Only information about the roles that users can access is provided.
ROLE_SYS_PRIVS	Displays the system privileges granted to a role.
ROLE_ROLE_PRIVS	Displays roles that have granted other roles. Only information about the roles that a user can access is provided.
DBA_ROLE_PRIVS	Displays the roles granted to all users and the roles in the database.
DBA_ROLES	Displays all roles present in the database.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.
DBA_OB_DATABASE_PRIVILEGE	Displays the permissions that the current tenant has to control the current user.
DBMS_LOCK_ALLOCATED	Displays the applied-for but unexpired`DBMS_LOCK`Information.
PROXY_USERS	Displays the proxy information between users.
DBA_OB_USER_DEFINED_RULES	Records the rules for custom rewriting SQL statements under the current tenant.
DBA_OB_SENSITIVE_COLUMNS	Displays all columns protected by sensitive data rules.
DBA_OB_SENSITIVE_RULES	Displays the definitions and attributes of all sensitive rules.
DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS	Displays all users or roles that have plaintext data access permissions on columns associated with a sensitive rule.

View name	Feature description
ALL_POLICIES	Displays the access control policies that the current user has access to. When applying access control to a table, you can create multiple policies for that table.
ALL_POLICY_CONTEXTS	Displays the context information of views accessible to the current user. When accessing a view, the corresponding policy group is applied based on the value of this context.
ALL_POLICY_GROUPS	Displays the policy group information for all views accessible to the current user. Combined with policy contexts, this enables different policies to take effect for different users.
ALL_SEC_RELEVANT_COLS	Displays information about all columns associated with policies in the tables or views accessible to the current user. A column is associated with a column-level policy, and when that column is accessed, the corresponding policy takes effect.
USER_POLICIES	Displays the access control policies owned by the current user. When applying access control to a table, multiple policies can be created for that table.
USER_POLICY_CONTEXTS	Displays the context information of the views owned by the current user. When accessing a view, the corresponding policy group is applied based on the value of this context.
USER_POLICY_GROUPS	Displays the policy group information of the views owned by the current user. Together with the policy context, this enables different policies to take effect for different users.
USER_SEC_RELEVANT_COLS	Displays information about all columns associated with policies in the tables or views owned by the current user. A column is associated with a column-level policy, and the corresponding policy takes effect when the column is accessed.
DBA_POLICIES	Displays the access control policies for all tables or views in the current tenant. When applying access control to a table, you can create multiple policies for that table.
DBA_POLICY_CONTEXTS	Displays the context information of all views within the current tenant. When accessing a view, the corresponding policy group is applied based on the value of the context.
DBA_POLICY_GROUPS	Displays the policy group information for all views within the current tenant. Combined with policy contexts, this enables different policies to take effect for different users.
DBA_SEC_RELEVANT_COLS	Displays information about all columns associated with policies in the tables or views of the current tenant. A column is associated with a column-level policy, and the corresponding policy takes effect when the column is accessed.

View name	Feature description
DBA_OB_BACKUP_JOBS	Displays the backup job tasks of the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup job tasks for the current tenant.
DBA_OB_BACKUP_TASKS	Displays the tenant's own task-level backup tasks.
DBA_OB_BACKUP_TASK_HISTORY	Displays the historical records of the tenant's own task-level backup tasks.
DBA_OB_BACKUP_SET_FILES	Displays the file status of the backup set.
DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
DBA_OB_ARCHIVE_DEST	Displays the archive path configuration.
DBA_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore operations under a tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information of backup destinations used for backup and restore operations under a tenant.
DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant.
DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the historical information about backup cleanup tasks executed under a tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information of completed backup_set and backup_piece cleanup tasks for a 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 pieces in a backup set.
DBA_OB_BACKUP_PARAMETER	Displays backup parameters.
DBA_OB_RECOVER_TABLE_JOBS	Displays information related to table-level restore tasks.
DBA_OB_IMPORT_TABLE_JOBS	Displays information related to the import task.
DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of a table-level restore task.
DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the result of the import task.
DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the historical records of cross-tenant import tasks at the table level.

View name	Feature description
ALL_ALL_TABLES	Displays the object tables and relational tables that users can access.
ALL_COL_COMMENTS	Displays all column comments for the views and tables that the user has access to.
ALL_TABLES	Displays all tables that the user has access to.
ALL_TAB_COLS	Displays all columns of tables, views, and clusters that the current user has access to.
ALL_TAB_COLUMNS	Displays all columns of tables, views, and clusters that the current user has access to.
ALL_TAB_COMMENTS	Displays the comments on tables and views that the current user has access to.
DBA_COL_COMMENTS	Displays all column comments for all views and tables in the database.
DBA_TAB_COMMENTS	Displays the comments for all tables and views in the database.
USER_COL_COMMENTS	Displays all column comments for the views and tables 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 association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed.
DBA_TABLES	Displays all tables in the database.
DBA_ALL_TABLES	Displays object tables and relational tables in the database. Its fields are the same as those of ALL_ALL_TABLES.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Displays all columns in all tables, views, and clusters in the database.
DBA_TAB_COLUMNS	Displays all columns in all tables, views, and clusters in the database.
USER_ALL_TABLES	Displays the object tables and relational tables that the current user can access. Except for the OWNER column, its fields are the same as those in the ALL_ALL_TABLES view.
USER_TABLES	Displays all tables owned by the current user.
USER_TABLESPACES	Displays the tablespaces that the current user can access. Its columns are the same as those in the`DBA_TABLESPACES`The columns in the middle are the same, and the following columns are removed:`PLUGGED_IN`field.
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 the views accessible to the current user.
DBA_VIEWS	Displays all views in the database. Its columns are as follows:`ALL_VIEWS`The columns in them are the same.
USER_VIEWS	Displays the views owned by the current user.
DICTIONARY	Displays the descriptions of data dictionary tables and views.
DICT	Displays the descriptions of data dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including: system tables, user tables, index tables, etc.
DBA_OB_SPATIAL_COLUMNS	Displays the database name, table name, type, and SRS information corresponding to the spatial index column.
DBA_OB_TABLE_SPACE_USAGE	Displays the size of all user tables under the current tenant (based on the leader replica in a multi-replica environment).

View name	Feature description
DBA_OB_CCL_RULES	Records all current rate-limiting rules for a user tenant.

View name	Feature description
ALL_ERRORS	Displays errors of the current stored object that the user can access.
DBA_ERRORS	Displays errors of the current stored objects in the database.
USER_ERRORS	Displays errors of the currently accessible stored objects.
DBA_SEGMENTS	Displays the storage information allocated to all segments in the database.
USER_SEGMENTS	Displays the storage information allocated for segments owned by objects under the current user.
DBA_OB_SOURCE	This API is used to display the source code information of all storage objects under the current tenant.
USER_OB_SOURCE	Displays the source code information of the storage objects owned by the current user.
ALL_OB_SOURCE	Displays the source code information of the storage object that the current user has access to.

View name	Feature description
ALL_TRIGGERS	Displays the triggers and their descriptions on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view describes all triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.
ALL_TRIGGER_ORDERING	Displays a sorted list of all triggers accessible to the current user.
DBA_TRIGGER_ORDERING	Displays the sorted list of all triggers under the current tenant.
USER_TRIGGER_ORDERING	Displays the trigger sorting of the current user.

View name	Feature description
ALL_OBJECTS	Displays all database objects that the user has access to.
DBA_OBJECTS	Displays all database objects in the database.
USER_OBJECTS	Displays all database objects owned by the user.
ALL_DEPENDENCIES	Displays the dependencies between all objects in the database.
DBA_DEPENDENCIES	Displays all dependencies between objects in the database.
USER_DEPENDENCIES	Displays the dependencies between objects in the current user's schema.

View name	Feature description
ALL_METHOD_PARAMS	Displays the method parameters for the object types that the user can access.
ALL_TYPE_METHODS	A method that displays the types of objects the user can access.
DBA_METHOD_PARAMS	Displays the method parameters of the object type in the database.
DBA_TYPE_METHODS	Displays the methods of an object type in a database.
USER_TYPE_METHODS	The method for displaying the types of objects a user can access, which is consistent with ALL_TYPE_METHODS in terms of field information, except that it does not contain the OWNER field.

View name	Feature description
ALL_DB_LINKS	Displays all DBLINKs accessible to the current user.
DBA_DB_LINKS	Displays all created DBLINKs under the current tenant.
USER_DB_LINKS	Displays the DBLINK created by the current user.

View name	Feature description
DBA_OB_SERVICES	Displays all tenants under this tenant.`SERVICE_NAME`For more information.

View name	Feature description
DBA_OB_AUX_STATISTICS	Displays auxiliary statistics for each tenant.

View name	Feature description
DBA_OB_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights set under the current user tenant.
DBA_OB_TRANSFER_PARTITION_TASKS	Displays the current partition transfer tasks being processed under this tenant.
DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of transfer partition tasks executed for this tenant.
DBA_OB_BALANCE_JOBS	Displays the current load balancing job being executed by a tenant. Each tenant can only run one load balancing job at a time. Each load balancing job generates multiple load balancing tasks to perform specific load balancing operations.
DBA_OB_BALANCE_JOB_HISTORY	Displays the history of all load balancing operations performed under a tenant.
DBA_OB_BALANCE_TASKS	Displays the current load balancing tasks being executed for the tenant. A tenant may have multiple load balancing tasks running concurrently, and these tasks all belong to the same load balancing job.
DBA_OB_BALANCE_TASK_HISTORY	Displays the history of all load balancing tasks executed under a tenant.
DBA_OB_TRANSFER_TASKS	Displays the current transfer tasks being executed under this tenant.
DBA_OB_TRANSFER_TASK_HISTORY	Displays the history of all transfer tasks executed under this tenant.

View name	Feature description
DBA_OB_CS_REPLICA_STATS	Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node of the tenant.
DBA_OB_LS_LOCATIONS	Displays the replica distribution information of log streams (LS) for the current tenant.
DBA_OB_TABLET_REPLICAS	This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:`<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	Displays a list of all tablets in the current tenant and the log stream information to which each tablet belongs.
DBA_OB_LS	Displays the status and recovery progress of the log stream.
DBA_OB_LOG_RESTORE_SOURCE	Displays the log restore source for this tenant.
DBA_OB_LS_HISTORY	Displays the log streams that have existed in this tenant's history.
DBA_OB_LS_LOG_ARCHIVE_PROGRESS	Displays the log stream archiving progress for the current tenant.
DBA_OB_TENANT_FLASHBACK_LOG_SCN	Displays information about each log compaction in the current tenant.

View name	Feature description
ALL_PART_KEY_COLUMNS	Displays the columns that make up the partitioning key in all accessible partition objects.
ALL_PART_TABLES	Displays the partition information of partitioned tables that the current user can access.
ALL_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	Displays the columns contained in the subpartitioning key for all partition objects accessible to the user.
ALL_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics for all partitioned tables.
ALL_TAB_SUBPARTITIONS	Display`DBMS_STATS`The package generates partition-level partition information, partition storage parameters, and partition statistics for partitions accessible to the current user.
DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information of the current tenant.
DBA_PART_INDEXES	Displays the partition information for all partitioned indexes.
DBA_PART_KEY_COLUMNS	Displays the columns contained in the partitioning key for all partition objects in the database.
DBA_PART_TABLES	Displays the partition information of partitioned tables that the current user can access.
DBA_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	Displays the columns contained in the subpartitioning key for all partition objects in the database.
DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to.
DBA_TAB_SUBPARTITIONS	It displays the subpartition name, the name of the table and its partition, its storage attributes, and`DBMS_STATS`The package generates statistics.
USER_PART_KEY_COLUMNS	Displays the columns contained in the partitioning key for all partition objects owned by the current user.
USER_PART_TABLES	Displays the partition information of the current user's partitioned table.
USER_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	Displays the columns contained in the subpartitioning key for all partition objects owned by the current user.
USER_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition to which it belongs, and storage attributes of each subpartition of the current user.
USER_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of the current user.
DBA_OB_TABLEGROUPS	Displays the meta information of a table group, mainly its partition information.
DBA_OB_TABLEGROUP_PARTITIONS	Displays the partition information of a table group.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartition information of a table group with partitions.

View name	Feature description
DBA_RECYCLEBIN	Displays information about all recycle bins in the database.
USER_RECYCLEBIN	Displays information about the recycle bin owned by the current user. Its columns are the same as those in the`DBA_RECYCLEBIN`The columns in the middle are the same, and the following columns are removed:`OWNER`Field.

View name	Feature description
ALL_ARGUMENTS	Displays the parameters of functions and procedures that the current user can access.
ALL_PROCEDURES	Displays all functions and procedures that the current user can access, along with their related attributes.
ALL_SOURCE	Displays the text source of the storage object that the current user can access.
DBA_ARGUMENTS	Displays the parameters of functions and procedures available in the database. Its columns are as follows:`ALL_ARGUMENTS`The columns in them are the same.
DBA_PROCEDURES	Displays all functions and procedures available in the database, along with their related attributes. Its columns are as follows:`ALL_PROCEDURES`The columns in them are the same.
DBA_SOURCE	Displays the text source of all stored objects in the database. Its columns are as follows:`ALL_SOURCE`The columns in them are the same.
USER_ARGUMENTS	Displays the parameters of the functions and procedures owned by the current user. Its columns correspond to`ALL_ARGUMENTS`The columns in the middle are the same, and the following columns are removed:`OWNER`field.
USER_PROCEDURES	Displays all functions and procedures owned by the current user, along with their associated attributes. The columns are as follows:`ALL_PROCEDURES`The columns in the middle are the same, and the following columns are removed:`OWNER`field.
USER_SOURCE	Displays the text source of the storage object owned by the current user. Its columns are the same as those in the`ALL_SOURCE`The columns in the middle are the same, and the following columns have been removed:`OWNER`field.
DBA_OB_PL_OBJ_CACHE_STATUS	Displays the status information of PL cache objects.
DBA_JOBS	Displays an overview of the currently submitted tasks.
USER_JOBS	Displays an overview of the currently submitted tasks.
DBA_JOBS_RUNNING	Displays the running tasks.

View name	Feature description
DBA_OB_STORAGE_IO_USAGE	Displays the I/O operation statistics of the current tenant's object storage and cloud disk.

View name	Feature description
DBA_OB_TEMP_FILES	view`DBA_OB_TEMP_FILES`Displays information about temporary files.

View name	Feature description
NLS_DATABASE_PARAMETERS	Displays the NLS parameters at the database level (OceanBase Database tenant level).
NLS_INSTANCE_PARAMETERS	Displays NLS parameters at the instance level (tenant level).
NLS_SESSION_PARAMETERS	Displays NLS parameters at the session level.

View name	Feature description
DBA_OB_OUTLINES	Displays the execution plan outline information for the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the throttling rule outline information for the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan and throttling rule outline historical information for this tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

View name	Feature description
ALL_PLSQL_COLL_TYPES	`ALL_PLSQL_COLL_TYPES`The view is used to display the overall information about the collection types defined in the package.
ALL_PLSQL_TYPES	`ALL_PLSQL_TYPES`The view is used to display the overall information of package types.
ALL_PLSQL_TYPE_ATTRS	`ALL_PLSQL_TYPE_ATTRS`Displays the overall information about the record types defined in the package.
USER_PLSQL_COLL_TYPES	`USER_PLSQL_COLL_TYPES`The view displays the overall information about the collection types defined in the current user's package. Types in a package are displayed in this view only if the package has been successfully compiled.
USER_PLSQL_TYPES	`USER_PLSQL_TYPES`The view displays the overall information about package types under the current user. Types in a package are displayed in this view only if the package has been successfully compiled.
USER_PLSQL_TYPE_ATTRS	`USER_PLSQL_TYPE_ATTRS`This view displays the overall information about the record types defined in the current user's package. Types in a package are displayed in this view only if the package has been successfully compiled.
DBA_PLSQL_COLL_TYPES	`DBA_PLSQL_COLL_TYPES`The view displays the overall information about the collection types defined in the current tenant's package. Types in a package are displayed in this view only if the package has been successfully compiled.
DBA_PLSQL_TYPES	`DBA_PLSQL_TYPES`This view displays the overall information about package types in the current tenant. Types within a package are displayed only if the package has been successfully compiled.
DBA_PLSQL_TYPE_ATTRS	`DBA_PLSQL_TYPE_ATTRS`This view displays the overall information about the record types defined in a package. Types in a package are displayed only if the package has been successfully compiled.

View name	Feature description
ALL_PROFILES	Displays all the profiles and their limitations.
DBA_PROFILES	Displays all the profiles and their limitations.
USER_PROFILES	Displays all the profiles and their limitations.

View name	Feature description
DBA_OB_SYNC_STANDBY_DEST	Displays the strong sync downstream information of the current tenant.
DBA_OB_ACCESS_POINT	Displays the list of servers at the tenant entry for this tenant. In a network-based physical standby database scenario, it is primarily used to obtain the IP address and SQL port number of the OBServer node where the primary tenant's replica resides.
DBA_OB_LS_REPLICA_TASKS	Displays the disaster recovery tasks at the replica level currently running for the current tenant.
DBA_OB_LS_REPLICA_TASK_HISTORY	Displays the execution history of all tenant disaster recovery tasks.

View name	Feature description
DBA_SCHEDULER_JOBS	Displays the scheduler job information that the current user can access.
DBA_SCHEDULER_PROGRAM	Displays information about all schedulers in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	Displays information about all scheduler jobs under a tenant.
ALL_SCHEDULER_JOB_ARGS	Displays the parameters of the scheduled job that users can view.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the scheduler parameters available for user query.
DBA_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs in the database.
USER_SCHEDULER_JOB_ARGS	Displays the parameters of the scheduled job owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the scheduler parameters in the database.
USER_SCHEDULER_PROGRAM_ARGS	Displays the scheduler parameters of the current user.
USER_SCHEDULER_JOBS	Displays the scheduler job information that the current user can access.
ALL_SCHEDULER_WINDOWS	Displays information about all scheduler windows that the current user has access to.
DBA_SCHEDULER_WINDOWS	Displays information for all scheduler windows under the current tenant.
DBA_SCHEDULER_RUNNING_JOBS	Displays all jobs running under the tenant.

View name	Feature description
ALL_DEF_AUDIT_OPTS	Displays the audit conditions that are applied by default to any object.
AUDIT_ACTIONS	Displays the action ID and its corresponding name in the audit record.
DBA_AUDIT_EXISTS	Display`AUDIT EXISTS`and`AUDIT NOT EXISTS`The generated audit trail entries.
DBA_AUDIT_OBJECT	Displays the audit trail records for all objects in the database.
DBA_AUDIT_SESSION	Display all information about`CONNECT`and`DISCONNECT`audit tracking records.
DBA_AUDIT_STATEMENT	Display information about the database.`GRANT`、`REVOKE`、`AUDIT`、`NOAUDIT`and`ALTER SYSTEM`The audit tracking record of the statement.
DBA_AUDIT_TRAIL	Displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	Displays the detailed configuration of object-level auditing.
DBA_STMT_AUDIT_OPTS	Displays the detailed configuration of statement-level auditing.
STMT_AUDIT_OPTION_MAP	Displays the type, name, and priority of statement-level audit.
USER_AUDIT_OBJECT	Displays the audit trail records of objects that the current user can access.
USER_AUDIT_SESSION	Displays the audit trail records of the current user's connections and disconnections.
USER_AUDIT_STATEMENT	Displays the queries issued by the current user.`GRANT`、`REVOKE`、`AUDIT`、`NOAUDIT`and`ALTER SYSTEM`The audit tracking entry for the statement.
USER_AUDIT_TRAIL	Displays standard audit trail entries related to the current user.

View name	Feature description
DBA_SQL_PLAN_BASELINES	Displays the plan baseline of the SQL statement in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.
DBA_OB_SPM_EVO_RESULT	Displays the SPM plan evolution information for the current tenant.

View name	Feature description
ALL_INDEXES	Displays the index column information for all indexes of tables that the user has access to.
ALL_IND_COLUMNS	Displays the index column information for all indexes of tables that the user has access to.
ALL_IND_EXPRESSIONS	Displays information about the function-based indexes that users have access to in the database.
ALL_IND_PARTITIONS	Displays information about index partitions in the accessible databases.
ALL_IND_SUBPARTITIONS	Displays information about all index subpartitions that users can access in the database.
ALL_PART_INDEXES	Displays the partition information of partitioned indexes that the current user has access to.
DBA_INDEXES	Displays the index information for all tables in the database.
DBA_IND_COLUMNS	Displays the index column information for all tables in the database.
DBA_IND_EXPRESSIONS	Displays information about all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays information about all index partitions in the database.
DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
USER_INDEXES	Displays the index information for all tables owned by the user.
USER_IND_COLUMNS	Displays the index column information for all indexes of a user's tables.
USER_IND_EXPRESSIONS	Displays information about the function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	Displays information about index partitions in the database that the current user owns.`ALL_IND_PARTITIONS`、`DBA_IND_PARTITIONS`Compared with None`INDEX_OWNER`field.
USER_IND_SUBPARTITIONS	Display information about all index subpartitions owned by the user in the database.`DBA_IND_SUBPARTITIONS`、`ALL_IND_SUBPARTITIONS`Compared with None`INDEX_OWNER`field.
USER_PART_INDEXES	Displays the partition information of the current user's partitioned index.
DBA_INDEX_USAGE	Displays the data usage of indexes.

View name	Feature description
DBA_OB_DATA_DICTIONARY_IN_LOG	Records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary.

View name	Feature description
DBA_CONTEXT	Displays all context namespace information in the database.
DBA_OB_SYS_VARIABLES	Displays the configurations of system variables for the current tenant, including hidden variables that start with an underscore (_).

View name	Feature description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants.

View name	Feature description
ALL_PART_COL_STATISTICS	Displays the column statistics and histograms of partitions in the partitioned tables that the current user has access to.
ALL_PART_HISTOGRAMS	Displays the histogram information for all partitions.
ALL_SUBPART_COL_STATISTICS	Displays the column statistics and histograms of the subpartitions in the partitioned tables that the current user has access to.
ALL_SUBPART_HISTOGRAMS	Displays the histogram information for all subpartitions.
ALL_TAB_COL_STATISTICS	Displays the column statistics and histograms for tables accessible to the current user.
ALL_TAB_HISTOGRAMS	Displays all table-level histogram information.
ALL_TAB_STATISTICS	Displays the optimizer statistics for tables accessible to the current user.
DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information for partitions in a partitioned table.
DBA_PART_HISTOGRAMS	Displays the histogram information of the partitions in the current database.
DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histograms of subpartitions in a partitioned table.
DBA_SUBPART_HISTOGRAMS	Displays the histogram information of the current database's subpartition.
DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
DBA_TAB_HISTOGRAMS	Displays the histogram information at the table level for the current database.
DBA_TAB_STATISTICS	Displays the optimizer statistics for all tables in the database.
USER_PART_COL_STATISTICS	Displays the column statistics and histograms of partitions in the current user's partitioned table.
USER_PART_HISTOGRAMS	Displays the histogram information of the current user's partitions.
USER_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of subpartitions in the current user's partitioned table.
USER_SUBPART_HISTOGRAMS	Displays the histogram information of the current user's subpartition.
USER_TAB_COL_STATISTICS	Displays the column statistics and histogram information for the current user's tables.
USER_TAB_HISTOGRAMS	Displays the histogram information at the table level for the current user.
USER_TAB_STATISTICS	Displays the optimizer statistics for all tables of the current user.
ALL_TAB_STATS_HISTORY	Displays the history of table statistics modifications for all tables accessible to the current user.
DBA_TAB_STATS_HISTORY	Displays the history of table statistics modifications for all tables in the database.
USER_TAB_STATS_HISTORY	Displays the history of table statistics modifications for all tables owned by the current user.
ALL_IND_STATISTICS	Displays the optimizer statistics for indexes on tables that the current user has access to.
DBA_IND_STATISTICS	Displays the optimizer statistics for all indexes in the database.
USER_IND_STATISTICS	Displays the optimizer statistics for indexes of tables owned by the current user.
ALL_TAB_MODIFICATIONS	Displays the cumulative modification information of tables accessible to the current user.
DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of tables in the database.
USER_TAB_MODIFICATIONS	Displays the cumulative modification information of tables owned by the current user.
DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	Query the historical collection execution of a table.
DBA_OB_TABLE_STAT_STALE_INFO	Displays the number of DML operations performed on each table under the current tenant since the last statistics collection, and indicates whether the current statistics have expired.
DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	Displays the execution status of historical collection tasks for the current tenant.

View name	Feature description
ALL_SYNONYMS	Displays all synonyms accessible to the user.
DBA_SYNONYMS	Displays all synonyms in the database.
USER_SYNONYMS	Displays the synonyms owned by the current user.

View name	Feature description
ALL_OB_EXTERNAL_TABLE_FILES	Displays the list of files for external tables to which the current user has access.
DBA_OB_EXTERNAL_TABLE_FILES	Displays the file list corresponding to all external tables created under the current tenant.

View name	Feature description
DBA_WR_SNAPSHOT	Displays the of the current tenant.`SNAPSHOT`Information.
DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persistent ASH data for this tenant.
DBA_WR_STATNAME	Displays the name of the system statistic item for the current tenant.
DBA_WR_SYSSTAT	Displays detailed system statistics for the current tenant.
DBA_WR_CONTROL	Displays the configuration information related to write requests.
DBA_WR_SYSTEM_EVENT	This API is used to display the persistent tenant-level wait event information for the current tenant.
DBA_WR_EVENT_NAME	Displays the names of persistent tenant-level wait events for the current tenant.
DBA_WR_SQLTEXT	Displays the SQL text collected for write operations of the current tenant.
DBA_WR_SQLSTAT	This view displays basic performance statistics for SQL statements executed by the current tenant.
DBA_WR_SYS_TIME_MODEL	This table displays the write data of time model statistics for the current tenant.
DBA_WR_SQL_PLAN	This view displays the GV$OB_SQL_PLAN data collected by WR.

View name	Feature description
DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
DBA_MVIEW_LOGS	Displays materialized view log information.
DBA_MVIEW_RUNNING_JOBS	Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks.
USER_MVIEWS	Displays materialized view information.
DBA_MVIEWS	Displays information about all materialized views.
DBA_MVREF_CHANGE_STATS	This view displays statistics related to materialized view refreshes.
DBA_MVREF_RUN_STATS	It displays information about each refresh operation of a materialized view, with each operation identified by a REFRESH_ID.
DBA_MVREF_STATS	This view displays basic timing statistics for materialized view refreshes.
DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
DBA_MVREF_STATS_SYS_DEFAULTS	The system-wide default value for the historical statistics refresh attribute of materialized views.
DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.
ALL_MVIEWS	Displays the materialized view information.
ALL_MVIEW_LOGS	Displays information about all materialized view logs.
USER_MVIEW_LOGS	Displays materialized view log information.
USER_MVREF_CHANGE_STATS	This view displays statistics related to all materialized view refreshes. These statistics show how much data changes occur on the base tables associated with each materialized view refresh, and the amount of information required to load these changed data.
USER_MVREF_RUN_STATS	Information about each refresh of a materialized view is displayed, with each refresh identified by a REFRESH_ID. This information includes timing statistics related to the refresh and the parameters specified in that refresh.
USER_MVREF_STATS	Displays basic timing statistics for materialized view refreshes.
USER_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
USER_MVREF_STATS_SYS_DEFAULTS	The system-wide default value for the materialized view refresh history statistics attribute.
USER_MVREF_STMT_STATS	Describes the information associated with the refresh statement.

View name	Feature description
ALL_SEQUENCES	Displays all sequences that the user has access to.
DBA_SEQUENCES	Displays all sequences in the database.
USER_SEQUENCES	Displays all sequences owned by the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays global variable information.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays the variable information of the session.

View name	Feature description
ALL_COLL_TYPES	Displays the user-defined collection types available in the database. Its columns are as follows:`DBA_COLL_TYPES`The columns in them are the same.
ALL_TYPES	Displays the user-defined types available in the database.
ALL_TYPE_ATTRS	Displays the attribute information of user-defined types available in the database.
DBA_COLL_TYPES	Displays the user-defined collection types available in the database. Its columns are as follows:`ALL_COLL_TYPES`The columns in them are the same.
DBA_TYPES	Displays the user-defined types available in the database.
DBA_TYPE_ATTRS	Displays the attribute information of user-defined types available in the database.
USER_COLL_TYPES	Displays the custom collection types available to the current user.
USER_TYPES	Displays the user-defined type of the current user.
USER_TYPE_ATTRS	Displays the attribute information of user-defined types available to the current user.

View name	Feature description
ALL_CONSTRAINTS	Displays the constraint information for all tables accessible to the user.
ALL_CONS_COLUMNS	Displays the column information in the constraints of all tables accessible to the user.
DBA_CONSTRAINTS	Displays the constraint information for all tables in the database.
DBA_CONS_COLUMNS	Displays the column information in all table constraints of the database.
USER_CONSTRAINTS	Displays the constraint information for all tables owned by the user.
USER_CONS_COLUMNS	Displays the column information in all table constraints owned by the user.

View name	Feature description
DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information for this tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the tenant.
DBA_OB_FREEZE_INFO	Displays the version information generated during a major freeze.

View name	Feature description
DBA_OB_RSRC_DIRECTIVES	Displays the resource configuration parameters of the current tenant in the Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	Displays the I/O resource configuration of the current tenant in the Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationship between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all system-defined resource management plans.
DBA_RSRC_PLAN_DIRECTIVES	Displays the details of each set of resource plan directives in the database.

View name	Feature description
DBA_OB_LS_ARB_REPLICA_TASKS	Displays the arbitration service tasks currently running for the current tenant.
DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	Displays the history of arbitration service tasks executed by the current tenant.

View name	Feature description
DBA_OB_TENANTS	Displays the basic information of a tenant.
DBA_OB_TENANT_EVENT_HISTORY	Displays the historical operation records of the current tenant.
DBA_OB_DATABASES	Displays the database metadata of a tenant.

View name	Feature description
GV$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	Displays the history of active sessions.
GV$OB_ACTIVE_SESSION_HISTORY	This API is used to query the active session history of all OBServer nodes in the current tenant.
V$OB_ACTIVE_SESSION_HISTORY	This API is used to display the active session history on the current OBServer node for the current tenant.

View name	Feature description
GV$OB_SQL_CCL_STATUS	Records the number of SQL statements that hit each throttling rule for all nodes in the current tenant at the current moment, used to observe the impact of the throttling rules currently set in the system.
V$OB_SQL_CCL_STATUS	Records the number of SQL statements that hit the corresponding throttling rule for the current node of the tenant at the current moment, used to observe the impact of the throttling rules set in the system.

View name	Feature description
GV$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client by the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of the HMS Catalog client by the current tenant.

View name	Feature description
GV$DML_STATS	Displays DML information in the current user's tables.
V$DML_STATS	Displays DML information in the current user's tables.

View name	Feature 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 name	Feature description
GV$DBLINK	This view displays all database links opened after the query session initiated on this view.`IN_TRANSACTION=YES`). These database connections must be committed or rolled back before being closed.
V$DBLINK	This view displays all database links opened after the query session initiated on this view.`IN_TRANSACTION=YES`). These database connections must be committed or rolled back before being closed.

View name	Feature description
oceanbase.DBA_OB_SERVER_JOBS	Displays tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays information about all OBServer nodes.
oceanbase.CDB_OB_SERVICES	Display all tenants'`SERVICE_NAME`For more information.
oceanbase.DBA_OB_SERVICES	Display all tenants under this tenant.`SERVICE_NAME`information.

View name	Feature description
GV$OB_LOG_STAT	Displays the status of Palf.
V$OB_LOG_STAT	Displays the status of Palf.
GV$OB_LOG_TRANSPORT_DEST_STAT	view`GV$OB_LOG_TRANSPORT_DEST_STAT`Displays information about all OBServer downstream log synchronization links (OBCDC/network standby databases) under this tenant.
V$OB_ARCHIVE_DEST_STATUS	Displays the status of each log archive destination at the tenant level.
V$OB_LOG_TRANSPORT_DEST_STAT	view`V$OB_LOG_TRANSPORT_DEST_STAT`Displays information about the downstream log synchronization links (OBCDC/network standby database) under this OBServer in this tenant.
V$OB_LS_LOG_RESTORE_STATUS	Displays the log restore status at the stream level for logs of the current tenant.
V$OB_LS_REPLICA_TASK_PLAN	Displays all tasks that should be generated currently (including those already generated and those not yet generated).
V$OB_LS_SNAPSHOTS	Displays the information about the log stream snapshots persisted in all units of the current OBServer.

View name	Feature description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partitioned table information of the current tenant.

View name	Feature description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached on the current server.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache for the current tenant on the current server.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PL_CACHE_OBJECT	View`GV$OB_PL_CACHE_OBJECT`Displays the basic information of PL-related cache objects on all servers in the current tenant.
GV$OB_RESULT_CACHE_OBJECTS	This view displays the tags on all OBServer nodes.`result_cache`of`udf`Created during execution`result cache`Information about cached objects.
V$OB_PL_CACHE_OBJECT	view`V$OB_PL_CACHE_OBJECT`Displays the basic information about PL-related cache objects on the current server under the current tenant.
V$OB_RESULT_CACHE_OBJECTS	This view is used to display the markers under the current OBServer.`result_cache`of the`udf`Created during execution`result cache`Information about cached objects.

View name	Feature description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on the current OBServer node.

View name	Feature 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 name	Feature description
GV$OB_MEMORY	Displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	Displays the memory usage of the MemTable for all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	It indicates some overall information about the SQL Workarea, including the maximum available memory, current memory usage, and current held memory.
GV$OB_SSTABLES	Displays the SSTable information of a tenant.
GV$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays detailed information about the MemTables of all partitions for all tenants on all servers.
V$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMSTORE	Displays the memory usage of the MemTable for all tenants on the current server.
V$OB_SSTABLES	Displays the SSTable information of a 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 name	Feature description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.

View name	Feature description
GV$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_ITEM_INFO	Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_SESSION_PS_INFO	Displays the PS information opened by all sessions of the current tenant.
V$OB_SESSION_PS_INFO	This API is used to display the PS information opened by all sessions of the current OBServer tenant.

View name	Feature description
GV$OB_PX_TARGET_MONITOR	Displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the PX thread usage on the OBServer node.
V$OB_PX_P2P_DATAHUB	Displays information related to data transfer operations during parallel execution.

View name	Feature description
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.

View name	Feature description
GV$OB_LOCKS	Displays the lock holding or lock requesting status of each table for the current user.
V$OB_LOCKS	Displays the lock holding or lock requesting status of each table for the current user.

View name	Feature description
V$TIMEZONE_NAMES	Displays the valid time zone names.
V$OB_TIMESTAMP_SERVICE	Displays the GTS/STS values of the tenant's GTS service.

View name	Feature description
GV$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays some system-level wait events of tenants on all servers, and counts the number of occurrences, total wait time, and timeout count for each type of wait event.
V$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	Displays some system-level wait events of tenants on the current server, and provides statistics such as the number of occurrences, total wait time, and timeout count for each type of wait event.
V$GLOBAL_TRANSACTION	Displays information about currently active global transactions.
GV$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions that have the current node as the original scheduler.
GV$OB_TRANSACTION_SCHEDULERS	`GV$OB_TRANSACTION_SCHEDULERS`This API is used to query the transaction scheduler information of all servers.
V$OB_TRANSACTION_SCHEDULERS	`V$OB_TRANSACTION_SCHEDULERS`This API is used to query the transaction scheduler information of all servers.

View name	Feature description
GV$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View name	Feature description
GV$OB_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$SESSION_WAIT	Displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait duration.
GV$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events for all sessions on all servers.
GV$SESSTAT	Displays some session-level statistics across all servers.
V$NLS_PARAMETERS	View NLS parameters at the session level.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$SESSION_WAIT	Displays information about the current or last wait event for all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events for all sessions on the current server.
V$SESSTAT	Displays some statistics at the session level.
V$EVENT_NAME	Displays the definitions of various events under a tenant.
GV$OPEN_CURSOR	Displays information about session cursors in the open state on all nodes.
V$OB_SESSION	Records the session information created on the current server.
V$OPEN_CURSOR	Displays information about the currently open session cursor.

View name	Feature description
GV$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request across all servers.
V$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on the current server.

View name	Feature description
GV$OB_OPT_STAT_GATHER_MONITOR	Displays the real-time status of the statistics collection task for the current tenant across all OBServer nodes.
V$OB_OPT_STAT_GATHER_MONITOR	Displays the real-time status of the statistical information collection task for the current tenant on the current OBServer node.

View name	Feature description
GV$OB_NIC_INFO	Displays the NIC information of all OBServer nodes where the tenant resides, primarily showing the NIC speed.
V$OB_NIC_INFO	Displays the NIC information of the current OBServer node, primarily showing the NIC speed.

View name	Feature description
GV$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory management.
GV$SQL_WORKAREA_ACTIVE	The workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays the statistics of all workareas executed before the current one.
V$OB_SQL_WORKAREA_MEMORY_INFO	Query the overall information of SQL Workarea, including the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA	Statistics on the workarea of all operators that have been executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	The workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays the statistics of all workareas executed before the current one.

View name	Feature description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	A histogram that shows the query execution time of all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistical information of resource groups on all OBServer nodes in the current tenant.
V$OB_RES_MGR_SYSSTAT	This API is used to display the statistics of resource groups in the current OBServer node under the current tenant.
GV$OB_SQLSTAT	This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented as a row (that is, each`SQL_ID` + `Plan_Hash`(The unique value of is one row.)
V$OB_SQLSTAT	It displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (that is, each`SQL_ID` + `Plan_Hash`The unique value of is one row).
GV$OB_SESS_TIME_MODEL	Displays time model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This API is used to display time model statistics at the tenant level in a cluster.
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	A histogram that shows the query execution time of the current node for the current tenant.

View name	Feature description
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
GV$SYSSTAT	Displays system-level statistical event information on all servers.
V$GLOBALCONTEXT	Displays the global context attributes accessible to the current session.`CLIENT_IDENTIFIER`Value.
V$OB_PARAMETERS	Displays the parameter information on this OBServer node.
V$SYSSTAT	Displays system-level statistical event information on the current server.
V$OB_UNITS	Displays the unit information of the current OBServer node.
V$VERSION	View the names and version information of all components in the database product.
V$STATNAME	Displays the name of the statistical item.

View name	Feature description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
GV$OB_THREAD	Displays the status information of all threads in the observer process on each OBServer node. For user tenants, it displays the relevant threads of the current tenant.
V$OB_THREAD	Displays the status information of all threads in the observer process on the current OBServer node. For user tenants, it displays the relevant threads of the current tenant.

View name	Feature description
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress information of a tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.
GV$GLOBAL_TRANSACTION	Displays information about currently active global transactions.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress information of a tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the recommended information for COMPACT.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACT.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level compaction.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level compaction.

View name	Feature description
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of the`OTHERSTAT_X_ID`The meaning of the numbers in the fields.
GV$SQL_PLAN_MONITOR	This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan.
V$SQL_PLAN_MONITOR	This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan.
GV$OB_SQL_PLAN	Displays the plan information collected by executing EXPLAIN PLAN on all OBServer nodes for the current tenant.
GV$SQL_JOIN_FILTER	Dynamic display information related to Join Filter execution for this tenant across all OBServer nodes.
V$OB_SQL_PLAN	Displays the plan information collected by executing EXPLAIN PLAN for the current tenant on the current OBServer node.
V$SQL_JOIN_FILTER	Dynamically displays information related to Join Filter execution for the current tenant on the current OBServer node.

View name	Feature description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	Displays the I/O statistics at the function level for the current tenant across all OBServer nodes.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group for the current tenant on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the IO statistics at the function level for the current tenant on the current OBServer node.
GV$OB_CGROUP_CONFIG	Quickly query the cgroup configurations of all OBServer nodes.
V$OB_CGROUP_CONFIG	This API is used to quickly query the cgroup configuration of the current OBServer node.
V$RSRC_PLAN	Displays the resource management plan for the current active tenant.
GV$OB_TENANT_RESOURCE_LIMIT	Displays the logical resource usage, upper limit, effective constraints, and maximum usage after a crash restart for the current tenant across all OBServer nodes.
GV$OB_TENANT_RESOURCE_LIMIT_DETAIL	Displays the logical resource limits for the current tenant across all OBServer nodes, along with the upper limits for each constraint.
V$OB_TENANT_RESOURCE_LIMIT	Displays the logical resource usage, upper limit, effective constraints, and maximum usage after a crash restart for the current tenant on this OBServer.
V$OB_TENANT_RESOURCE_LIMIT_DETAIL	Displays the logical resource limitations of the current tenant on this OBServer node, along with the upper limits for each limitation.

View name	Feature description
GV$OB_ARBITRATION_MEMBER_INFO	Displays the arbitration member information of the current tenant.
GV$OB_ARBITRATION_SERVICE_STATUS	Displays the communication status between each node of the current tenant and the arbitration service.
V$OB_ARBITRATION_MEMBER_INFO	Displays the arbitration member information of the current tenant.
V$OB_ARBITRATION_SERVICE_STATUS	Displays the communication status between the current node of the tenant and the arbitration service.

OceanBase

Customer Stories

Documentation

Overview of system views

Overview of views in the sys tenant

Overview of dictionary views

Security permissions

AI models

Backup and recovery

Tables and columns

Note

CCL

Replica logs

Partitions

Load balancing

I/O performance

InnoDB storage engine

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Temporary files

OBKV

Outline related

Full-text indexes

Note

Note

Note

Note

Note

Other index-related

Task Scheduling

Disaster recovery

Root Service

SPM-related

SQL queries

Upgrade related

Event history monitoring

Basic database information

Data dictionary

Lock-related

Statistics and histograms

External resources

WR-related

Foreign key related

Note

Note

Materialized view related

Vector index related

Minor compaction and major compaction related

Tenant management

Resource management

Auto-increment columns

Arbitration service

Performance view overview

ASH-related

Catalog-related

DTL-related

Replica logs

Partitioning

I/O Performance Related

Scheduling cache related

Encryption tables