View changes between V3.x and V4.x|V4.4.2| docs|Distributed Database

View changes between V3.x and V4.x

Last Updated：2026-03-06 07:02:40 Updated

In OceanBase Database V4.x, we have made many improvements to internal tables and virtual tables, and provided many views to display system information. The biggest change in V4.x is that internal information queries are fully switched to views. The unified and well-defined views are compatible across versions, and the information is clearer.

For example, the __all_tenant_meta_table view, which was commonly used to record the location information of each partition, is no longer needed in V4.x. In V4.x, partitions no longer have independent location information. Instead, they belong to a log stream, and their location information is determined by the location of the log stream. You can query the DBA_OB_LS_LOCATIONS view to view the location information of log streams. The __all_zone view, which was used to view the compaction status of a cluster, is also changed in V4.x. In V4.x, the system tenant stores only the zone and region information of the cluster in the __all_zone table. The compaction status is stored in dedicated internal tables. You can query the DBA_OB_MAJOR_COMPACTION view to view the overall compaction status and the DBA_OB_ZONE_MAJOR_COMPACTION view to view the compaction status of each zone. Notably, in V4.x, each tenant independently performs compaction. Therefore, each tenant can query the DBA_OB_MAJOR_COMPACTION and DBA_OB_ZONE_MAJOR_COMPACTION views to view the compaction status of its own tenant.

In addition, in V4.x, we have made some improvements to existing internal views based on the view definition specifications. The improvements include:

Removing unnecessary views.
Adding the OB_ prefix to the names of all views.
Converting the names of all views and columns to uppercase.
For tenant-level views, the user tenant can view only its own data, while the system tenant can view data of all tenants.

Mapping between internal tables and views

OceanBase Database V4.x provides a large number of views. You can query the required information by using the mapping between internal tables and views.

Entity table / Virtual table	View / Command	Description
__all_collation	information_schema.COLLATIONS	Displays comparison methods for each character set.
__all_tenant	oceanbase.DBA_OB_TENANTS	Displays tenant basic information.
gv$tenant (V4.x obsolete)	To obtain tenant information 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();	Displays user tenant query tenant basic information.
__all_unit_config	oceanbase.DBA_OB_UNIT_CONFIGS	Displays Unit Config information.
__all_resource_pool	oceanbase.DBA_OB_RESOURCE_POOLS	Displays Resource Pool information.
__all_server	oceanbase.DBA_OB_SERVERS	Displays Server information.
__all_zone	oceanbase.DBA_OB_ZONES	Displays Zone information.
__all_rootservice_event_history	oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of a Root Service.
__all_rootservice_job	oceanbase.DBA_OB_UNIT_JOBS oceanbase.DBA_OB_TENANT_JOBS oceanbase.DBA_OB_SERVER_JOBS	Splits RootService Job information into multiple views and distinguishes them by display type for convenient structured query.
__all_virtual_core_all_table	oceanbase.DBA_OB_LS_LOCATIONS	Displays the replica distribution information of the log stream (LS) of the current tenant.
gv$database(V4.x obsolete) __all_database	oceanbase.CDB_OB_DATABASES oceanbase.DBA_OB_DATABASES information_schema.SCHEMATA oceanbase.DBA_USERS	Database information.
gv$table(V4.x obsolete) __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	Queries schema information of all tenants in the sys tenant.
	information_schema.TABLES information_schema.STATISTICS	Queries table and index information in a MySQL-compatible tenant.
	SYS.DBA_TABLES SYS.DBA_INDEXES	Queries table and index information in an Oracle-compatible tenant.
	SYS.DBA_PART_TABLES SYS.DBA_PART_INDEXES	Queries partitioned table information in an Oracle-compatible tenant.
	oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES	Queries partitioned table information in a MySQL-compatible tenant.
	SYS.DBA_OBJECTS	Queries partitioned table information in an Oracle-compatible tenant.
	oceanbase.DBA_OBJECTS	Queries partitioned table information in a MySQL-compatible tenant.
	oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES	Displays the Tablegroup information of tables.
__all_virtual_sys_variable __all_sys_variable	oceanbase.CDB_OB_SYS_VARIABLES	Queries system variable information of all tenants in the sys tenant.
	MySQL-compatible tenant views: information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES MySQL-compatible tenant commands: show variables; show global variables;	Queries system variable information in a MySQL-compatible tenant.
	Oracle-compatible tenant commands: show variables; show global variables;	Queries 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 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 parameters.
__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 recyclebin.
__all_zone	oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the overall major compaction status.
__all_zone	oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction status of each zone.

Views renamed in V4.x

The view name changes are mainly to standardize the view content and make it easier for you to perform related operations. The view name changes between 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 were 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 it 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 it 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

New views in V4.x

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

View	Version	Description
V$OB_SS_SSTABLES	V4.4.0	This view displays information about SSTables on shared storage.
GV$OB_TABLET_LOCAL_CACHE V$OB_TABLET_LOCAL_CACHE	V4.4.0/V4.3.5 BP2	This view displays the cache information of a tablet.
GV$OB_STORAGE_CACHE_TASKS V$OB_STORAGE_CACHE_TASKS	V4.4.0/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.4.0/V4.3.5 1 BP1	This view displays the progress of converting a tablet in a 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 relevant metrics of various cache 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 IO operations of an object storage service and a cloud disk 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 IO access resource information on 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 all event information.
V$OB_COMPATIBILITY_CONTROL	V4.3.2	Only the sys tenant and MySQL-compatible tenants can access this view. This view displays the features that can be controlled for product behavior compatibility with the OceanBase Database release version.
DBA_OB_SPATIAL_COLUMNS	V4.3.2	Only the Oracle-compatible tenant can access this view. This view displays the database name, table name, type, and SRS information of a spatial index column.
PROXY_USERS	V4.3.2	Only the Oracle-compatible tenant can access this view. This view 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 enabled for 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 system variable configurations 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 cache objects in a server.
GV$OB_TENANT_RESOURCE_LIMIT V$OB_TENANT_RESOURCE_LIMIT	V4.3.1	This view displays the logical resource usage, upper limit, effective restriction conditions, and maximum increase 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 restrictions on logical resources on an OBServer node and the upper limits of each restriction.
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 materialized view log information.
oceanbase.CDB_MVIEWS oceanbase.DBA_MVIEWS ALL_MVIEWS DBA_MVIEWS USER_MVIEWS	V4.3.0	This view displays the materialized view information.
oceanbase.CDB_MVREF_CHANGE_STATS oceanbase.DBA_MVREF_CHANGE_STATS DBA_MVREF_CHANGE_STATS USER_MVREF_CHANGE_STATS	V4.3.0	This view displays the statistics related to 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 the information about each run of a materialized view refresh, identified by a REFRESH_ID.
oceanbase.CDB_MVREF_STATS oceanbase.DBA_MVREF_STATS DBA_MVREF_STATS USER_MVREF_STATS	V4.3.0	This view displays the basic timing statistics of 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 the refresh statistics properties associated with 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 the system-wide default values of the statistics properties of the history of materialized view refreshes.
oceanbase.CDB_MVREF_STMT_STATS oceanbase.DBA_MVREF_STMT_STATS DBA_MVREF_STMT_STATS USER_MVREF_STMT_STATS	V4.3.0	This view describes the information associated with the refresh statement.
oceanbase.CDB_OB_AUX_STATISTICS oceanbase.DBA_OB_AUX_STATISTICS DBA_OB_AUX_STATISTICS	V4.3.0	This view displays the auxiliary statistics of all tenants.
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	V4.3.0	This view displays the list of CA root certificates trusted by the OBServer cluster and the expiration time of each certificate. Only the sys tenant can access this view.
GV$OB_LS_SNAPSHOTS V$OB_LS_SNAPSHOTS	V4.3.0	This view displays the information about the log stream snapshots stored in the persistent storage of a unit.
GV$OB_SESSION V$OB_SESSION	V4.3.0	This view records the information about the sessions created in the server.
USER_USERS	V4.2.1 BP2	This view displays the information about the current user.
GV$OB_KV_CONNECTIONS V$OB_KV_CONNECTIONS	V4.2.1_CE_BP1	This view displays the statistics about the OBKV connections held by 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 the 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 the 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 restore tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS oceanbase.DBA_OB_RECOVER_TABLE_JOBS DBA_OB_RECOVER_TABLE_JOBS	V4.2.1	This view displays the information about table-level restore 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 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 partition transfer tasks executed by tenants.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY DBA_WR_ACTIVE_SESSION_HISTORY	V4.2.1	This view displays the ASH data after it is persisted.
oceanbase.CDB_WR_CONTROL oceanbase.DBA_WR_CONTROL DBA_WR_CONTROL	V4.2.1	This view displays the WR-related configurations.
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 the end-to-end 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 location range of the data dictionary in the system log stream to facilitate data dictionary consumption 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.
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 tenant and standby tenant.
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 accessible by the current user.
oceanbase.CDB_OB_BALANCE_JOBS oceanbase.DBA_OB_BALANCE_JOBS DBA_OB_BALANCE_JOBS	V4.2.0	This view displays the load balancing jobs 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 all load balancing jobs 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 currently being executed by the 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 all 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 currently being executed in the 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 all 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 for the tenant entry points.
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 log streams that have existed in the tenant's history.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY oceanbase.DBA_OB_TENANT_EVENT_HISTORY DBA_OB_TENANT_EVENT_HISTORY	V4.2.0	Only the sys tenant can access this view, which displays the historical operation records of all tenants in the cluster.
GV$OB_THREAD V$OB_THREAD	V4.2.0	This view displays the status information 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 arbitration service.
GV$OB_ARBITRATION_MEMBER_INFO V$OB_ARBITRATION_MEMBER_INFO	V4.2.0	This view displays the arbitration member information of the 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 lock status of tables 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 of the tenant clock service, the node information of the clock service, and the clock source type.
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 user through the EXPLAIN PLAN tool.
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	Only the sys tenant can access this view, which displays the arbitration service configuration information of the current cluster.
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 currently running in the current tenant and corresponding user tenants.
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 in the tenant and corresponding user tenants.
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	V4.1.0	Only the sys tenant can access this view, which displays important events at the cluster level. Currently, only cluster upgrade events are supported.
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 archive destinations at the tenant level.
DBA_OB_TENANTS DBA_OB_TENANTS	V4.1.0	This view displays the basic information of a tenant.
ALL_POLICIES DBA_POLICIES USER_POLICIES	V4.1.0	This view displays the multiple policies that can be created on a table for access control.
ALL_POLICY_GROUPS DBA_POLICY_GROUPS USER_POLICY_GROUPS	V4.1.0	This view displays the information of policy groups. The policies in different policy groups take effect on different users.
ALL_POLICY_CONTEXTS DBA_POLICY_CONTEXTS USER_POLICY_CONTEXTS	V4.1.0	This view displays the strategy groups that take effect based on the values of the context when you access 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 you access this column, the corresponding policy takes effect.
ALL_TRIGGER_ORDERING DBA_TRIGGER_ORDERING USER_TRIGGER_ORDERING	V4.1.0	This view displays the order of all triggers in the current database.
ALL_DB_LINKS	V4.1.0	This view displays all DBLINKs that the current user can access.
DBA_DB_LINKS	V4.1.0	This view displays all DBLINKs created in the current tenant.
USER_DB_LINKS	V4.1.0	This view displays all DBLINKs created by the current user.
DBA_OB_UNITS GV$OB_UNITS	V4.0.0	This view displays the Unit information of a 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 event history of the Root Service.
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 locations of RS in the system tenant.
DBA_OB_DATABASES CDB_OB_DATABASES information_schema.SCHEMATA DBA_USERS	V4.0.0	This view displays the database metadata of a 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 in the system tenant.
information_schema.TABLES information_schema.STATISTICS	V4.0.0	This view displays the information of all tables and indexes in a tenant.
DBA_TABLES DBA_INDEXES	V4.0.0	This view displays the information of tables and indexes in a tenant.
oceanbase.DBA_PART_TABLES DBA_PART_TABLES	V4.0.0	This view displays the partition information of all partitioned tables that the current user can access.
oceanbase.DBA_PART_INDEXES DBA_PART_INDEXES	V4.0.0	This view displays the partition information of all partitioned indexes.
oceanbase.DBA_OBJECTS DBA_OBJECTS	V4.0.0	This view displays the index status of a 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 variable information of all tenants in the system tenant.
information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES	V4.0.0	This view displays system variable information for the current tenant.
DBA_CONS_COLUMNS	V4.0.0	This view displays column information in constraints of all tables.
CDB_TAB_PARTITIONS CDB_TAB_SUBPARTITIONS CDB_IND_PARTITIONS CDB_IND_SUBPARTITIONS CDB_SUBPARTITION_TEMPLATES	V4.0.0	This view displays partition information for all tenants in the sys tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	This view displays partition information for the current tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	This view displays partition information, partition storage parameters, and other related information.
DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL	V4.0.0	This view displays outline information for the current 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 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 log stream information. You can obtain the data_object_id of a table or partition from the DBA_OBJECTS view. You can use the data_object_id as the tablet_id to query the DBA_OB_TABLET_TO_LS and DBA_OB_LS_LOCATIONS views to obtain the distribution information.
GV$OB_SERVERS	V4.0.0	This view displays information about all OBServer nodes.
GV$OB_PARAMETERS	V4.0.0	This view displays configuration information on all OBServer nodes where the current tenant is located.
GV$OB_PROCESSLIST	V4.0.0	This view displays session information on all OBServer nodes where the current tenant is located.
GV$OB_KVCACHE	V4.0.0	This view displays KVCACHE information on each OBServer node.
GV$OB_MEMSTORE	V4.0.0	This view displays the memory usage of MemTables for all tenants on all servers.
CDB_TAB_COLS	V4.0.0	This view displays information of all tenants in the sys tenant.
information_schema.COLUMNS	V4.0.0	This view displays column information.
DBA_TAB_COLUMNS DBA_TAB_COLS	V4.0.0	This view displays 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 of transaction participants on all servers.
DBA_RECYCLEBIN oceanbase.DBA_RECYCLEBIN	V4.0.0	This view displays information about all 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 schema 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 schema 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 schema 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 schema 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 schema 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 schema 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 schema changes. There is no replacement view.
GV$TENANT	V4.0.0	This view is deprecated due to feature 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 schema changes. You can query the oceanbase.DBA_OB_DATABASES or SYS.DBA_OB_DATABASES view to obtain database metadata of tenants.
GV$TABLE	V4.0.0	This view is deprecated due to schema 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 feature changes. You can query the oceanbase.DBA_OB_UNITS view and the GV$OB_UNITS view to obtain information about units on OBServer nodes in the cluster.
V$UNIT	V4.0.0	This view is deprecated due to feature changes. You can query the oceanbase.DBA_OB_UNITS view and the V$OB_UNITS view to obtain information about units on OBServer nodes in the cluster.
GV$PARTITION	V4.0.0	This view is deprecated due to feature 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 feature 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 schema 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 schema 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 schema changes. There is no replacement view.
GV$PARTITION_AUDIT	V4.0.0	This view is deprecated due to schema changes. There is no replacement view.
V$PARTITION_AUDIT	V4.0.0	This view is deprecated due to schema changes. There is no replacement view.
GV$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because the concept of dirty transactions does not exist in V4.x. There is no replacement view.
V$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because the concept of dirty transactions does not exist in V4.x. There is no replacement view.
V$RESTORE_POINT	V4.0.0	This view is deprecated because the Restore Point feature is not supported in V4.x. There is no replacement view.
GV$OUTLINE	V4.0.0	This view is deprecated due to schema 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 schema changes. In V4.x, for Mini Compaction (dump), there are no clear start and end times, so you cannot query Checkpoint information. For Major Compaction (merge), the sys tenant can query the oceanbase.CDB_OB_MAJOR_COMPACTION view to obtain Checkpoint information of each tenant, and the user tenant can query the oceanbase.DBA_OB_MAJOR_COMPACTION or SYS.DBA_OB_MAJOR_COMPACTION view to obtain Checkpoint information of the current tenant.