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

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 AI model endpoints of all tenants.
oceanbase.CDB_OB_AI_MODEL_PROFILES	Displays the AI model parameter configurations of all tenants.
oceanbase.CDB_OB_AI_MODEL_PROVIDERS	Displays the AI provider configurations of all tenants.
oceanbase.DBA_OB_AI_MODELS	Displays the AI model information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_ENDPOINTS	Displays the AI model endpoint information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_PROFILES	Displays the AI model parameter configurations of the current tenant.
oceanbase.DBA_OB_AI_MODEL_PROVIDERS	Displays the AI provider configuration of the current tenant.

View name	Feature description
oceanbase.CDB_OB_USERS	Display user information for all tenants.
oceanbase.CDB_OB_DATABASE_PRIVILEGE	Displays the database-level permission information for all tenants.
oceanbase.DBA_OB_AUTO_INCREMENT	Displays the auto-increment column information for the current tenant.
oceanbase.DBA_OB_USERS	Displays the user information of the current tenant.
oceanbase.DBA_OB_DATABASE_PRIVILEGE	Displays the database-level permission information for the current tenant.
oceanbase.DBA_OB_USER_DEFINED_RULES	Displays user-defined rule information.

View name	Feature description
oceanbase.DBA_POLICIES	Displays fine-grained access control policy information.
oceanbase.DBA_POLICY_CONTEXTS	Displays the policy context information.
oceanbase.DBA_POLICY_GROUPS	Displays the policy group information.
oceanbase.DBA_SEC_RELEVANT_COLS	Displays column information related to security policies.
oceanbase.ALL_POLICIES	Displays the fine-grained access control policy information accessible to the current user.
oceanbase.ALL_POLICY_CONTEXTS	Displays the policy context information accessible to the current user.
oceanbase.ALL_POLICY_GROUPS	Displays the information about the policy groups that the current user can access.
oceanbase.ALL_SEC_RELEVANT_COLS	Displays the column information related to security policies that the current user can access.

View name	Feature description
oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS	Displays information about all job-level backup verification tasks initiated by tenants.
oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY	Displays the execution history of job-level backup verification tasks initiated by all tenants.
oceanbase.CDB_OB_BACKUP_VALIDATE_TASKS	Displays information about all backup verification tasks initiated by tenants.
oceanbase.CDB_OB_BACKUP_VALIDATE_TASK_HISTORY	Displays the execution history of all backup verification task-level tasks initiated by tenants.
oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS	Displays information related to the job-level backup verification tasks initiated by this tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY	Displays the execution history of job-level backup verification tasks initiated by this tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS	Displays information about the backup verification task initiated by the current tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY	Displays the execution history of backup verification tasks initiated by this tenant.
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the current execution progress of a physical restore task.
oceanbase.CDB_OB_RESTORE_HISTORY	Indicates the status of a physical restore task when it 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 a 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 of backup cleanup tasks executed under a tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set or 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 policies set for expired cleanup and automatic cleanup under the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays information about the backup destinations used for backup and restore operations in 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 information about the backup destinations used for backup and restore operations in 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 policies set for expired 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 of backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set or 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 archivals.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information about 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 of 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.

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	The system tenant displays the TABLEGROUP and TABLE relationships of all tenants. TABLEs that are not part of a TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS	Displays the column information for tables and views in all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the column information for tables and views in 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
oceanbase.DBA_TABLES	This API is used to display information about all tables of the current tenant.
oceanbase.CDB_INDEX_USAGE	Displays the index usage statistics for all tenants.
oceanbase.DBA_INDEX_USAGE	Displays the index usage statistics of the current tenant.
oceanbase.DBA_TAB_COLS_V$	Displays the column information for table and view objects of the current tenant.
oceanbase.DBA_OB_TABLE_SPACE_USAGE	Displays the space usage of each table for the current tenant.

View name	Feature description
oceanbase.CDB_OB_CCL_RULES	Displays the concurrency control and throttling rules for all tenants.
oceanbase.DBA_OB_CCL_RULES	Displays the concurrency control and throttling rules for the current tenant.

View name	Feature description
oceanbase.CDB_OB_SPACE_USAGE	Displays the space usage of all tenants.
oceanbase.CDB_OB_SERVER_SPACE_USAGE	Displays the space usage of all OBServer nodes.
oceanbase.CDB_OB_TABLE_SPACE_USAGE	Displays the space usage of each table for all tenants.

View name	Feature description
oceanbase.CDB_OB_ACCESS_POINT	Displays the access endpoint information for all tenants.
oceanbase.DBA_OB_ACCESS_POINT	Displays the access endpoint information of 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 template partitioned tables for all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of all tenant partitioned tables.
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 partition information of a user table.
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 to which it belongs, its storage attributes, and`DBMS_STATS`The statistics generated by the package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the descriptions of all subpartition templates.

View name	Feature description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights set 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 the load balancing job tasks for all tenants.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY	Displays the historical records of load balancing job tasks for all tenants.
oceanbase.CDB_OB_BALANCE_TASKS	Displays the load balancing tasks for all tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY	Displays the task history of load balancing tasks for all tenants.
oceanbase.CDB_OB_TRANSFER_TASKS	Displays the transfer task information for all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY	Displays the transfer task history for all tenants.
oceanbase.DBA_OB_BALANCE_JOBS	Displays the load balancing job tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_JOB_HISTORY	Displays the historical records of load balancing job tasks for the current tenant.
oceanbase.DBA_OB_BALANCE_TASKS	Displays the load balancing tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY	Displays the CLB task history of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASKS	Displays the information about the current tenant's transfer tasks.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY	Displays the transfer task history of the current tenant.

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_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 along with the log stream information to which each tablet belongs.
oceanbase.CDB_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:`<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
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.
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 stream (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 a log stream.
oceanbase.DBA_OB_LS	Displays the status and recovery progress of a log stream.
oceanbase.CDB_OB_LS_HISTORY	Displays the log stream history information for all tenants.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS	Displays the log stream archiving progress for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASKS	Displays the log stream replication tasks for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY	Displays the task history of log stream replication for all tenants.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE	Displays the log restore source information for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS	Displays the arbitration replica tasks for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY	Displays the arbitration replica task history for all tenants.
oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN	Displays the flashback log SCN information for all tenants.
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG	Displays the data dictionary information in all tenant logs.
oceanbase.DBA_OB_LS_HISTORY	Displays the historical information of the current tenant's log streams.
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 log stream replication tasks for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY	Displays the historical task records of log stream replication for the current tenant.
oceanbase.DBA_OB_LOG_RESTORE_SOURCE	Displays the log restore source information for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS	Displays the arbitration replica tasks for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	Displays the arbitration replica task history of the current tenant.
oceanbase.DBA_OB_ARBITRATION_SERVICE	Displays information about the arbitration service.
oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN	Displays the flashback log SCN information for the current tenant.
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG	Displays the data dictionary information in the current tenant's logs.
oceanbase.ALL_LOCATIONS	Displays the location information of tables or partitions that the current user can access.

View name	Feature description
oceanbase.CDB_OB_SERVICES	Displays the service information for all tenants.
oceanbase.DBA_OB_SERVICES	Displays the service information of the current tenant.
oceanbase.DBA_OB_SERVER_JOBS	Displays tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays information for all OBServer nodes.

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 only for compatibility with MySQL 5.7. 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 (both waiting and holding locks). 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	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	This view displays the statistics of the InnoDB buffer pool. 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_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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX_RESET	This view 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; it can only be used to query the table structure.
information_schema.INNODB_CMP_RESET	Displays the status of operations related to compressing 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_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 only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.
information_schema.INNODB_SYS_TABLES	Displays metadata 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_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; it can only be used to 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 only for compatibility with MySQL 5.7. 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

View name	Feature description
oceanbase.CDB_OB_TEMP_FILES	Displays the temporary file information for all tenants.
oceanbase.DBA_OB_TEMP_FILES	Displays information about temporary files.

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
oceanbase.CDB_OB_KV_TTL_TASKS	This API is used to query all tenants for the number of active TTL tasks.
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 current tenant's running TTL tasks.
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 all OBKV tenant client connections on the current node.
GV$OB_KV_CLIENT_INFO	Displays the configuration parameter information for all client connections of the OBKV tenant.
oceanbase.CDB_OB_KV_REDIS_TABLE	Displays the OBKV Redis table information for all tenants.
oceanbase.DBA_OB_KV_REDIS_TABLE	Displays the OBKV Redis table information of the current tenant.

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 plans and throttling rule outlines of the current tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

View name	Feature description
oceanbase.DBA_PLSQL_COLL_TYPES	Displays information about PL/SQL collection types.
oceanbase.DBA_PLSQL_TYPES	Displays PL/SQL type information.
oceanbase.DBA_PLSQL_TYPE_ATTRS	Displays PL/SQL type attribute information.
oceanbase.ALL_PLSQL_COLL_TYPES	Displays the PL/SQL collection type information that the current user can access.
oceanbase.ALL_PLSQL_TYPES	Displays the PL/SQL type information accessible to the current user.
oceanbase.ALL_PLSQL_TYPE_ATTRS	Displays the PL/SQL type attribute information accessible to the current user.

View name	Feature description
information_schema.INNODB_FT_BEING_DELETED	Displays information about the full-text indexes being dropped. 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_FT_CONFIG	This view displays the configuration information of the InnoDB full-text search engine. 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_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 (fields) for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of 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_SCHEDULER_JOB_RUN_DETAILS	Displays the scheduling job runtime details for all tenants.
oceanbase.DBA_SCHEDULER_WINDOWS	Displays the scheduling window information.
oceanbase.DBA_SCHEDULER_JOB_CLASSES	Displays information about the scheduled job.
oceanbase.ALL_SCHEDULER_WINDOWS	Displays the scheduling window information accessible to the current user.

View name	Feature description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	This view displays the historical records of deadlock events. In the root tenant, it shows the historical records of all tenants.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history of an OBServer node.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the root service.

View name	Feature description
oceanbase.CDB_OB_SPM_EVO_RESULT	Displays the evolution results of SQL plan management for all tenants.
oceanbase.DBA_OB_SPM_EVO_RESULT	Displays the evolution results of SQL plan management for the current tenant.

View name	Feature description
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	Displays the historical event information of a cluster.

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.

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 columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) for 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 optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of tables in a 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.CDB_OB_AUX_STATISTICS	Displays auxiliary statistics for all tenants.
oceanbase.DBA_OB_AUX_STATISTICS	Displays auxiliary statistics for the current tenant.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO	Displays the expiration status of statistics.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	Displays the historical records of table statistics collection tasks.

View name	Feature description
oceanbase.CDB_OB_EXTERNAL_RESOURCES	Displays all uploaded resource files.
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.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES	Displays the list of files for external tables to which the current user has access.

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; it can only be used to 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 for compatibility with MySQL 5.7 only. The related functionality is not supported; it can only be used to query the table structure.

View name	Feature description
oceanbase.CDB_MVIEW_RUNNING_JOBS	It displays all materialized view-related tasks currently in progress for all tenants, including refresh tasks and MLOG cleanup tasks.
oceanbase.CDB_MVIEWS	Displays the materialized view information for all tenants.
oceanbase.CDB_MVIEW_LOGS	This API is used to display the materialized view log information for all tenants.
oceanbase.CDB_MVREF_CHANGE_STATS	This view displays statistics related to materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_RUN_STATS	This API is used to display information on each refresh run of materialized views for all tenants.
oceanbase.CDB_MVREF_STATS	This view displays basic timing statistics for materialized view refreshes across all tenants.
oceanbase.CDB_MVREF_STATS_PARAMS	This view displays the refresh statistics for each materialized view associated with all tenants.
oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS	Displays the system-wide default values for all tenants' materialized view refresh history statistics attributes.
oceanbase.CDB_MVREF_STMT_STATS	This API is used to display information associated with all tenant materialized view refresh statements.
oceanbase.DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays the log information of materialized views.
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 refresh history statistics attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.
oceanbase.ALL_MVIEWS	Displays information about materialized views that the current user can access.
oceanbase.ALL_MVIEW_LOGS	Displays the materialized view log information accessible to the current user.

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`Each unique value must be represented by 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	Displays the write-through 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 the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the view.`SQL_ID` + `Plan_Hash`(The unique value of is 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 statistics item for the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the write-through data of time model statistics for the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays detailed system statistics for the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the persistent tenant-level wait event information for the current tenant.
oceanbase.CDB_WR_SQL_PLAN	Displays the SQL execution plan information collected for write operations of all tenants.
oceanbase.CDB_WR_RES_MGR_SYSSTAT	Displays the resource manager statistics collected for write operations of all tenants.
oceanbase.DBA_WR_SQL_PLAN	Displays the SQL execution plan information collected for write operations of the current tenant.
oceanbase.DBA_WR_RES_MGR_SYSSTAT	Displays the resource manager statistics collected for write requests of the current tenant.

View name	Feature description
oceanbase.CDB_OB_VECTOR_INDEX_TASKS	Displays the vector index task information for all tenants.
oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY	Displays the vector index task history for all tenants.
oceanbase.DBA_OB_VECTOR_INDEX_TASKS	Displays the vector index task information of the current tenant.
oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY	Displays the history of vector index 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_MAJOR_COMPACTION	Displays the global major compaction information for the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the current tenant.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated by major_freeze.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major_freeze.

View name	Feature description
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	Displays information about trusted root certificates.

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	Displays the unit information for 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.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	Displays the basic information of all tenants. This includes 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.CDB_OB_TENANT_EVENT_HISTORY	Displays the event history of all tenants.
oceanbase.DBA_OB_ZONES	Displays information for all zones.

View name	Feature description
oceanbase.DBA_OB_CLONE_HISTORY	Displays the tenant's cloning history.
oceanbase.DBA_OB_CLONE_PROGRESS	Displays the tenant cloning progress information.

View name	Feature description
oceanbase.CDB_OB_TTL_TASKS	Displays the execution status of all user tenant TTL tasks in SQL mode.
oceanbase.CDB_OB_TTL_TASK_HISTORY	Displays the execution history of all user tenant TTL tasks in SQL mode.
oceanbase.DBA_OB_TTL_TASKS	Displays the execution status of TTL tasks for the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY	Displays the execution history of TTL tasks for the current tenant in SQL mode.

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 HMS Catalog clients for all tenants.
V$OB_HMS_CLIENT_POOL_STAT	This API is used to display the usage of HMS Catalog clients for all tenants.
GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT	Retrieves the catalog pooling information of all OBServer nodes.
V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT	Retrieves the catalog pooling information of the OBServer node that executed the SQL statement.

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_TABLET_REPLICA_INFO	Displays the basic information of all tablet replicas on each node of all tenants, including the tenant, log stream, table, database, and disk usage.
V$OB_TABLET_REPLICA_INFO	Displays the basic information of all tablet replicas for all tenants on the current node, including the tenant, log stream, table, database, and disk usage.
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
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 MemStore statistics at the tenant level.
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	This API is used to query the memory usage of each tenant in a 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_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACTION.
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$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT	This view displays the 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 API is used to display 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	Session-level statistical event information for all OBServer nodes.
GV$SYSSTAT	Displays tenant-level statistical event information on all servers.
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_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACTION.
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.
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 details of each event currently being waited for by the session. By convention, each event has three parameters, each recording its corresponding value.
V$SESSION_WAIT_HISTORY	Details of events currently being waited for by each session, including the last 10 such events.
V$SESSTAT	Displays the statistical event overview 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_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 on the current server for the current tenant.
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_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.
GV$OB_SQL_AUDIT	It displays statistical information such as the source and execution status of each SQL request across all servers.
V$OB_SQL_AUDIT	It displays statistical information such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays 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 entry per operation.
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of`OTHERSTAT_X_ID`The meaning of the numbers in the fields.
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.

View name	Feature description
GV$OB_SESSION	Records session information created on all servers.

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 for 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 this 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 all features whose behavior can be controlled for compatibility with the OceanBase Database release version.

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

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	This API is used to count the number of RPC packets sent by different tenant RPC packet codes on an 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 an OBServer node.

View name	Feature description
GV$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory manager.
GV$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays statistics from all previous workareas, such as the number of times processing was done 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 manager.
V$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays statistics for 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.
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 on all OBServer nodes in all tenants.
GV$OB_SESS_TIME_MODEL	Displays time model statistics at the session level for 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 (that is, each`SQL_ID` + `Plan_Hash`(The unique value of is one row.)
GV$OB_SYS_TIME_MODEL	This API is used to query time series metrics of tenants 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 statistical information of resource groups in the current OBServer for all tenants.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistics 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 is one row).
V$OB_SYS_TIME_MODEL	Displays time model statistics at the tenant level on the current 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 thread queues and thread quotas for a tenant.
V$OB_TENANT_RUNTIME_INFO	Displays information related to thread queues and thread quotas for a tenant.

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.

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 IO statistics at the function level for all tenants on the current OBServer node.

View name	Feature description
oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS	Displays information related to the job-level backup verification tasks initiated by this tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY	Displays the execution history of job-level backup verification tasks initiated by this tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS	Displays information about the backup verification task initiated by the current tenant.
oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY	Displays the execution history of backup verification tasks initiated by this tenant.
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_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 a 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 information about the backup destinations used for backup and restore operations in 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 policies set for expired 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 of backup cleanup tasks executed under a tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set or 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 about 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	Record 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.
information_schema.TABLESPACES	Information related to tablespaces. Note This view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
oceanbase.DBA_TABLES	This API is used to display information about all tables of the current tenant.

View name	Feature description
mysql.proc	Displays information about stored procedures.
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
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts by different users.

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 partition information of a user table.
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, its storage attributes, and`DBMS_STATS`The statistics generated by the package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the descriptions of all subpartition templates.

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
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_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.
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 stream (LS) for the current tenant.
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_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.
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 stream (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`Co-generated Help commands.
mysql.help_category	With the other three tables`mysql.help_relation`、`mysql.help_topic`、`mysql.help_keyword`Co-generated Help commands.
mysql.help_keyword	With the other three tables`mysql.help_relation`、`mysql.help_topic`、`mysql.help_category`Generate help commands in collaboration.
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
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 (both waiting and holding locks). 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 only for compatibility with MySQL 5.7. 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	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	This view displays the statistics of the InnoDB buffer pool. 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_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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX_RESET	This view 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; it can only be used to query the table structure.
information_schema.INNODB_CMP_RESET	Displays the status of operations related to compressing 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_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 only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure.
information_schema.INNODB_SYS_TABLES	Displays metadata 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_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; it can only be used to 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 only for compatibility with MySQL 5.7. 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure.

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
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the current tenant's running TTL tasks.
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 parameter information of the client connection for this OBKV tenant.

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 plans and throttling rule outlines of the current tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

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

View name	Feature description
mysql.db	Displays database-level privileges (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 permission information.
information_schema.TABLE_PRIVILEGES	Records table permission information.
information_schema.USER_PRIVILEGES	Records user permission information.

View name	Feature description
information_schema.INNODB_FT_BEING_DELETED	Displays information about the full-text indexes being dropped. 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_FT_CONFIG	This view displays the configuration information of the InnoDB full-text search engine. 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_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 (fields) for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of 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.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.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant.

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
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baseline for the SQL statement in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

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.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information for the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major_freeze.
information_schema.events	Records all event information.

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 columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram data (the endpoints of each histogram) for 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 optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of tables in a database.
information_schema.QUERY_RESPONSE_TIME	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.

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; it can only be used to 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 for compatibility with MySQL 5.7 only. The related functionality is not supported; it can only be used to query the table structure.

View name	Feature description
oceanbase.DBA_WR_SNAPSHOT	Display the of this 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 statistics 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	Displays 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 in the current tenant. Each SQL statement is represented as a row (that is, each`SQL_ID` + `Plan_Hash`Each unique value must be represented by one row).
oceanbase.DBA_WR_SYS_TIME_MODEL	This table displays the write data of time model statistics for the current tenant.

View name	Feature description
oceanbase.DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays the log information of materialized views.
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 refresh history statistics attribute of materialized views.
oceanbase.DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.

View name	Feature description
oceanbase.DBA_OB_TTL_TASKS	Displays the execution status of TTL tasks for the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY	Displays the execution history of TTL tasks for the current tenant in SQL mode.

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

View name	Feature description
information_schema.CHECK_CONSTRAINTS	Display`CREATE TABLE`Constraints on tables and columns during operations.
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 table constraints.

View name	Feature description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

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 group 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	Displays 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.

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 of the current OBServer node in the tenant.
GV$OB_ACTIVE_SESSION_HISTORY	This API is used to display 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 query the usage of the HMS catalog client by the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This API is used to query the usage of the HMS catalog client by the current tenant.
GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT	Retrieves the catalog pooling information of all OBServer nodes.
V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT	Retrieves the catalog pooling information of the OBServer node that executed the SQL statement.

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_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACTION.
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$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SESSION_EVENT	This view displays the 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 API is used to display 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	Session-level statistical event information for all OBServer nodes.
GV$SYSSTAT	Displays tenant-level statistical event information on all servers.
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_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of COMPACTION.
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.
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 details of each event currently being waited for by the session. By convention, each event has three parameters, each recording its corresponding value.
V$SESSION_WAIT_HISTORY	Details of events currently being waited for by each session, including the last 10 such events.
V$SESSTAT	Displays the statistical event overview 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.

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_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 on the current server for the current tenant.
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_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 statistical information such as the source and execution status of each SQL request across all servers.
V$OB_SQL_AUDIT	It displays statistical information such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays 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 entry per operation.
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of`OTHERSTAT_X_ID`The meaning of the numbers in the fields.
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.

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 MemStore statistics at the tenant level.
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	This API is used to query the memory usage of each tenant in a 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$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$LATCH	The view displays the latch information of all OBServer nodes in the cluster.
V$LATCH	View the latch information of all OBServer nodes in the cluster.

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_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_UNITS	Displays the unit information of this 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 all features whose behavior can be controlled for compatibility with the OceanBase Database release version.

View name	Feature description
GV$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory manager.
GV$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays statistics from all previous workareas, such as the number of times processing was done 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 manager.
V$SQL_WORKAREA_ACTIVE	Displays the workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays statistics for 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.
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 API is used to display the statistics 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 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 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 for the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This API is used to query time series metrics of tenants in a cluster.
V$OB_SYS_TIME_MODEL	Displays time model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT	This API is used to display the statistical information of resource groups on the current OBServer node in 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	This API is used to count the number of RPC packets sent by different tenant RPC packet codes on an 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 an 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_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 I/O statistics at the function level for the current tenant on the current OBServer node.

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.

View name	Feature description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Displays 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 the PUBLIC role.
ALL_TAB_PRIVS	* The current user is the object owner, the object permission grantor, or the object permission grantee. * The object permission grantee 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 permissions currently held by the user.
USER_COL_PRIVS	Displays the columns to which the current user has granted access as an object owner, grantor, or grantee.
USER_ROLE_PRIVS	Displays the roles granted to the current user.
USER_SYS_PRIVS	Displays the system privileges granted to the current user.
ROLE_TAB_PRIVS	Displays the table privileges granted to a role. Only information about the roles that users can access is provided.
ROLE_SYS_PRIVS	Displays the system privileges granted to the role.
ROLE_ROLE_PRIVS	Displays the roles granted to 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.
USER_PRIVILEGES	Displays the current user's permission information.

View name	Feature description
USER_POLICIES	Displays the fine-grained access control policy information of the current user.
USER_POLICY_CONTEXTS	Displays the policy context information of the current user.
USER_POLICY_GROUPS	Displays the policy group information of the current user.
USER_SEC_RELEVANT_COLS	Displays the column information related to security policies for the current user.

View name	Feature description
DBA_OB_BACKUP_VALIDATE_JOBS	Displays information related to the job-level backup verification tasks initiated by this tenant.
DBA_OB_BACKUP_VALIDATE_JOB_HISTORY	Displays the execution history of job-level backup verification tasks initiated by this tenant.
DBA_OB_BACKUP_VALIDATE_TASKS	Displays information about the backup verification task initiated by the current tenant.
DBA_OB_BACKUP_VALIDATE_TASK_HISTORY	Displays the execution history of backup verification tasks initiated by this tenant.
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 a 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 information about the backup destinations used for backup and restore operations in 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 policies set for expired 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 of backup cleanup tasks executed under a tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays information about the backup_set or 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 about 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 the user 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 accessible to the current user. 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 have been removed:`PLUGGED_IN`field.
USER_TAB_COLS	Displays all columns of the tables, views, and clusters owned by the current user.
oceanbase.USER_TAB_COLS_V$	Displays the column information for the current user's table and view objects.
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.

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 current accessible storage object.
DBA_SEGMENTS	Displays the storage information allocated for all segments in the database.
USER_SEGMENTS	Displays the storage information allocated for segments under the objects of the current user.

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.
DBA_TRIGGER_ORDERING	Displays the execution sequence information of triggers.
ALL_TRIGGER_ORDERING	Displays the execution sequence information of triggers that the current user can access.
USER_TRIGGER_ORDERING	Displays the trigger execution sequence information of the current user.

View name	Feature description
ALL_METHOD_PARAMS	Displays the method parameters for the object types that the user can access.
DBA_METHOD_PARAMS	Displays the method parameters of the object type in the database.
ALL_TYPE_METHODS	A method that displays the types of objects the user can access.
DBA_TYPE_METHODS	Displays the methods for object types 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
ALL_PART_KEY_COLUMNS	Displays the columns contained in the partitioning key for all partition objects accessible to the user.
ALL_PART_TABLES	Displays the partition information of partitioned tables that the current user can access.
ALL_SUBPARTITION_TEMPLATES	Displays the descriptions 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 that are 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 descriptions 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 table and partition names to which it belongs, its storage attributes, and`DBMS_STATS`The statistics generated by the package.
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 descriptions 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 table subpartition owned by the current user.
USER_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of the current user.

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.

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 stream (LS) for the current tenant.
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.
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>`.
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 a log stream.

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 have been removed:`OWNER`field.

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
NLS_DATABASE_PARAMETERS	Displays NLS parameters at the database level (OceanBase Database tenant level).
NLS_INSTANCE_PARAMETERS	Displays the 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 plans and throttling rule outlines of the current tenant.
DBA_OB_FORMAT_OUTLINES	Records the details of the current tenant's format outline.

View name	Feature description
DBA_SCHEDULER_JOBS	Displays the information about the scheduler jobs 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.
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
USER_PLSQL_COLL_TYPES	Displays the PL/SQL collection type information of the current user.
USER_PLSQL_TYPES	Displays the PL/SQL type information of the current user.
USER_PLSQL_TYPE_ATTRS	Displays the PL/SQL type attribute information of the current user.
DBA_OB_PL_OBJ_CACHE_STATUS	Displays the caching status of PL objects.

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 those in the`ALL_ARGUMENTS`The columns in the middle are the same, and the following columns have been 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 currently owned by the user. Its columns correspond to`ALL_SOURCE`The columns in the middle are the same, and the following columns have been removed:`OWNER`field.

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

View name	Feature description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant.

View name	Feature description
DBA_SQL_PLAN_BASELINES	Displays the plan baseline for the SQL statement in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Feature description
DBA_CONTEXT	Displays all context namespace information in the database.
DBA_OB_DATABASES	Displays the database metadata of a tenant.
DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information for the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information for each zone in the current tenant.
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 among 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.
DBA_OB_FREEZE_INFO	Displays the version information generated by major_freeze.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays global variable information.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays the variable information of the session.

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 entry.
DBA_AUDIT_OBJECT	Displays the audit tracking records for all objects in the database.
DBA_AUDIT_SESSION	Display all information about`CONNECT`and`DISCONNECT`audit trail 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 accessible to the current user.
USER_AUDIT_SESSION	Displays the audit tracking records of the current user's connections and disconnections.
USER_AUDIT_STATEMENT	Displays the commands 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
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 can access 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 the 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.
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 databases owned by the current user.`ALL_IND_PARTITIONS`、`DBA_IND_PARTITIONS`Compared with None`INDEX_OWNER`field.
USER_IND_SUBPARTITIONS	Displays information about all index subpartitions owned by the user in the database.`DBA_IND_SUBPARTITIONS`、`ALL_IND_SUBPARTITIONS`Better than none`INDEX_OWNER`field.
USER_PART_INDEXES	Displays the partition information of the current user's partitioned index.

View name	Feature description
ALL_PART_COL_STATISTICS	Displays the column statistics and histograms of partitions in the partitioned table 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 accessible to the current user.
ALL_SUBPART_HISTOGRAMS	Displays the histogram information for all subpartitions.
ALL_TAB_COL_STATISTICS	Displays the column statistics and histograms of tables accessible to the current user.
ALL_TAB_HISTOGRAMS	Displays information about histograms for all tables.
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 of partitions in a partitioned table.
DBA_PART_HISTOGRAMS	Displays the histogram information of the primary partitions in the current database.
DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information for 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 for the 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 histograms 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 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 optimizer statistics for all indexes in the database.
USER_IND_STATISTICS	Displays optimizer statistics for indexes on 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 a 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.

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
USER_SCHEDULER_JOBS	Displays the information about the current user's scheduled jobs.
ALL_SCHEDULER_JOB_ARGS	Displays the parameters of the scheduled job that users can view.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the scheduler parameters that users can view.
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.

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 statistics 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	Displays 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	Displays the basic performance statistics of 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.

View name	Feature description
DBA_MVIEW_DEPS	Displays the dependencies of materialized views for the current tenant.
DBA_MVIEW_LOGS	Displays the log information of materialized views.
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 refresh history statistics attribute of materialized views.
DBA_MVREF_STMT_STATS	Describes the information associated with the refresh statement.
USER_MVIEW_LOGS	Displays the materialized view log information of the current user.
USER_MVREF_CHANGE_STATS	Displays statistics related to materialized view refreshes for the current user.
USER_MVREF_RUN_STATS	Displays information about each refresh operation of the current user's materialized views.
USER_MVREF_STATS	Displays the basic timing statistics for refreshing materialized views for the current user.
USER_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view for the current user.
USER_MVREF_STATS_SYS_DEFAULTS	Displays the system-wide default values for the materialized view refresh history statistics attributes of the current user.
USER_MVREF_STMT_STATS	Displays information related to the current user's materialized view refresh statements.

View name	Feature description
DBA_OB_TTL_TASKS	Displays the execution status of TTL tasks for the current tenant in SQL mode.
DBA_OB_TTL_TASK_HISTORY	Displays the execution history of TTL tasks for the current tenant in SQL mode.

View name	Feature description
DBA_OB_SOURCE	Displays the source code of objects such as stored procedures and functions.
ALL_OB_SOURCE	Displays the source code of objects accessible to the current user.
USER_OB_SOURCE	Displays the object source code of the current user.

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 constraints of a user's tables.

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.

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 group of resource plan directives in the database.

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 in the current tenant.
V$OB_ACTIVE_SESSION_HISTORY	This API is used to display the active session history of the current OBServer node in the tenant.

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

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 links 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 links must be committed or rolled back before being closed.

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_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache across 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 on the current server for the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers for the current tenant.
V$RSRC_PLAN	Displays the resource management plan of the current active 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 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 displays general 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$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View name	Feature description
V$TIMEZONE_NAMES	Displays the valid time zone names.

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

View name	Feature description
GV$OB_SQL_AUDIT	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_FLT_TRACE_CONFIG	Displays diagnostic information for end-to-end tracing.

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.
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.
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$GLOBALCONTEXT	Displays the global context properties accessible to the current session.`CLIENT_IDENTIFIER`Value.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
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 this 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$SQL_WORKAREA	Workarea statistics of all operators previously executed by the automatic SQL memory manager.
GV$SQL_WORKAREA_ACTIVE	The workspace information of the current active operator.
GV$SQL_WORKAREA_HISTOGRAM	Displays the statistics of all workareas executed previously.
V$OB_SQL_WORKAREA_MEMORY_INFO	Query the overall information of SQL Workarea, including 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 the automatic SQL memory management are collected.
V$SQL_WORKAREA_ACTIVE	The workspace information of the current active operator.
V$SQL_WORKAREA_HISTOGRAM	Displays the statistics of all workareas executed previously.

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 API is used to display the statistics of resource groups on all OBServer nodes in the current tenant.
V$OB_RES_MGR_SYSSTAT	This API is used to display the statistical information of resource groups on the current OBServer node 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 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`(The unique value of is one row.)
GV$OB_SESS_TIME_MODEL	Displays time model statistics at the session level for the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This API is used to query time series metrics of tenants in a cluster.
V$OB_SYS_TIME_MODEL	Displays 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 distribution of the current node in the current tenant.

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_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
V$SQL_MONITOR_STATNAME	Display`GV$SQL_PLAN_MONITOR`of the`OTHERSTAT_X_ID`The meaning of the numbers in the field.
GV$SQL_PLAN_MONITOR	This view displays 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 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.

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 COMPACTION.
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$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays system-level wait events of tenants on all servers, and provides statistics such as the number of occurrences, total wait time, and timeout count for each type of wait event.
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 COMPACTION.
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.
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 whose original scheduler is the current 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.

Overview of views in the sys tenant

Overview of dictionary views

AI models

Security permissions

Security policies

Backup and recovery

Tables and columns

Note

CCL

Storage space

Access control

Partitions

Load balancing

Replica logs

Service management

InnoDB storage engine related

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Temporary files

I/O performance related

OBKV-related

Outline related

PLSQL data types

Full-text index related

Note

Note

Note

Note

Note

Task Scheduling Manager

Event history monitoring related

SPM-related

Upgrade related

Basic database information

Statistics and histograms

External resources

Foreign key related

Note

Note

Materialized views

WR-related

Vector index related

Minor compaction and major compaction

Certificate management

Resource management

Tenant management

Tenant cloning related

TTL-related

Performance view overview

ASH-related

Catalog

DTL

Replica logs

Partition-related

I/O-related

Encryption tables

Memory

Event-related

Cache-related

Session-related

Database-related