Views in OceanBase Database V3.x and V4.x|V4.3.5| docs|Distributed Database

Views in OceanBase Database V3.x and V4.x

Last Updated：2026-02-05 05:53:37 Updated

OceanBase Database V4.x has undergone significant changes in its internal tables and virtual tables, while providing various views to display system information. One of the most notable changes in V4.x is the transition of internal information queries to views, ensuring compatibility across versions and providing clearer information.

For example, the previously commonly used __all_tenant_meta_table view, which stored partition location information, is no longer used in V4.x. In V4.x, partitions no longer have their own location information but are part of a log stream. Partition location information is determined by the location of its associated log stream, which can be viewed using the DBA_OB_LS_LOCATIONS view. Additionally, the __all_zone view, previously used for viewing cluster major compactions, has been modified in V4.x. In this version, only the cluster's Zone, Region, and other such information is stored in the __all_zone table for the system tenant, while major compaction status is split into dedicated internal tables. You can use the DBA_OB_MAJOR_COMPACTION view to view overall major compaction status, and the DBA_OB_ZONE_MAJOR_COMPACTION view to view major compaction status per zone. Unlike previous versions, where major compactions were cluster-wide operations, V4.x allows each tenant to execute its own major compaction operations. Consequently, each tenant can view its major compaction status using the DBA_OB_MAJOR_COMPACTION and DBA_OB_ZONE_MAJOR_COMPACTION views.

Additionally, existing self-defined views in V4.x have been modified according to view definition specifications, including:

Removed unnecessary views.
Added the OB_ prefix to the names of views.
Changed the names of views to uppercase and the names of view columns to uppercase.
If the view is at the tenant level, it displays data only for the user tenant. The system tenant displays data for all tenants.

Correspondence between internal tables and views

OceanBase Database V4.x has added a large number of views. You can query the required information by using the following correspondence between internal tables and views.

Entity table/virtual table	View/command	Description
__all_collation	information_schema.COLLATIONS	This view displays the collation methods of each character set.
__all_tenant	oceanbase.DBA_OB_TENANTS	This view displays the basic information of tenants.
gv$tenant (V4.x deprecated)	To query the information about the current tenant in a MySQL-compatible tenant or an Oracle-compatible tenant, execute the following commands: show tenant; show tenant status; select effective_tenant(); select effective_tenant_id();	This view displays the basic information about a user tenant.
__all_unit_config	oceanbase.DBA_OB_UNIT_CONFIGS	This view displays the Unit Config information.
__all_resource_pool	oceanbase.DBA_OB_RESOURCE_POOLS	This view displays the Resource Pool information.
__all_server	oceanbase.DBA_OB_SERVERS	This view displays the server information.
__all_zone	oceanbase.DBA_OB_ZONES	This view displays the zone information.
__all_rootservice_event_history	oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	This view displays the event history of Root Service.
__all_rootservice_job	oceanbase.DBA_OB_UNIT_JOBS oceanbase.DBA_OB_TENANT_JOBS oceanbase.DBA_OB_SERVER_JOBS	This view splits the RootService job information into multiple views, which are differentiated based on the types of job information they display. This helps you perform structured queries.
__all_virtual_core_all_table	oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution information of log streams (LS) replicas of the current tenant.
gv$database(V4.x deprecated) __all_database	oceanbase.CDB_OB_DATABASES oceanbase.DBA_OB_DATABASES information_schema.SCHEMATA oceanbase.DBA_USERS	Database information
gv$table(V4.x deprecated) __all_table __all_virtual_table	oceanbase.CDB_OBJECTS oceanbase.CDB_TABLES oceanbase.CDB_INDEXES oceanbase.CDB_IND_COLUMNS oceanbase.CDB_PART_TABLES oceanbase.CDB_TAB_PARTITIONS	This view displays the schema information of all tenants in the system tenant.
	information_schema.TABLES information_schema.STATISTICS	This view displays the table and index information in a MySQL-compatible tenant.
	SYS.DBA_TABLES SYS.DBA_INDEXES	This view displays the table and index information in an Oracle-compatible tenant.
	SYS.DBA_PART_TABLES SYS.DBA_PART_INDEXES	This view displays the partition table information in an Oracle-compatible tenant.
	oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES	This view displays the partition table information in a MySQL-compatible tenant.
	SYS.DBA_OBJECTS	This view displays the partition table information in an Oracle-compatible tenant.
	oceanbase.DBA_OBJECTS	This view displays the partition table information in a MySQL-compatible tenant.
	oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES	This view displays the information about the tablegroup of a table.
__all_virtual_sys_variable __all_sys_variable	oceanbase.CDB_OB_SYS_VARIABLES	This view displays the system variable information of all tenants in the system tenant.
	Related views for MySQL-compatible tenant: information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES Related commands for MySQL-compatible tenant: show variables; show global variables;	This view displays the system variable information in a MySQL-compatible tenant.
	Oracle-compatible tenants: show variables; show global variables;	This view displays the system variable information in an Oracle-compatible tenant.
__tenant_virtual_table_index	information_schema.STATISTICS	Obtains information about index keys in a MySQL-compatible tenant.
__tenant_virtual_table_index	SYS.DBA_CONS_COLUMNS	Obtains information about index keys in an Oracle-compatible tenant.
__all_part __all_virtual_part __all_def_sub_part __all_virtual_def_sub_part	oceanbase.CDB_TAB_PARTITIONS oceanbase.CDB_TAB_SUBPARTITIONS oceanbase.CDB_IND_PARTITIONS oceanbase.CDB_IND_SUBPARTITIONS oceanbase.CDB_SUBPARTITION_TEMPLATES	Obtains information about partitions of all tenants in the sys tenant.
	SYS.DBA_TAB_PARTITIONS SYS.DBA_TAB_SUBPARTITIONS SYS.DBA_IND_PARTITIONS SYS.DBA_IND_SUBPARTITIONS SYS.DBA_SUBPARTITION_TEMPLATES	Obtains information about partitions in an Oracle-compatible tenant.
	oceanbase.DBA_TAB_PARTITIONS oceanbase.DBA_TAB_SUBPARTITIONS oceanbase.DBA_IND_PARTITIONS oceanbase.DBA_IND_SUBPARTITIONS oceanbase.DBA_SUBPARTITION_TEMPLATES	Obtains information about partitions in a MySQL-compatible tenant.
__all_virtual_outline __all_outline	oceanbase.DBA_OB_OUTLINES oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays information about outlines.
__all_root_table __all_meta_table __all_tenant_meta_table __all_virtual_tenant_meta_table	oceanbase.DBA_OB_LS_LOCATIONS oceanbase.CDB_OB_LS_LOCATIONS oceanbase.DBA_OB_TABLET_TO_LS oceanbase.CDB_OB_TABLET_TO_LS oceanbase.DBA_OBJECTS CDB_OBJECTS	Displays information about locations.
__all_virtual_server_stat __all_virtual_disk_stat	GV$OB_SERVERS	Displays information about server statistics.
__all_virtual_tenant_parameter_stat __all_virtual_sys_parameter_stat __all_virtual_tenant_parameter_stat __all_virtual_sys_parameter_stat __all_virtual_tenant_parameter_info	GV$OB_PARAMETERS	Displays information about configuration items.
__all_virtual_processlist	GV$OB_PROCESSLIST	Displays information about sessions.
__all_virtual_kvcache_info	GV$OB_KVCACHE	Displays information about KVCACHE.
GV$MEMSTORE(V4.x deprecated) __all_virtual_tenant_memstore_info	GV$OB_MEMSTORE	Displays information about MemStore.
__all_virtual_column	oceanbase.CDB_TAB_COLUMNS oceanbase.CDB_TAB_COLS	Accesses views of all tenants in the sys tenant.
	information_schema.COLUMNS	Displays information about columns.
	oceanbase.DBA_TAB_COLUMNS oceanbase.DBA_TAB_COLS	Displays information about columns.
	oceanbase.DBA_OB_TABLET_TO_LS oceanbase.CDB_OB_TABLET_TO_LS	Lists all tablets and the log streams to which they belong.
	oceanbase.DBA_OB_TABLET_REPLICAS oceanbase.CDB_OB_TABLET_REPLICAS	Lists all tablet replicas.
__all_virtual_trans_stat	GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all servers.
——	Related views: oceanbase.DBA_RECYCLEBIN DBA_RECYCLEBIN Related command: show recyclebin;	Displays information about the recycle bin.
__all_zone	oceanbase.DBA_OB_MAJOR_COMPACTION	Displays overall major compaction status.
__all_zone	oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays major compaction status in each zone.

Views renamed in V4.x

The view name changes are mainly for standardizing the view content and making it easier for you to perform related operations. The view name changes in V3.x and V4.x are as follows:

In OceanBase Database versions earlier than V4.0, some built-in views do not have the OB_* prefix, such as v$plan_cache_stat and v$obrpc_outgoing.
In OceanBase Database V4.0 and later, the OB_* prefix is added to all views, such as V$OB_PLAN_CACHE_STAT and V$OB_RPC_OUTGOING.

The following table lists the views whose names have been changed in V4.x.

View name	Version	New view name
GV$ACTIVE_SESSION_HISTORY	V4.2.2	GV$OB_ACTIVE_SESSION_HISTORY Note The original view is not deleted but is not recommended for use.
V$ACTIVE_SESSION_HISTORY	V4.2.2	V$OB_ACTIVE_SESSION_HISTORY Note The original view is not deleted but is not recommended for use.
GV$SERVER_MEMSTORE	V4.0.0	GV$OB_MEMSTORE
GV$PLAN_CACHE_STAT	V4.0.0	GV$OB_PLAN_CACHE_STAT
GV$PLAN_CACHE_PLAN_STAT	V4.0.0	GV$OB_PLAN_CACHE_PLAN_STAT
GV$SQL_AUDIT	V4.0.0	GV$OB_SQL_AUDIT
GV$MEMORY	V4.0.0	GV$OB_MEMORY
V$MEMORY	V4.0.0	V$OB_MEMORY
GV$MEMSTORE	V4.0.0	GV$OB_MEMSTORE
V$MEMSTORE	V4.0.0	V$OB_MEMSTORE
GV$MEMSTORE_INFO	V4.0.0	GV$OB_MEMSTORE_INFO
V$MEMSTORE_INFO	V4.0.0	V$OB_MEMSTORE_INFO
V$PLAN_CACHE_STAT	V4.0.0	V$OB_PLAN_CACHE_STAT
V$PLAN_CACHE_PLAN_STAT	V4.0.0	V$OB_PLAN_CACHE_PLAN_STAT
GV$PLAN_CACHE_PLAN_EXPLAIN	V4.0.0	V$OB_PLAN_CACHE_PLAN_STAT
V$PLAN_CACHE_PLAN_EXPLAIN	V4.0.0	V$OB_PLAN_CACHE_PLAN_EXPLAIN
V$SQL_AUDIT	V4.0.0	V$OB_SQL_AUDIT
GV$OBRPC_OUTGOING	V4.0.0	GV$OB_RPC_OUTGOING
V$OBRPC_OUTGOING	V4.0.0	V$OB_RPC_OUTGOING
GV$OBRPC_INCOMING	V4.0.0	GV$OB_RPC_INCOMMING
V$OBRPC_INCOMING	V4.0.0	V$OB_RPC_INCOMMING
GV$CONCURRENT_LIMIT_SQL	V4.0.0	DBA_OB_CONCURRENT_LIMIT_SQL
GV$TENANT_SEQUENCE_OBJECT	V4.0.0	DBA_OB_SEQUENCE_OBJECTS
GV$TENANT_PX_WORKER_STAT	V4.0.0	GV$OB_PX_WORKER_STAT
V$TENANT_PX_WORKER_STAT	V4.0.0	V$OB_PX_WORKER_STAT
GV$PS_STAT	V4.0.0	GV$OB_PS_STAT
V$PS_STAT	V4.0.0	V$OB_PS_STAT
GV$PS_ITEM_INFO	V4.0.0	GV$OB_PS_ITEM_INFO
V$PS_ITEM_INFO	V4.0.0	V$OB_PS_ITEM_INFO
GV$PLAN_CACHE_REFERENCE_INFO	V4.0.0	GV$OB_PLAN_CACHE_REFRENCE_INFO
V$PLAN_CACHE_REFERENCE_INFO	V4.0.0	V$OB_PLAN_CACHE_REFRENCE_INFO
GV$SSTABLE	V4.0.0	GV$OB_SSTABLES
V$SSTABLE	V4.0.0	V$OB_SSTABLES
GV$SERVER_SCHEMA_INFO	V4.0.0	GV$OB_SERVER_SCHEMA_INFO
V$SERVER_SCHEMA_INFO	V4.0.0	V$OB_SERVER_SCHEMA_INFO
V$ENCRYPTED_TABLES	V4.0.0	V$OB_ENCRYPTED_TABLES
GV$TENANT_MEMORY_INFO	V4.0.0	GV$OB_TENANT_MEMORY
V$TENANT_MEMORY_INFO	V4.0.0	V$OB_TENANT_MEMORY
GV$PX_TARGET_MONITOR	V4.0.0	GV$OB_PX_TARGET_MONITOR
V$PX_TARGET_MONITOR	V4.0.0	V$OB_PX_TARGET_MONITOR
GV$SQL_AUDIT	V4.0.0	GV$OB_SQL_AUDIT
V$SQL_AUDIT	V4.0.0	V$OB_SQL_AUDIT
GV$PLAN_CACHE_PLAN_STAT	V4.0.0	GV$OB_PLAN_CACHE_PLAN_STAT
V$PLAN_CACHE_PLAN_STAT	V4.0.0	V$OB_PLAN_CACHE_PLAN_STAT
GV$PLAN_CACHE_PLAN_EXPLAIN	V4.0.0	GV$OB_PLAN_CACHE_PLAN_EXPLAIN
V$PLAN_CACHE_PLAN_EXPLAIN	V4.0.0	V$OB_PLAN_CACHE_PLAN_EXPLAIN
GV$MEMORY	V4.0.0	GV$OB_MEMORY
V$MEMORY	V4.0.0	V$OB_MEMORY
GV$MEMSTORE	V4.0.0	GV$OB_MEMSTORE
V$MEMSTORE	V4.0.0	V$OB_MEMSTORE
GV$PLAN_CACHE_STAT	V4.0.0	GV$OB_PLAN_CACHE_STAT
V$PLAN_CACHE_STAT	V4.0.0	GV$OB_PLAN_CACHE_STAT
GV$CONCURRENT_LIMIT_SQL	V4.0.0	GV$OB_CONCURRENT_LIMIT_SQL
GV$TENANT_PX_WORKER_STAT	V4.0.0	GV$OB_PX_WORKER_STAT
V$TENANT_PX_WORKER_STAT	V4.0.0	V$OB_PX_WORKER_STAT
GV$PS_STAT	V4.0.0	GV$OB_PS_STAT
V$PS_STAT	V4.0.0	V$OB_PS_STAT
GV$PS_ITEM_INFO	V4.0.0	GV$OB_PS_ITEM_INFO
V$PS_ITEM_INFO	V4.0.0	V$OB_PS_ITEM_INFO
GV$PLAN_CACHE_REFERENCE_INFO	V4.0.0	GV$OB_PLAN_CACHE_REFRENCE_INFO
V$PLAN_CACHE_REFERENCE_INFO	V4.0.0	V$OB_PLAN_CACHE_REFRENCE_INFO
GV$SSTABLE	V4.0.0	GV$OB_SSTABLES
V$SSTABLE	V4.0.0	V$OB_SSTABLES
GV$SERVER_SCHEMA_INFO	V4.0.0	GV$OB_SERVER_SCHEMA_INFO
V$SERVER_SCHEMA_INFO	V4.0.0	V$OB_SERVER_SCHEMA_INFO
V$ENCRYPTED_TABLES	V4.0.0	V$OB_ENCRYPTED_TABLES
GV$TENANT_MEMORY_INFO	V4.0.0	GV$OB_TENANT_MEMORY
V$TENANT_MEMORY_INFO	V4.0.0	V$OB_TENANT_MEMORY
GV$PX_TARGET_MONITOR	V4.0.0	GV$OB_PX_TARGET_MONITOR
V$PX_TARGET_MONITOR	V4.0.0	V$OB_PX_TARGET_MONITOR
USER_RECYCLEBIN	V4.0.0	oceanbase.DBA_RECYCLEBIN/SYS.DBA_RECYCLEBIN
GV$MERGE_INFO	V4.0.0	GV$OB_MERGE_INFO
V$MERGE_INFO	V4.0.0	V$OB_MERGE_INFO

Views added in V4.x

The following table lists the views added in V4.x.

View	Version	Description
oceanbase.CDB_OB_CCL_RULES oceanbase.DBA_OB_CCL_RULES	V4.3.5 BP3	This view displays the throttling rules of a tenant.
V$OB_SQL_CCL_STATUS GV$OB_SQL_CCL_STATUS	V4.3.5 BP3	This view displays the number of SQL statements that hit the throttling rules of all tenants on all nodes at the current moment.
GV$OB_TABLET_LOCAL_CACHE V$OB_TABLET_LOCAL_CACHE	V4.3.5 BP2	This view displays the cache information of a tablet.
GV$OB_STORAGE_CACHE_TASKS V$OB_STORAGE_CACHE_TASKS	V4.3.5 BP2	This view displays the cache task information.
oceanbase.CDB_OB_CS_REPLICA_STATS oceanbase.DBA_OB_CS_REPLICA_STATS DBA_OB_CS_REPLICA_STATS	V4.3.5 1 BP1	This view displays the progress of converting a tablet to a columnar tablet in the log stream of a C replica on each OBServer node of a tenant.
GV$OB_SS_LOCAL_CACHE V$OB_SS_LOCAL_CACHE	V4.3.4	This view displays the metrics of various types of cached data in the local cache of each OBServer node of a tenant.
oceanbase.CDB_OB_STORAGE_IO_USAGE oceanbase.DBA_OB_STORAGE_IO_USAGE DBA_OB_STORAGE_IO_USAGE	V4.3.4	This view displays the I/O operations of object storage and cloud disks of a tenant.
oceanbase.CDB_OB_RSRC_DIRECTIVES oceanbase.DBA_OB_RSRC_DIRECTIVES DBA_OB_RSRC_DIRECTIVES	V4.3.4	This view displays the resource configuration parameters of a tenant in the Resource Manager.
GV$OB_SHARED_STORAGE_QUOTA V$OB_SHARED_STORAGE_QUOTA	V4.3.4	This view displays the I/O access resource information of each OBServer node.
GV$OB_GROUP_IO_STAT V$OB_GROUP_IO_STAT	V4.3.3	This view displays the real-time status of each resource group on each OBServer node.
information_schema.EVENTS	V4.3.2	This view records the information of all events.
V$OB_COMPATIBILITY_CONTROL	V4.3.2	This view is available only to the sys tenant and MySQL-compatible tenants. It displays the features that can be controlled for compatibility with the behavior of OceanBase Database.
DBA_OB_SPATIAL_COLUMNS	V4.3.2	This view is available only to Oracle-compatible tenants. It displays the database name, table name, type, and SRS information of a spatial index column.
PROXY_USERS	V4.3.2	This view is available only to Oracle-compatible tenants. It displays the proxy information between users.
mysql.columns_priv	V4.3.1	This view displays the column privileges granted to a user.
mysql.default_roles	V4.3.1	This view displays the default roles of a user.
mysql.procs_priv	V4.3.1	This view stores the privileges of stored procedures and functions.
mysql.role_edges	V4.3.1	This view displays the grant relationships between roles and users.
oceanbase.DBA_OB_SYS_VARIABLES DBA_OB_SYS_VARIABLES	V4.3.1	This view displays the configuration of system variables of the current tenant.
GV$OB_NIC_INFO V$OB_NIC_INFO	V4.3.1	This view displays the NIC information of an OBServer node, mainly the NIC speed.
GV$OB_PL_CACHE_OBJECT V$OB_PL_CACHE_OBJECT	V4.3.1	This view displays the basic information of PL-related cached objects in the server.
GV$OB_TENANT_RESOURCE_LIMIT V$OB_TENANT_RESOURCE_LIMIT	V4.3.1	This view displays the logical resource usage, upper limit, effective constraints, and maximum usage after a restart on an OBServer node.
GV$OB_TENANT_RESOURCE_LIMIT_DETAIL V$OB_TENANT_RESOURCE_LIMIT_DETAIL	V4.3.1	This view displays the constraints on logical resources on an OBServer node and the upper limits of each constraint.
oceanbase.CDB_INDEX_USAGE oceanbase.DBA_INDEX_USAGE DBA_INDEX_USAGE	V4.3.0	This view displays the index usage data.
oceanbase.CDB_MVIEW_LOGS oceanbase.DBA_MVIEW_LOGS ALL_MVIEW_LOGS DBA_MVIEW_LOGS USER_MVIEW_LOGS	V4.3.0	This view displays the information of materialized view logs.
oceanbase.CDB_MVIEWS oceanbase.DBA_MVIEWS ALL_MVIEWS DBA_MVIEWS USER_MVIEWS	V4.3.0	This view displays information about materialized views.
oceanbase.CDB_MVREF_CHANGE_STATS oceanbase.DBA_MVREF_CHANGE_STATS DBA_MVREF_CHANGE_STATS USER_MVREF_CHANGE_STATS	V4.3.0	This view displays statistics about materialized view refreshes.
oceanbase.CDB_MVREF_RUN_STATS oceanbase.DBA_MVREF_RUN_STATS DBA_MVREF_RUN_STATS USER_MVREF_RUN_STATS	V4.3.0	This view displays information about each materialized view refresh, identified by REFRESH_ID.
oceanbase.CDB_MVREF_STATS oceanbase.DBA_MVREF_STATS DBA_MVREF_STATS USER_MVREF_STATS	V4.3.0	This view displays basic timing statistics for materialized view refreshes.
oceanbase.CDB_MVREF_STATS_PARAMS oceanbase.DBA_MVREF_STATS_PARAMS DBA_MVREF_STATS_PARAMS USER_MVREF_STATS_PARAMS	V4.3.0	This view displays statistics for each materialized view.
oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS DBA_MVREF_STATS_SYS_DEFAULTS USER_MVREF_STATS_SYS_DEFAULTS	V4.3.0	This view displays system-level default values for materialized view refresh statistics.
oceanbase.CDB_MVREF_STMT_STATS oceanbase.DBA_MVREF_STMT_STATS DBA_MVREF_STMT_STATS USER_MVREF_STMT_STATS	V4.3.0	This view displays information about refresh statements.
oceanbase.CDB_OB_AUX_STATISTICS oceanbase.DBA_OB_AUX_STATISTICS DBA_OB_AUX_STATISTICS	V4.3.0	This view displays auxiliary statistics for all tenants.
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	V4.3.0	This view displays the list of trusted CA root certificates for the OBServer cluster and their expiration times.
GV$OB_LS_SNAPSHOTS V$OB_LS_SNAPSHOTS	V4.3.0	This view displays information about log stream snapshots stored in the unit.
GV$OB_SESSION V$OB_SESSION	V4.3.0	This view records information about sessions created in the server.
USER_USERS	V4.2.1 BP2	This view displays information about the current user.
GV$OB_KV_CONNECTIONS V$OB_KV_CONNECTIONS	V4.2.1_CE_BP1	This view displays statistics about OBKV connections in the server.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY DBA_OB_IMPORT_TABLE_JOB_HISTORY	V4.2.1	This view displays the results of import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS oceanbase.DBA_OB_IMPORT_TABLE_JOBS DBA_OB_IMPORT_TABLE_JOBS	V4.2.1	This view displays information about import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY DBA_OB_IMPORT_TABLE_TASK_HISTORY	V4.2.1	This view displays the history of table-level cross-tenant import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS oceanbase.DBA_OB_IMPORT_TABLE_TASKS DBA_OB_IMPORT_TABLE_TASKS	V4.2.1	This view displays records of table-level cross-tenant import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY DBA_OB_RECOVER_TABLE_JOB_HISTORY	V4.2.1	This view displays the results of table-level recovery tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS oceanbase.DBA_OB_RECOVER_TABLE_JOBS DBA_OB_RECOVER_TABLE_JOBS	V4.2.1	This view displays information about table-level recovery tasks.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS DBA_OB_TRANSFER_PARTITION_TASKS	V4.2.1	This view displays the current partition transfer tasks being processed by all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	V4.2.1	This view displays the history of executed Transfer Partition tasks for the tenant.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY DBA_WR_ACTIVE_SESSION_HISTORY	V4.2.1	This view displays the persistent ASH data of the tenant.
oceanbase.CDB_WR_CONTROL oceanbase.DBA_WR_CONTROL DBA_WR_CONTROL	V4.2.1	This view displays the configuration information related to WR.
oceanbase.CDB_WR_SNAPSHOT oceanbase.DBA_WR_SNAPSHOT DBA_WR_SNAPSHOT	V4.2.1	This view displays the `SNAPSHOT` information of the tenant.
oceanbase.CDB_WR_STATNAME oceanbase.DBA_WR_STATNAME DBA_WR_STATNAME	V4.2.1	This view displays the names of the system statistics of the tenant.
oceanbase.CDB_WR_SYSSTAT oceanbase.DBA_WR_SYSSTAT DBA_WR_SYSSTAT	V4.2.1	This view displays the detailed information of the system statistics of all tenants.
GV$OB_FLT_TRACE_CONFIG	V4.2.1	This view displays the diagnostic information of full-link tracing.
GV$OB_TENANT_RUNTIME_INFO V$OB_TENANT_RUNTIME_INFO	V4.2.1	This view displays the information about queues and thread limits in the tenant threads.
DBA_SCHEDULER_JOB_RUN_DETAILS	V4.2.1	This view displays the information about all scheduler jobs in the current tenant.
DBMS_LOCK_ALLOCATED	V4.2.1	This view displays the information about the current user.
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG DBA_OB_DATA_DICTIONARY_IN_LOG	V4.2.0	This view records the range of the location of the data dictionary in the system log stream, which facilitates the consumption of the data dictionary by CDC.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	V4.2.0	This view queries the execution status of historical collection tasks.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	V4.2.0	This view queries the execution status of historical collection tasks for tables.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE oceanbase.DBA_OB_LOG_RESTORE_SOURCE DBA_OB_LOG_RESTORE_SOURCE	V4.2.0	This view displays the log restore sources of the primary and standby tenants.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO DBA_OB_TABLE_STAT_STALE_INFO	V4.2.0	This view displays the number of DML operations performed on each table since the last statistics collection, and whether the current statistics are stale.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES oceanbase.DBA_OB_EXTERNAL_TABLE_FILES DBA_OB_EXTERNAL_TABLE_FILES	V4.2.0	This view displays the list of files corresponding to the external tables created by the tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES ALL_OB_EXTERNAL_TABLE_FILES	V4.2.0	This view displays the list of files of the external tables that the current user has access permissions to.
oceanbase.CDB_OB_BALANCE_JOBS oceanbase.DBA_OB_BALANCE_JOBS DBA_OB_BALANCE_JOBS	V4.2.0	This view displays the load balancing tasks currently being executed by the tenant.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY oceanbase.DBA_OB_BALANCE_JOB_HISTORY DBA_OB_BALANCE_JOB_HISTORY	V4.2.0	This view displays the history of load balancing tasks executed by the tenant.
oceanbase.CDB_OB_BALANCE_TASKS oceanbase.DBA_OB_BALANCE_TASKS DBA_OB_BALANCE_TASKS	V4.2.0	This view displays the load balancing tasks that are being executed in the current tenant.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY oceanbase.DBA_OB_BALANCE_TASK_HISTORY DBA_OB_BALANCE_TASK_HISTORY	V4.2.0	This view displays the history of load balancing tasks executed in the tenant.
oceanbase.CDB_OB_TRANSFER_TASKS oceanbase.DBA_OB_TRANSFER_TASKS DBA_OB_TRANSFER_TASKS	V4.2.0	This view displays the Transfer tasks that are being executed in the current tenant.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY oceanbase.DBA_OB_TRANSFER_TASK_HISTORY DBA_OB_TRANSFER_TASK_HISTORY	V4.2.0	This view displays the history of Transfer tasks executed in the tenant.
oceanbase.CDB_OB_ACCESS_POINT oceanbase.DBA_OB_ACCESS_POINT DBA_OB_ACCESS_POINT	V4.2.0	This view displays the list of servers of the tenant entry.
oceanbase.DBA_DB_LINKS	V4.2.0	This view displays all DBLINKs created in the current tenant.
oceanbase.CDB_OB_LS_HISTORY oceanbase.DBA_OB_LS_HISTORY DBA_OB_LS_HISTORY	V4.2.0	This view displays the history of log streams that existed in the tenant.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY oceanbase.DBA_OB_TENANT_EVENT_HISTORY DBA_OB_TENANT_EVENT_HISTORY	V4.2.0	This view displays the historical operation records of all tenants in the cluster. Only the sys tenant can access this view.
GV$OB_THREAD V$OB_THREAD	V4.2.0	This view displays the status of all threads in the observer process.
GV$OB_ARBITRATION_SERVICE_STATUS V$OB_ARBITRATION_SERVICE_STATUS	V4.2.0	This view displays the communication status between the cluster and the arbitration service.
GV$OB_ARBITRATION_MEMBER_INFO V$OB_ARBITRATION_MEMBER_INFO	V4.2.0	This view displays the arbitration member information of the current cluster.
GV$OB_OPT_STAT_GATHER_MONITOR V$OB_OPT_STAT_GATHER_MONITOR	V4.2.0	This view queries the real-time status of statistics collection tasks.
GV$OB_LOCKS V$OB_LOCKS	V4.2.0	This view displays the locking and lock request information of each table for the current user.
V$OB_LS_LOG_RESTORE_STATUS	V4.2.0	This view displays the log stream-level log restore status.
V$OB_TIMESTAMP_SERVICE	V4.2.0	This view displays the GTS/STS values, node information, and clock source type of the tenant clock service.
GV$OB_PX_P2P_DATAHUB V$OB_PX_P2P_DATAHUB	V4.2.0	This view displays the information of parallel execution data transfer operations.
GV$SQL_JOIN_FILTER V$SQL_JOIN_FILTER	V4.2.0	This view dynamically displays the execution information of Join Filter.
GV$OB_SQL_PLAN V$OB_SQL_PLAN	V4.2.0	This view displays the plan information collected by the EXPLAIN PLAN tool executed by the user.
oceanbase.DBA_OB_USER_DEFINED_RULES DBA_OB_USER_DEFINED_RULES	V4.1.0	This view records the rules for rewriting SQL statements.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS DBA_OB_LS_LOG_ARCHIVE_PROGRESS	V4.1.0	This view displays the log stream archiving progress of the tenant.
oceanbase.DBA_OB_ARBITRATION_SERVICE	V4.1.0	This view displays the arbitration service configuration information of the current cluster. Only the sys tenant can access this view.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS DBA_OB_LS_ARB_REPLICA_TASKS	V4.1.0	This view displays the arbitration service tasks running in the current tenant and the corresponding user tenant.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	V4.1.0	This view displays the history of arbitration service tasks executed by the tenant and its corresponding user tenants.
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	V4.1.0	This view displays important cluster-level events. Only the sys tenant can access this view. Currently, it only supports displaying cluster upgrade events.
oceanbase.DBA_OB_RSRC_IO_DIRECTIVES DBA_OB_RSRC_IO_DIRECTIVES	V4.1.0	This view displays the IO resource configuration in the Resource Manager.
V$OB_ARCHIVE_DEST_STATUS	V4.1.0	This view displays the status of each archive destination at the tenant level.
DBA_OB_TENANTS DBA_OB_TENANTS	V4.1.0	This view displays the basic information of the tenant.
ALL_POLICIES DBA_POLICIES USER_POLICIES	V4.1.0	This view displays that multiple policies can be created on a single table for access control.
ALL_POLICY_GROUPS DBA_POLICY_GROUPS USER_POLICY_GROUPS	V4.1.0	This view displays the information of policy groups. It works with policy contexts to apply different policies to different users.
ALL_POLICY_CONTEXTS DBA_POLICY_CONTEXTS USER_POLICY_CONTEXTS	V4.1.0	This view displays that the corresponding policy group is selected based on the value of the context when accessing a view.
ALL_SEC_RELEVANT_COLS DBA_SEC_RELEVANT_COLS USER_SEC_RELEVANT_COLS	V4.1.0	This view associates a column with a column-level policy. When this column is accessed, the corresponding policy is applied.
ALL_TRIGGER_ORDERING DBA_TRIGGER_ORDERING USER_TRIGGER_ORDERING	V4.1.0	This view displays the sorting of all triggers in the current database.
ALL_DB_LINKS	V4.1.0	This view displays all DBLINKs accessible by the current user.
DBA_DB_LINKS	V4.1.0	This view displays all DBLINKs created under the current tenant.
USER_DB_LINKS	V4.1.0	This view displays the DBLINKs created by the current user.
DBA_OB_UNITS GV$OB_UNITS	V4.0.0	This view displays the Unit information of the tenant.
DBA_OB_UNIT_CONFIGS	V4.0.0	This view displays the Unit specifications of all tenants.
DBA_OB_RESOURCE_POOLS	V4.0.0	This view displays the resource pool information of all tenants.
DBA_OB_SERVERS	V4.0.0	This view displays the information of all OBServer nodes.
DBA_OB_ZONES	V4.0.0	This view displays the information of all zones.
DBA_OB_ROOTSERVICE_EVENT_HISTORY	V4.0.0	This view displays the Root Service event history.
DBA_OB_UNIT_JOBS DBA_OB_TENANT_JOBS DBA_OB_SERVER_JOBS	V4.0.0	This view displays the information of Root Service Jobs.
DBA_OB_LS_LOCATIONS	V4.0.0	This view displays the location information of RS under the sys tenant.
DBA_OB_DATABASES CDB_OB_DATABASES information_schema.SCHEMATA DBA_USERS	V4.0.0	This view displays the database metadata of the tenant.
CDB_OBJECTS CDB_TABLES CDB_INDEXES CDB_IND_COLUMNS CDB_PART_TABLES CDB_TAB_PARTITIONS	V4.0.0	This view displays the schema information of all tenants under the sys tenant.
information_schema.TABLES information_schema.STATISTICS	V4.0.0	This view displays the information of all tables and indexes under the tenant.
DBA_TABLES DBA_INDEXES	V4.0.0	This view displays the information of tables and indexes under the tenant.
oceanbase.DBA_PART_TABLES DBA_PART_TABLES	V4.0.0	This view displays the partition information of partition tables accessible by the current user.
oceanbase.DBA_PART_INDEXES DBA_PART_INDEXES	V4.0.0	This view displays the partition information of all partition indexes.
oceanbase.DBA_OBJECTS DBA_OBJECTS	V4.0.0	This view displays the index status of the tenant.
oceanbase.DBA_OB_TABLEGROUP_TABLES DBA_OB_TABLEGROUP_TABLES	V4.0.0	This view displays the association between a tablegroup and a table.
CDB_OB_SYS_VARIABLES	V4.0.0	This view displays the system variables of all tenants under the sys tenant.
information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES	V4.0.0	This view displays the system variables of a tenant.
DBA_CONS_COLUMNS	V4.0.0	This view displays the columns of all constraints.
CDB_TAB_PARTITIONS CDB_TAB_SUBPARTITIONS CDB_IND_PARTITIONS CDB_IND_SUBPARTITIONS CDB_SUBPARTITION_TEMPLATES	V4.0.0	This view displays the partition information of all tenants under the sys tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	This view displays the partition information of a tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	This view displays the partition information and partition storage parameters.
DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL	V4.0.0	This view displays the outline information of a tenant.
GV$OB_COMPACTION_PROGRESS V$OB_COMPACTION_PROGRESS GV$OB_TABLET_COMPACTION_PROGRESS V$OB_TABLET_COMPACTION_PROGRESS GV$OB_TABLET_COMPACTION_HISTORY V$OB_TABLET_COMPACTION_HISTORY GV$OB_COMPACTION_DIAGNOSE_INFO V$OB_COMPACTION_DIAGNOSE_INFO GV$OB_COMPACTION_SUGGESTIONS V$OB_COMPACTION_SUGGESTIONS	V4.0.0	This view displays the compaction information.
DBA_OB_LS_LOCATIONS CDB_OB_LS_LOCATIONS DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS DBA_OBJECTS CDB_OBJECTS	V4.0.0	This view displays the log stream information. You can obtain the data_object_id of a table or partition from the DBA_OBJECTS view. You can obtain the distribution information of a tablet by using the data_object_id as the tablet_id to query the DBA_OB_TABLET_TO_LS and DBA_OB_LS_LOCATIONS views.
GV$OB_SERVERS	V4.0.0	This view displays the information of all OBServer nodes.
GV$OB_PARAMETERS	V4.0.0	This view displays the configuration information of all OBServer nodes where a tenant is located.
GV$OB_PROCESSLIST	V4.0.0	This view displays the session information of all OBServer nodes where a tenant is located.
GV$OB_KVCACHE	V4.0.0	This view displays the KVCACHE information of each OBServer node.
GV$OB_MEMSTORE	V4.0.0	This view displays the memory usage of all MemTables of all tenants on all servers.
CDB_TAB_COLS	V4.0.0	This view displays the views of all tenants under the sys tenant.
information_schema.COLUMNS	V4.0.0	This view displays the column information.
DBA_TAB_COLUMNS DBA_TAB_COLS	V4.0.0	This view displays the column information.
DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS	V4.0.0	This view displays the list of all tablets and the corresponding log stream (LS) information.
DBA_OB_TABLET_REPLICAS CDB_OB_TABLET_REPLICAS	V4.0.0	This view displays the information of all tablet replicas.
GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	V4.0.0	This view displays the information about transaction participants on all servers.
DBA_RECYCLEBIN oceanbase.DBA_RECYCLEBIN	V4.0.0	This view displays the information about recycle bins.

Views deprecated in V4.x

The following table lists the views deprecated in V4.x.

View	Deprecated in	Description
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	V4.2.0	This view is deprecated due to architectural changes. You can query the oceanbase.CDB_OB_TABLEGROUPS view to obtain information about table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	V4.2.0	This view is deprecated due to architectural changes. You can query the oceanbase.DBA_OB_TABLEGROUPS or SYS.DBA_OB_TABLEGROUPS view to obtain information about table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	V4.2.0	This view is deprecated due to architectural changes. You can query the oceanbase.CDB_OB_TABLEGROUPS view to obtain information about table groups.
DBA_OB_TABLEGROUP_PARTITIONS	V4.2.0	This view is deprecated due to architectural changes. You can query the oceanbase.DBA_OB_TABLEGROUPS or SYS.DBA_OB_TABLEGROUPS view to obtain information about table groups.
GV$SQL	V4.0.0	This view is deprecated due to architectural changes. You can query the GV$OB_SQL_AUDIT view to obtain information about SQL requests.
V$SQL	V4.0.0	This view is deprecated due to architectural changes. You can query the V$OB_SQL_AUDIT view to obtain information about SQL requests.
GV$UNIT_LOAD_BALANCE_EVENT_HISTORY	V4.0.0	This view is deprecated due to architectural changes. This view has no replacement.
GV$TENANT	V4.0.0	This view is deprecated due to functional changes. You can query the oceanbase.DBA_OB_TENANTS or SYS.DBA_OB_TENANTS view to obtain information about tenants.
GV$DATABASE	V4.0.0	This view is deprecated due to architectural changes. You can query the oceanbase.DBA_OB_DATABASES or SYS.DBA_OB_DATABASES view to obtain information about databases of tenants.
GV$TABLE	V4.0.0	This view is deprecated due to architectural changes. You can query the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view to obtain information about database objects and tables.
GV$UNIT	V4.0.0	This view is deprecated due to functional changes. You can query the oceanbase.DBA_OB_UNITS view and the GV$OB_UNITS view to obtain information about units of OBServer nodes in the cluster.
V$UNIT	V4.0.0	This view is deprecated due to functional changes. You can query the oceanbase.DBA_OB_UNITS view and the V$OB_UNITS view to obtain information about units of OBServer nodes in the cluster.
GV$PARTITION	V4.0.0	This view is deprecated due to functional changes. You can query the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view to obtain information about database objects and tables.
V$PARTITION	V4.0.0	This view is deprecated due to functional changes. You can query the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view to obtain information about database objects and tables.
GV$TENANT_MEMSTORE_ALLOCATOR_INFO	V4.0.0	This view is deprecated due to architectural changes. You can query the GV$OB_MEMSTORE and GV$OB_MEMSTORE_INFO views to obtain information about MemTables.
V$TENANT_MEMSTORE_ALLOCATOR_INFO	V4.0.0	This view is deprecated due to architectural changes. You can query the GV$OB_MEMSTORE and GV$OB_MEMSTORE_INFO views to obtain information about MemTables.
GV$MINOR_MERGE_INFO	V4.0.0	This view is deprecated due to architectural changes. This view has no replacement.
GV$PARTITION_AUDIT	V4.0.0	This view is deprecated due to architectural changes. This view has no replacement.
V$PARTITION_AUDIT	V4.0.0	This view is deprecated due to architectural changes. This view has no replacement.
GV$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because the concept of dirty transactions does not exist in V4.x. This view has no replacement.
V$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because the concept of dirty transactions does not exist in V4.x. This view has no replacement.
V$RESTORE_POINT	V4.0.0	This view is deprecated because the Restore Point feature is not yet supported in V4.x. This view has no replacement.
GV$OUTLINE	V4.0.0	This view is deprecated due to architectural changes. You can query the oceanbase.DBA_OB_OUTLINES or SYS.DBA_OB_OUTLINES view to obtain information about execution plans of the current tenant.
CDB_CKPT_HISTORY	V4.0.0	This view is deprecated due to architectural changes. In V4.x, for minor compactions (which are data dumps), there are no clear start and end times, so you cannot query checkpoint information. For major compactions (which are merges), the sys tenant can query the oceanbase.CDB_OB_MAJOR_COMPACTION view to obtain information about checkpoints of each tenant, and a user tenant can query the oceanbase.DBA_OB_MAJOR_COMPACTION or SYS.DBA_OB_MAJOR_COMPACTION view to obtain information about checkpoints of the current tenant.