Changes in views in OceanBase Database V3.x and V4.x|V4.3.3| docs|Distributed Database

Changes in views in OceanBase Database V3.x and V4.x

Last Updated：2024-12-02 03:48:27 Updated

In OceanBase Database V4.x, internal tables and virtual tables are greatly modified and more views are provided to show system information. In OceanBase Database V4.x, all internal information is displayed in views. Views in different versions are compatible and the information displayed in views is clearer.

For example, the __all_tenant_meta_table view is used in earlier versions to record the location information of each partition. In OceanBase Database V4.x, location information is no longer separately provided for partitions. The location of a partition depends on the location of the log stream to which the partition belongs. You can query the DBA_OB_LS_LOCATIONS view for location information about log streams. The __all_zone view is used in earlier versions to record the major compaction status of clusters. OceanBase Database V4.x stores only the zone and region information of clusters in the __all_zone table in the sys tenant, and stores the major compaction status information in dedicated internal tables. You can query the DBA_OB_MAJOR_COMPACTION view for the overall major compaction status, and query the DBA_OB_ZONE_MAJOR_COMPACTION view for the major compaction status of each zone. In earlier versions, major compactions are performed at the cluster level. In OceanBase Database V4.x, major compactions can be performed at the tenant level. Therefore, you can query the DBA_OB_MAJOR_COMPACTION and DBA_OB_ZONE_MAJOR_COMPACTION views for the major compaction status of tenants.

In OceanBase Database V4.x, the following modifications are made to the existing views based on the view definition specifications:

Unnecessary views are removed.
All view names are prefixed with OB_.
All view names and column names are converted to uppercase letters.
A tenant-level view displays the data of the current tenant in a user tenant, and displays the data of all tenants in the sys tenant.

Mappings between general internal tables and views

Many views are added in OceanBase Database V4.x. The following table describes the mappings between internal tables and views.

Entity/Virtual table	View/SQL statement	Description
__all_collation	information_schema.COLLATIONS	Displays the information about collations for each character set.
__all_tenant	oceanbase.DBA_OB_TENANTS	Displays the basic information of tenants in the `sys` tenant.
gv$tenant (deprecated in OceanBase Database V4.x)	Execute the following statements in a MySQL or Oracle tenant to obtain the information about the current tenant: show tenant; show tenant status; select effective_tenant(); select effective_tenant_id();	Displays the basic information of the current user tenant.
__all_unit_config	oceanbase.DBA_OB_UNIT_CONFIGS	Displays the information about unit configs.
__all_resource_pool	oceanbase.DBA_OB_RESOURCE_POOLS	Displays the information about resource pools.
__all_server	oceanbase.DBA_OB_SERVERS	Displays the information about OBServer nodes.
__all_zone	oceanbase.DBA_OB_ZONES	Displays the information about zones.
__all_rootservice_event_history	oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the RootService event history.
__all_rootservice_job	oceanbase.DBA_OB_UNIT_JOBS oceanbase.DBA_OB_TENANT_JOBS oceanbase.DBA_OB_SERVER_JOBS	Information about RootService jobs is split and recorded in multiple views by type to facilitate structured queries.
__all_virtual_core_all_table	oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream replicas in the current tenant.
gv$database (deprecated in OceanBase Database V4.x) __all_database	oceanbase.CDB_OB_DATABASES oceanbase.DBA_OB_DATABASES information_schema.SCHEMATA SYS.DBA_USERS	Displays the information about databases.
gv$table (deprecated in OceanBase Database V4.x) __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	Displays the information about schemas of all tenants in the `sys` tenant.
	information_schema.DBA_TABLES information_schema.STATISTICS	Displays the information about all tables and indexes in a MySQL tenant.
	SYS.DBA_TABLES SYS.DBA_INDEXES	Displays the information about tables and indexes in an Oracle tenant.
	SYS.DBA_PART_TABLES SYS.DBA_PART_INDEXES	Displays the information about partitioned tables in an Oracle tenant.
	oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES	Displays the information about partitioned tables in a MySQL tenant.
	SYS.DBA_OBJECTS	Displays the information about partitioned tables in an Oracle tenant.
	oceanbase.DBA_OBJECTS	Displays the information about partitioned tables in a MySQL tenant.
	oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES	Displays the information about table groups of tables.
__all_virtual_sys_variable __all_sys_variable	oceanbase.CDB_OB_SYS_VARIABLES	Displays the information about system variables of all tenants in the `sys` tenant.
	Views in a MySQL tenant: information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES Execute the following SQL statements in a MySQL tenant: show variables; show global variables;	Displays the information about system variables in a MySQL tenant.
	Execute the following SQL statements in an Oracle tenant: show variables; show global variables;	Displays the information about system variables in an Oracle tenant.
__tenant_virtual_table_index	information_schema.STATISTICS	Displays the information about indexes in a MySQL tenant.
__tenant_virtual_table_index	SYS.DBA_CONS_COLUMNS	Displays the information about indexes in an Oracle 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	Displays the 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	Displays the information about partitions in an Oracle tenant.
	oceanbase.DBA_TAB_PARTITIONS oceanbase.DBA_TAB_SUBPARTITIONS oceanbase.DBA_IND_PARTITIONS oceanbase.DBA_IND_SUBPARTITIONS oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the information about partitions in a MySQL tenant.
__all_virtual_outline __all_outline	oceanbase.DBA_OB_OUTLINES oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the information about outlines in the `sys` tenant.
__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 the information about locations.
__all_virtual_server_stat __all_virtual_disk_stat	GV$OB_SERVERS	Displays the OBServer node 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 the information about parameters.
__all_virtual_processlist	GV$OB_PROCESSLIST	Displays the information about sessions.
__all_virtual_kvcache_info	GV$OB_KVCACHE	Displays the information about the KV cache.
GV$MEMSTORE (deprecated in OceanBase Database V4.x) __all_virtual_tenant_memstore_info	GV$OB_MEMSTORE	Displays the information about MemStores.
__all_virtual_column	oceanbase.CDB_TAB_COLUMNS oceanbase.CDB_TAB_COLS	Displays the information about columns of all tenants in the `sys` tenant.
	information_schema.COLUMNS	Displays the information about columns.
	oceanbase.DBA_TAB_COLUMNS oceanbase.DBA_TAB_COLS	Displays the information about columns.
	oceanbase.DBA_OB_TABLET_TO_LS oceanbase.CDB_OB_TABLET_TO_LS	Displays the information about all tablets and the log streams to which the tablets belong.
	oceanbase.DBA_OB_TABLET_REPLICAS oceanbase.CDB_OB_TABLET_REPLICAS	Displays the information about all tablet replicas.
__all_virtual_trans_stat	GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	Displays the information about transaction participants on all OBServer nodes.
-	Views: oceanbase.DBA_RECYCLEBIN DBA_RECYCLEBIN SQL statement: show recyclebin;	Displays the information about recycle bins.
__all_zone	oceanbase.CDB_OB_MAJOR_COMPACTION	Displays the overall major compaction status in the `sys` tenant.
__all_zone	oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction status of each zone in the `sys` tenant.

Views renamed in OceanBase Database V4.x

Views are renamed based on the view definition specifications to facilitate your operations. View name differences in different OceanBase Database versions are described as follows:

In versions earlier than OceanBase Database V4.0, names of some self-managed views are not prefixed with OB_*, such as v$plan_cache_stat and v$obrpc_outgoing.
In OceanBase Database V4.0 and later, all view names are prefixed with OB_*, such as V$OB_PLAN_CACHE_STAT and V$OB_RPC_OUTGOING.

The following table lists the views that are renamed in OceanBase Database V4.x.

Original view name	New view name
GV$PLAN_CACHE_STAT	GV$OB_PLAN_CACHE_STAT Note The original view is retained, but we recommend that you do not use it.
GV$PLAN_CACHE_PLAN_STAT	GV$OB_PLAN_CACHE_PLAN_STAT Note The original view is retained, but we recommend that you do not use it.
GV$SQL_AUDIT	GV$OB_SQL_AUDIT
GV$MEMORY	GV$OB_MEMORY
V$MEMORY	V$OB_MEMORY
GV$MEMSTORE	GV$OB_MEMSTORE
V$MEMSTORE	V$OB_MEMSTORE
GV$MEMSTORE_INFO	GV$OB_MEMSTORE_INFO
V$MEMSTORE_INFO	V$OB_MEMSTORE_INFO
V$PLAN_CACHE_STAT	V$OB_PLAN_CACHE_STAT
V$PLAN_CACHE_PLAN_STAT	V$OB_PLAN_CACHE_PLAN_STAT
GV$PLAN_CACHE_PLAN_EXPLAIN	V$OB_PLAN_CACHE_PLAN_STAT
V$PLAN_CACHE_PLAN_EXPLAIN	V$OB_PLAN_CACHE_PLAN_EXPLAIN
V$SQL_AUDIT	V$OB_SQL_AUDIT
GV$OBRPC_OUTGOING	GV$OB_RPC_OUTGOING
V$OBRPC_OUTGOING	V$OB_RPC_OUTGOING
GV$OBRPC_INCOMING	GV$OB_RPC_INCOMMING
V$OBRPC_INCOMING	V$OB_RPC_INCOMMING
GV$OUTLINE	DBA_OB_OUTLINES
GV$CONCURRENT_LIMIT_SQL	DBA_OB_CONCURRENT_LIMIT_SQL
GV$TENANT_SEQUENCE_OBJECT	DBA_OB_SEQUENCE_OBJECTS
GV$TENANT_PX_WORKER_STAT	GV$OB_PX_WORKER_STAT
V$TENANT_PX_WORKER_STAT	V$OB_PX_WORKER_STAT
GV$PS_STAT	GV$OB_PS_STAT
V$PS_STAT	V$OB_PS_STAT
GV$PS_ITEM_INFO	GV$OB_PS_ITEM_INFO
V$PS_ITEM_INFO	V$OB_PS_ITEM_INFO
GV$PLAN_CACHE_REFERENCE_INFO	GV$OB_PLAN_CACHE_REFRENCE_INFO
V$PLAN_CACHE_REFERENCE_INFO	V$OB_PLAN_CACHE_REFRENCE_INFO
GV$SSTABLE	GV$OB_SSTABLES
V$SSTABLE	V$OB_SSTABLES
GV$SERVER_SCHEMA_INFO	GV$OB_SERVER_SCHEMA_INFO
V$SERVER_SCHEMA_INFO	V$OB_SERVER_SCHEMA_INFO
V$ENCRYPTED_TABLES	V$OB_ENCRYPTED_TABLES
GV$TENANT_MEMORY_INFO	GV$OB_TENANT_MEMORY
V$TENANT_MEMORY_INFO	V$OB_TENANT_MEMORY
GV$PX_TARGET_MONITOR	GV$OB_PX_TARGET_MONITOR
V$PX_TARGET_MONITOR	V$OB_PX_TARGET_MONITOR
GV$SQL_AUDIT	GV$OB_SQL_AUDIT
V$SQL_AUDIT	V$OB_SQL_AUDIT
GV$PLAN_CACHE_PLAN_STAT	GV$OB_PLAN_CACHE_PLAN_STAT
V$PLAN_CACHE_PLAN_STAT	V$OB_PLAN_CACHE_PLAN_STAT
GV$PLAN_CACHE_PLAN_EXPLAIN	GV$OB_PLAN_CACHE_PLAN_EXPLAIN
V$PLAN_CACHE_PLAN_EXPLAIN	V$OB_PLAN_CACHE_PLAN_EXPLAIN
GV$MEMORY	GV$OB_MEMORY
V$MEMORY	V$OB_MEMORY
GV$MEMSTORE	GV$OB_MEMSTORE
V$MEMSTORE	V$OB_MEMSTORE
GV$PLAN_CACHE_STAT	GV$OB_PLAN_CACHE_STAT
V$PLAN_CACHE_STAT	GV$OB_PLAN_CACHE_STAT
GV$CONCURRENT_LIMIT_SQL	GV$OB_CONCURRENT_LIMIT_SQL
GV$TENANT_PX_WORKER_STAT	GV$OB_PX_WORKER_STAT
V$TENANT_PX_WORKER_STAT	V$OB_PX_WORKER_STAT
GV$PS_STAT	GV$OB_PS_STAT
V$PS_STAT	V$OB_PS_STAT
GV$PS_ITEM_INFO	GV$OB_PS_ITEM_INFO
V$PS_ITEM_INFO	V$OB_PS_ITEM_INFO
GV$PLAN_CACHE_REFERENCE_INFO	GV$OB_PLAN_CACHE_REFRENCE_INFO
V$PLAN_CACHE_REFERENCE_INFO	V$OB_PLAN_CACHE_REFRENCE_INFO
GV$SSTABLE	GV$OB_SSTABLES
V$SSTABLE	V$OB_SSTABLES
GV$SERVER_SCHEMA_INFO	GV$OB_SERVER_SCHEMA_INFO
V$SERVER_SCHEMA_INFO	V$OB_SERVER_SCHEMA_INFO
V$ENCRYPTED_TABLES	V$OB_ENCRYPTED_TABLES
GV$TENANT_MEMORY_INFO	GV$OB_TENANT_MEMORY
V$TENANT_MEMORY_INFO	V$OB_TENANT_MEMORY
GV$PX_TARGET_MONITOR	GV$OB_PX_TARGET_MONITOR
V$PX_TARGET_MONITOR	V$OB_PX_TARGET_MONITOR
USER_RECYCLEBIN	OCEANBASE.DBA_RECYCLEBIN

Views added in OceanBase Database V4.x

The following table lists the views that are added in OceanBase Database V4.x.

View	Introduced in	Description
information_schema.EVENTS	V4.3.2	Displays the information about all events.
V$OB_COMPATIBILITY_CONTROL	V4.3.2	Displays all features that support product behavior compatibility control based on the released OceanBase Database versions. You can query this view only from the `sys` tenant or a MySQL tenant.
DBA_OB_SPATIAL_COLUMNS	V4.3.2	Displays the database names, table names, data types, and spatial reference system (SRS) information corresponding to spatial index columns. You can query this view only from an Oracle tenant.
PROXY_USERS	V4.3.2	Displays the proxy information of users. You can query this view only from an Oracle tenant.
mysql.columns_priv	V4.3.1	Displays the column privileges granted to a user.
mysql.default_roles	V4.3.1	Displays the roles that are enabled for a user by default.
mysql.procs_priv	V4.3.1	Displays the information about privileges on stored procedures and functions.
mysql.role_edges	V4.3.1	Displays the relationships between roles and users who are granted the roles.
oceanbase.DBA_OB_SYS_VARIABLES DBA_OB_SYS_VARIABLES	V4.3.1	Displays the system variable settings of the current tenant.
GV$OB_NIC_INFO V$OB_NIC_INFO	V4.3.1	Displays the network interface card (NIC) information of OBServer nodes, primarily the NIC speed.
GV$OB_PL_CACHE_OBJECT V$OB_PL_CACHE_OBJECT	V4.3.1	Displays the basic information of cached PL objects on OBServer nodes.
GV$OB_TENANT_RESOURCE_LIMIT V$OB_TENANT_RESOURCE_LIMIT	V4.3.1	Displays the usage, upper limits, and effective conditions of the logical resources on OBServer nodes, as well as the maximum historical usage of the logical resources after a restart upon downtime.
GV$OB_TENANT_RESOURCE_LIMIT_DETAIL V$OB_TENANT_RESOURCE_LIMIT_DETAIL	V4.3.1	Displays the limits on the logical resources of OBServer nodes and the maximum value of each limit.
oceanbase.CDB_INDEX_USAGE oceanbase.DBA_INDEX_USAGE DBA_INDEX_USAGE	V4.3.0	Displays the index usage statistics.
oceanbase.CDB_MVIEW_LOGS oceanbase.DBA_MVIEW_LOGS ALL_MVIEW_LOGS DBA_MVIEW_LOGS USER_MVIEW_LOGS	V4.3.0	Displays the information about materialized view logs.
oceanbase.CDB_MVIEWS oceanbase.DBA_MVIEWS ALL_MVIEWS DBA_MVIEWS USER_MVIEWS	V4.3.0	Displays the 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	Displays the refresh statistics of materialized views.
oceanbase.CDB_MVREF_RUN_STATS oceanbase.DBA_MVREF_RUN_STATS DBA_MVREF_RUN_STATS USER_MVREF_RUN_STATS	V4.3.0	Displays the information about each refresh of the materialized views. Each refresh is identified by a REFRESH_ID value.
oceanbase.CDB_MVREF_STATS oceanbase.DBA_MVREF_STATS DBA_MVREF_STATS USER_MVREF_STATS	V4.3.0	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	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	Displays all default values of the refresh history statistics properties for materialized views in the entire system.
oceanbase.CDB_MVREF_STMT_STATS oceanbase.DBA_MVREF_STMT_STATS DBA_MVREF_STMT_STATS USER_MVREF_STMT_STATS	V4.3.0	Displays the information about materialized view refresh statements.
oceanbase.CDB_OB_AUX_STATISTICS oceanbase.DBA_OB_AUX_STATISTICS DBA_OB_AUX_STATISTICS	V4.3.0	Displays the auxiliary statistics of all tenants.
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	V4.3.0	Displays the list of trusted root certificate authority (CA) certificates of the current OceanBase cluster, as well as the expiration time of the certificates. You can query this view only from the `sys` tenant.
GV$OB_LS_SNAPSHOTS V$OB_LS_SNAPSHOTS	V4.3.0	Displays the information about persisted log stream snapshots in all units.
GV$OB_SESSION V$OB_SESSION	V4.3.0	Displays the information about sessions created on an OBServer node.
USER_USERS	V4.2.1 BP2	Displays the information about the current user.
GV$OB_KV_CONNECTIONS V$OB_KV_CONNECTIONS	V4.2.1_CE_BP1	Displays the statistics on OBKV connections of an OBServer node.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY DBA_OB_IMPORT_TABLE_JOB_HISTORY	V4.2.1	Displays the results of import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS oceanbase.DBA_OB_IMPORT_TABLE_JOBS DBA_OB_IMPORT_TABLE_JOBS	V4.2.1	Displays the information about import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY DBA_OB_IMPORT_TABLE_TASK_HISTORY	V4.2.1	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	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	Displays the results of table-level restore jobs.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS oceanbase.DBA_OB_RECOVER_TABLE_JOBS DBA_OB_RECOVER_TABLE_JOBS	V4.2.1	Displays the information about table-level restore jobs.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS DBA_OB_TRANSFER_PARTITION_TASKS	V4.2.1	Displays the ongoing partition transfer tasks in 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	Displays the historical partition transfer tasks executed in the current tenant.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY DBA_WR_ACTIVE_SESSION_HISTORY	V4.2.1	Displays the persisted Active Session History (ASH) data of the current tenant.
oceanbase.CDB_WR_CONTROL oceanbase.DBA_WR_CONTROL DBA_WR_CONTROL	V4.2.1	Displays Workload Repository (WR) configurations.
oceanbase.CDB_WR_SNAPSHOT oceanbase.DBA_WR_SNAPSHOT DBA_WR_SNAPSHOT	V4.2.1	Displays the snapshots of the current tenant.
oceanbase.CDB_WR_STATNAME oceanbase.DBA_WR_STATNAME DBA_WR_STATNAME	V4.2.1	Displays the names of system statistical items of the current tenant.
oceanbase.CDB_WR_SYSSTAT oceanbase.DBA_WR_SYSSTAT DBA_WR_SYSSTAT	V4.2.1	Displays the details about system statistical items of all tenants.
GV$OB_FLT_TRACE_CONFIG	V4.2.1	Displays the information about end-to-end diagnostics.
GV$OB_TENANT_RUNTIME_INFO V$OB_TENANT_RUNTIME_INFO	V4.2.1	Displays the information about quotas of queues and threads in tenant threads.
DBA_SCHEDULER_JOB_RUN_DETAILS	V4.2.1	Displays all scheduler jobs in the current tenant.
DBMS_LOCK_ALLOCATED	V4.2.1	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	Displays the location range of data dictionaries in the system log stream so that Change Data Capture (CDC) can conveniently consume the data dictionaries.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	V4.2.0	Displays the execution information of historical collection tasks.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	V4.2.0	Displays the collection history of tables.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE oceanbase.DBA_OB_LOG_RESTORE_SOURCE DBA_OB_LOG_RESTORE_SOURCE	V4.2.0	Displays the log restore sources for physically restored tenants and standby tenants.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO DBA_OB_TABLE_STAT_STALE_INFO	V4.2.0	Displays the number of DDL operations performed on each table since the last statistics collection, and whether the current statistics are outdated.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES oceanbase.DBA_OB_EXTERNAL_TABLE_FILES DBA_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the list of files of external tables created in the current tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES ALL_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the list of files of external tables accessible to the current user.
oceanbase.CDB_OB_BALANCE_JOBS oceanbase.DBA_OB_BALANCE_JOBS DBA_OB_BALANCE_JOBS	V4.2.0	Displays the ongoing load balancing jobs of the current tenant.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY oceanbase.DBA_OB_BALANCE_JOB_HISTORY DBA_OB_BALANCE_JOB_HISTORY	V4.2.0	Displays the history of all load balancing jobs executed in the current tenant.
oceanbase.CDB_OB_BALANCE_TASKS oceanbase.DBA_OB_BALANCE_TASKS DBA_OB_BALANCE_TASKS	V4.2.0	Displays the ongoing load balancing tasks of the current tenant.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY oceanbase.DBA_OB_BALANCE_TASK_HISTORY DBA_OB_BALANCE_TASK_HISTORY	V4.2.0	Displays the history of all load balancing tasks executed in the current tenant.
oceanbase.CDB_OB_TRANSFER_TASKS oceanbase.DBA_OB_TRANSFER_TASKS DBA_OB_TRANSFER_TASKS	V4.2.0	Displays the ongoing transfer tasks of the current tenant.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY oceanbase.DBA_OB_TRANSFER_TASK_HISTORY DBA_OB_TRANSFER_TASK_HISTORY	V4.2.0	Displays the history of all transfer tasks executed in the current tenant.
oceanbase.CDB_OB_ACCESS_POINT oceanbase.DBA_OB_ACCESS_POINT DBA_OB_ACCESS_POINT	V4.2.0	Displays the list of OBServer nodes for accessing the current tenant.
oceanbase.DBA_DB_LINKS	V4.2.0	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	Displays the historical log streams of the current tenant.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY oceanbase.DBA_OB_TENANT_EVENT_HISTORY DBA_OB_TENANT_EVENT_HISTORY	V4.2.0	Displays the historical operation records of all tenants in the current cluster. You can query this view only from the `sys` tenant.
GV$OB_THREAD V$OB_THREAD	V4.2.0	Displays the status information of all threads in the observer process.
GV$OB_ARBITRATION_SERVICE_STATUS V$OB_ARBITRATION_SERVICE_STATUS	V4.2.0	Displays the communication status between the cluster and the arbitration service.
GV$OB_ARBITRATION_MEMBER_INFO V$OB_ARBITRATION_MEMBER_INFO	V4.2.0	Displays the information about arbitration members in the current cluster.
GV$OB_OPT_STAT_GATHER_MONITOR V$OB_OPT_STAT_GATHER_MONITOR	V4.2.0	Displays the real-time status of statistics collection tasks.
GV$OB_LOCKS V$OB_LOCKS	V4.2.0	Displays the status of the current user for holding or requesting locks on various tables.
V$OB_LS_LOG_RESTORE_STATUS	V4.2.0	Displays the log restore status at the log stream level.
V$OB_TIMESTAMP_SERVICE	V4.2.0	Displays the GTS/STS values, node information, and clock source type of the clock service of tenants.
GV$OB_PX_P2P_DATAHUB V$OB_PX_P2P_DATAHUB	V4.2.0	Displays the information about data transmission operations that are executed in parallel.
GV$SQL_JOIN_FILTER V$SQL_JOIN_FILTER	V4.2.0	Displays the real-time execution information of join filters.
GV$OB_SQL_PLAN V$OB_SQL_PLAN	V4.2.0	Displays the plan information collected by executing the `EXPLAIN PLAN` statement.
oceanbase.DBA_OB_USER_DEFINED_RULES DBA_OB_USER_DEFINED_RULES	V4.1.0	Displays the rules for customizing 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	Displays the log archiving progress of the current tenant.
oceanbase.DBA_OB_ARBITRATION_SERVICE	V4.1.0	Displays the arbitration service configurations of the current cluster. You can query this view only from the `sys` tenant.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS DBA_OB_LS_ARB_REPLICA_TASKS	V4.1.0	Displays the information about the current tenant and the ongoing arbitration tasks in the current 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	Displays the information about the current tenant and the history of arbitration tasks executed in the current tenant.
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	V4.1.0	Displays cluster-level important events. At present, only events related to cluster upgrade can be displayed. You can query this view only from the `sys` tenant.
oceanbase.DBA_OB_RSRC_IO_DIRECTIVES DBA_OB_RSRC_IO_DIRECTIVES	V4.1.0	Displays the I/O resource configuration in Resource Manager.
V$OB_ARCHIVE_DEST_STATUS	V4.1.0	Displays the status of each log archiving destination at the tenant level.
DBA_OB_TENANTS DBA_OB_TENANTS	V4.1.0	Displays the basic information of tenants.
ALL_POLICIES DBA_POLICIES USER_POLICIES	V4.1.0	Displays the access control strategies that can be created on a table.
ALL_POLICY_GROUPS DBA_POLICY_GROUPS USER_POLICY_GROUPS	V4.1.0	Displays the information about the strategy group that takes effect for different users based on the strategy context.
ALL_POLICY_CONTEXTS DBA_POLICY_CONTEXTS USER_POLICY_CONTEXTS	V4.1.0	Displays the context based on which the corresponding strategy group takes effect.
ALL_SEC_RELEVANT_COLS DBA_SEC_RELEVANT_COLS USER_SEC_RELEVANT_COLS	V4.1.0	Displays the column-level strategies associated with a specified column.
ALL_TRIGGER_ORDERING DBA_TRIGGER_ORDERING USER_TRIGGER_ORDERING	V4.1.0	Sorts all triggers in the current database.
ALL_DB_LINKS	V4.1.0	Displays all DBLinks accessible to the current user.
DBA_DB_LINKS	V4.1.0	Displays all DBLinks created in the current tenant.
USER_DB_LINKS	V4.1.0	Displays the DBLinks created by the current user.
DBA_OB_UNITS GV$OB_UNITS	V4.0.0	Displays the information about the units of tenants.
DBA_OB_UNIT_CONFIGS	V4.0.0	Displays the information about the unit configs of all tenants.
DBA_OB_RESOURCE_POOLS	V4.0.0	Displays the information about the resource pools of all tenants.
DBA_OB_SERVERS	V4.0.0	Displays the information about all OBServer nodes.
DBA_OB_ZONES	V4.0.0	Displays the information about all zones.
DBA_OB_ROOTSERVICE_EVENT_HISTORY	V4.0.0	Displays the RootService event history.
DBA_OB_UNIT_JOBS DBA_OB_TENANT_JOBS DBA_OB_SERVER_JOBS	V4.0.0	Displays the information about RootService jobs.
DBA_OB_LS_LOCATIONS	V4.0.0	Displays the information about locations of log streams in the `sys` tenant.
DBA_OB_DATABASES CDB_OB_DATABASES information_schema.SCHEMATA DBA_USERS	V4.0.0	Displays the database metadata of the current tenant.
CDB_OBJECTS CDB_TABLES CDB_INDEXES CDB_IND_COLUMNS CDB_PART_TABLES CDB_TAB_PARTITIONS	V4.0.0	Displays the information about schemas of all tenants in the `sys` tenant.
information_schema.TABLES information_schema.STATISTICS	V4.0.0	Displays the information about all tables and indexes in the current tenant.
DBA_TABLES DBA_INDEXES	V4.0.0	Displays the information about tables and indexes in the current tenant.
oceanbase.DBA_PART_TABLES DBA_PART_TABLES	V4.0.0	Displays the partitioning information of all partitioned tables accessible to the current user.
oceanbase.DBA_PART_INDEXES DBA_PART_INDEXES	V4.0.0	Displays the information about partitions of all partitioned indexes.
oceanbase.DBA_OBJECTS DBA_OBJECTS	V4.0.0	Displays the status information of indexes in the current tenant.
oceanbase.DBA_OB_TABLEGROUP_TABLES DBA_OB_TABLEGROUP_TABLES	V4.0.0	Displays the associations between table groups and tables.
CDB_OB_SYS_VARIABLES	V4.0.0	Displays the information about system variables of all tenants in the `sys` tenant.
information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES	V4.0.0	Displays the information about system variables of the current tenant.
DBA_CONS_COLUMNS	V4.0.0	Displays the columns that are specified in the constraints on all tables in the database.
CDB_TAB_PARTITIONS CDB_TAB_SUBPARTITIONS CDB_IND_PARTITIONS CDB_IND_SUBPARTITIONS CDB_SUBPARTITION_TEMPLATES	V4.0.0	Displays the information about partitions of all tenants in the `sys` tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	Displays the information about partitions in the current tenant.
DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	V4.0.0	Displays the partition information and partition storage parameters.
DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL	V4.0.0	Displays the information about outlines of 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	Displays the information about major compactions.
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	Displays the information about log streams. You can query the `DBA_OBJECTS` view for the object ID of a table or partition. You can use the object ID as the table ID to query the `DBA_OB_TABLET_TO_LS` and `DBA_OB_LS_LOCATIONS` views for the distribution information.
GV$OB_SERVERS	V4.0.0	Displays the information about all OBServer nodes.
GV$OB_PARAMETERS	V4.0.0	Displays the parameters on all OBServer nodes of the current tenant.
GV$OB_PROCESSLIST	V4.0.0	Displays the information about sessions on all OBServer nodes of the current tenant.
GV$OB_KVCACHE	V4.0.0	Displays the information about the KV cache on each OBServer node.
GV$OB_MEMSTORE	V4.0.0	Displays the memory usage of all MemTables of all tenants on all OBServer nodes.
CDB_TAB_COLUMNS CDB_TAB_COLS	V4.0.0	Displays the information about columns of all tenants in the `sys` tenant.
information_schema.COLUMNS	V4.0.0	Displays the information about columns.
DBA_TAB_COLUMNS DBA_TAB_COLS	V4.0.0	Displays the information about columns.
DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS	V4.0.0	Displays the information about all tablets and the log streams to which the tablets belong.
DBA_OB_TABLET_REPLICAS CDB_OB_TABLET_REPLICAS	V4.0.0	Displays the information about all tablet replicas.
GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	V4.0.0	Displays the information about transaction participants on all OBServer nodes.
DBA_RECYCLEBIN oceanbase.DBA_RECYCLEBIN	V4.0.0	Displays the information about all recycle bins.

Views deprecated in OceanBase Database V4.x

The following table lists the views that are deprecated in OceanBase Database V4.x.

View	Deprecated since	Description
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	V4.2.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.CDB_OB_TABLEGROUPS` view for table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	V4.2.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.DBA_OB_TABLEGROUPS` or `SYS.DBA_OB_TABLEGROUPS` view for table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	V4.2.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.CDB_OB_TABLEGROUPS` view for table groups.
DBA_OB_TABLEGROUP_PARTITIONS	V4.2.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.DBA_OB_TABLEGROUPS` or `SYS.DBA_OB_TABLEGROUPS` view for table groups.
GV$SQL	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `GV$OB_SQL_AUDIT` view for SQL requests.
V$SQL	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `V$OB_SQL_AUDIT` view for SQL requests.
GV$UNIT_LOAD_BALANCE_EVENT_HISTORY	V4.0.0	This view is deprecated due to architecture upgrade. No alternative view is available.
GV$TENANT	V4.0.0	This view is deprecated due to feature upgrade. You can query the `oceanbase.DBA_OB_TENANTS` or `SYS.DBA_OB_TENANTS` for the details about tenants.
GV$DATABASE	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.DBA_OB_DATABASES` or `SYS.DBA_OB_DATABASES` view for the metadata of tenants.
GV$TABLE	V4.0.0	This view is deprecated due to architecture upgrade. 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 for database objects and tables.
GV$UNIT	V4.0.0	This view is deprecated due to feature upgrade. You can query the `oceanbase.DBA_OB_UNITS` and `GV$OB_UNITS` views for the units of OBServer nodes in a cluster.
V$UNIT	V4.0.0	This view is deprecated due to feature upgrade. You can query the `oceanbase.DBA_OB_UNITS` and `V$OB_UNITS` views for the units of OBServer nodes in a cluster.
GV$PARTITION	V4.0.0	This view is deprecated due to feature upgrade. 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 for database objects and tables.
V$PARTITION	V4.0.0	This view is deprecated due to feature upgrade. 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 for database objects and tables.
GV$TENANT_MEMSTORE_ALLOCATOR_INFO	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `GV$OB_MEMSTORE` and `GV$OB_MEMSTORE_INFO` views for MemTables.
V$TENANT_MEMSTORE_ALLOCATOR_INFO	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `GV$OB_MEMSTORE` and `GV$OB_MEMSTORE_INFO` views for MemTables.
GV$MINOR_MERGE_INFO	V4.0.0	This view is deprecated due to architecture upgrade. No alternative view is available.
GV$PARTITION_AUDIT	V4.0.0	This view is deprecated due to architecture upgrade. No alternative view is available.
V$PARTITION_AUDIT	V4.0.0	This view is deprecated due to architecture upgrade. No alternative view is available.
GV$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because OceanBase Database V4.x does not support the concept of dirty transaction. No alternative view is available.
V$OB_TRANS_TABLE_STATUS	V4.0.0	This view is deprecated because OceanBase Database V4.x does not support the concept of dirty transaction. No alternative view is available.
V$RESTORE_POINT	V4.0.0	This view is deprecated because OceanBase Database V4.x does not support restore points. No alternative view is available.
GV$OUTLINE	V4.0.0	This view is deprecated due to architecture upgrade. You can query the `oceanbase.DBA_OB_OUTLINES` or `SYS.DBA_OB_OUTLINES` view for the execution plan outlines of tenants.
CDB_CKPT_HISTORY	V4.0.0	This view is deprecated due to architecture upgrade. In OceanBase Database V4.x, you cannot query the checkpoint information of minor compactions because their start time and end time are not specified. However, you can query the checkpoint information of major compactions. For example, you can query the `oceanbase.CDB_OB_MAJOR_COMPACTION` view in the `sys` tenant for the checkpoint information of all tenants, or query the `oceanbase.DBA_OB_MAJOR_COMPACTION` or `SYS.DBA_OB_MAJOR_COMPACTION` view in a user tenant for its checkpoint information.