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

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

Last Updated：2024-06-28 05:30:29 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 queried 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 collation for each character set.
__all_tenant	DBA_OB_TENANTS	Displays the basic information about tenants.
gv$tenant (deprecated in OceanBase Database V4.x)	Execute the following statements in a MySQL or Oracle tenant to obtain information of the current tenant: show tenant show tenant status select effective_tenant() select effective_tenant_id()	Displays the basic information about the queried user tenant.
__all_unit_config	DBA_OB_UNIT_CONFIGS	Displays information about unit configs.
__all_resource_pool	DBA_OB_RESOURCE_POOL	Displays information about resource pools.
__all_server	DBA_OB_SERVERS	Displays information about OBServer nodes.
__all_zone	DBA_OB_ZONES	Displays information about zones.
__all_rootservice_event_history	DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the RootService event history.
__all_rootservice_job	DBA_OB_UNIT_JOBS DBA_OB_TENANT_JOBS 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	DBA_OB_LS_LOCATIONS	Displays the distribution of the log stream (LS) replicas in the current tenant.
gv$database (deprecated in OceanBase Database V4.x) __all_database	CDB_OB_DATABASES DBA_OB_DATABASES information_schema.SCHEMATA SYS.DBA_USERS	Displays database information.
gv$table (deprecated in OceanBase Database V4.x) __all_table __all_virtual_table	CDB_OBJECTS CDB_TABLES CDB_INDEXES CDB_IND_COLUMNS CDB_PART_TABLES CDB_TAB_PARTITIONS	Displays information about schemas of all tenants in the `sys` tenant.
	information_schema.tables information_schema.statistics	Displays information about all tables and indexes in a MySQL tenant.
	SYS.DBA_TABLES SYS.DBA_INDEXES	Displays information about tables and indexes in an Oracle tenant.
	SYS.DBA_PART_TABLES SYS.DBA_PART_INDEXES	Displays information about partitioned tables in an Oracle tenant.
	oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES	Displays information about partitioned tables in a MySQL tenant.
	SYS.DBA_OBJECTS	Displays information about partitioned tables in an Oracle tenant.
	oceanbase.DBA_OBJECTS	Displays information about partitioned tables in a MySQL tenant.
	oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES	Displays information about table groups of tables.
__all_virtual_sys_variable __all_sys_variable	CDB_OB_SYS_VARIABLES	Displays 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 information about system variables in a MySQL tenant.
	Execute the following SQL statements in an Oracle tenant: show variables show global variables	Displays information about system variables in an Oracle tenant.
__tenant_virtual_table_index	information_schema.STATISTICS	Displays information about indexes in a MySQL tenant.
__tenant_virtual_table_index	SYS.DBA_CONS_COLUMNS	Displays information about indexes in an Oracle tenant.
__all_part __all_virtual_part __all_def_sub_part __all_virtual_def_sub_part	CDB_TAB_PARTITIONS CDB_TAB_SUBPARTITIONS CDB_IND_PARTITIONS CDB_IND_SUBPARTITIONS CDB_SUBPARTITION_TEMPLATES	Displays 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 information about partitions in an Oracle tenant.
	DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES	Displays information about partitions in a MySQL tenant.
__all_virtual_outline __all_outline	DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL	Displays information about outlines.
__all_root_table __all_meta_table __all_tenant_meta_table __all_virtual_tenant_meta_table	DBA_OB_LS_LOCATIONS CDB_OB_LS_LOCATIONS DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS DBA_OBJECTS CDB_OBJECTS	Displays information about locations.
__all_virtual_server_stat __all_virtual_disk_stat	GV$OB_SERVERS	Displays 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 parameters.
__all_virtual_processlist	GV$OB_PROCESSLIST	Displays information about sessions.
__all_virtual_kvcache_info	GV$OB_KVCACHE	Displays information about KVCache.
GV$MEMSTORE (deprecated in OceanBase Database V4.x) __all_virtual_tenant_memstore_info	GV$OB_MEMSTORE	Displays information about MemStores.
__all_virtual_column	CDB_TAB_COLUMNS CDB_TAB_COLS	Displays information about columns of all tenants in the `sys` tenant.
	information_schema.COLUMNS	Displays information about columns.
	SYS.DBA_TAB_COLUMNS SYS.DBA_TAB_COLS	Displays information about columns.
	DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS	Displays information about tablets and the log streams to which the tablets belong.
	DBA_OB_TABLET_REPLICAS CDB_OB_TABLET_REPLICAS	Displays information about all tablet replicas.
__all_virtual_trans_stat	GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	Displays information about transaction participants on all OBServer node.
-	Views: oceanbase.DBA_RECYCLEBIN SYS.DBA_RECYCLEBIN SQL statement: show recyclebin	Displays information about the recycle bin.
__all_zone	DBA_OB_MAJOR_COMPACTION	Displays the overall major compaction status.
__all_zone	DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction status of each zone.

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$ACTIVE_SESSION_HISTORY	GV$OB_ACTIVE_SESSION_HISTORY, with the original view retained
V$ACTIVE_SESSION_HISTORY	V$OB_ACTIVE_SESSION_HISTORY, with the original view retained
gv$plan_cache_stat	GV$OB_PLAN_CACHE_STAT
gv$plan_cache_plan_stat	GV$OB_PLAN_CACHE_PLAN_STAT
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
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG oceanbase.CDB_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	V4.2.0	Displays the execution information about historical collection tasks.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	V4.2.0	Displays the collection history of a table.
oceanbase.CDB_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	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.DBA_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the file lists of all external tables created in the current tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the list of external files of external tables accessible to the current user.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the file lists of external tables created in all tenants.
oceanbase.DBA_OB_BALANCE_JOBS	V4.2.0	Displays the ongoing load balancing jobs in the current tenant.
oceanbase.CDB_OB_BALANCE_JOBS	V4.2.0	Displays the ongoing load balancing jobs in all tenants.
oceanbase.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_JOB_HISTORY	V4.2.0	Displays the history of load balancing jobs executed in all tenants.
oceanbase.DBA_OB_BALANCE_TASKS	V4.2.0	Displays the ongoing load balancing jobs in the current tenant.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY	V4.2.0	Displays the history of all load balancing jobs executed in the current tenant.
oceanbase.CDB_OB_BALANCE_TASKS	V4.2.0	Displays the ongoing load balancing jobs in all tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY	V4.2.0	Displays the history of load balancing jobs executed in all tenants.
oceanbase.DBA_OB_TRANSFER_TASKS	V4.2.0	Displays the ongoing transfer tasks in the current tenant.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY	V4.2.0	Displays the history of all transfer tasks executed in the current tenant.
oceanbase.CDB_OB_TRANSFER_TASKS	V4.2.0	Displays the ongoing transfer tasks in all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY	V4.2.0	Displays the history of transfer tasks executed in all tenants.
oceanbase.CDB_OB_ACCESS_POINT	V4.2.0	Displays the list of OBServer nodes for accessing the current tenant.
oceanbase.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	V4.2.0	Displays the historical log streams of all tenants. You can query this view only from the `sys` tenant.
oceanbase.DBA_OB_LS_HISTORY	V4.2.0	Displays the historical log streams of the current tenant.
oceanbase.CDB_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.
oceanbase.DBA_OB_TENANT_EVENT_HISTORY	V4.2.0	Displays the historical operation records of the current tenant.
DBA_OB_DATA_DICTIONARY_IN_LOG	V4.2.0	Displays the location range of data dictionaries in the system log stream so that CDC can conveniently consume the data dictionaries.
DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	V4.2.0	Displays the execution information about historical collection tasks.
DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	V4.2.0	Displays the collection history of a table.
DBA_OB_LOG_RESTORE_SOURCE	V4.2.0	Displays the log restore sources for physically restored tenants and standby tenants.
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.
DBA_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the file lists of all external tables created in the current tenant.
ALL_OB_EXTERNAL_TABLE_FILES	V4.2.0	Displays the list of external files of external tables accessible to the current user.
DBA_OB_BALANCE_JOBS	V4.2.0	Displays the ongoing load balancing jobs in the current tenant.
DBA_OB_BALANCE_JOB_HISTORY	V4.2.0	Displays the history of all load balancing jobs executed in the current tenant.
DBA_OB_BALANCE_TASKS	V4.2.0	Displays the ongoing load balancing jobs in the current tenant.
DBA_OB_BALANCE_TASK_HISTORY	V4.2.0	Displays the history of all load balancing jobs executed in the current tenant.
DBA_OB_TRANSFER_TASKS	V4.2.0	Displays the ongoing transfer tasks in the current tenant.
DBA_OB_TRANSFER_TASK_HISTORY	V4.2.0	Displays the history of all transfer tasks executed in the current tenant.
DBA_OB_ACCESS_POINT	V4.2.0	Displays the list of OBServer nodes for accessing the current tenant.
DBA_OB_LS_HISTORY	V4.2.0	Displays the historical log streams of the current tenant.
DBA_OB_TENANT_EVENT_HISTORY	V4.2.0	Displays the historical operation records of the current tenant.
GV$OB_THREAD V$OB_THREAD	V4.2.0	Displays the status information about 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 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 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 about 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	V4.1.0	Displays the rules for customizing SQL statements.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS	V4.1.0	Displays the log archiving progress of all tenants. You can query this view only from the `sys` tenant.
oceanbase.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	V4.1.0	Displays information about the current tenant and the ongoing arbitration tasks in the current tenant. You can query this view only from the `sys` tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS	V4.1.0	Displays information about the current tenant and the ongoing arbitration tasks in the current tenant.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY	V4.1.0	Displays information about the current tenant and the history of arbitration tasks executed in the current tenant. You can query this view only from the `sys` tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	V4.1.0	Displays 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	V4.1.0	Displays the configuration of I/O resources in the resource manager.
V$OB_ARCHIVE_DEST_STATUS	V4.1.0	Displays the status of each log archiving destination at the tenant level.
DBA_OB_USER_DEFINED_RULES	V4.1.0	Displays the rules for customizing SQL statements.
DBA_OB_TENANTS	V4.1.0	Displays basic information about tenants.
DBA_OB_LS_LOG_ARCHIVE_PROGRESS	V4.1.0	Displays the log archiving progress of the current tenant.
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 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.
DBA_OB_LS_ARB_REPLICA_TASKS	V4.1.0	Displays information about the current tenant and the ongoing arbitration tasks in the current tenant.
DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	V4.1.0	Displays information about the current tenant and the history of arbitration tasks executed in the current tenant.
ALL_TRIGGER_ORDERING DBA_TRIGGER_ORDERING USER_TRIGGER_ORDERING	V4.1.0	Sorts all triggers in the current database.
DBA_OB_RSRC_IO_DIRECTIVES	V4.1.0	Displays the configuration of I/O resources in the resource manager.
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_TENANTS	V4.0.0	Displays basic information about tenants.
DBA_OB_UNITS GV$OB_UNITS	V4.0.0	Displays information about the units of tenants.
DBA_OB_UNIT_CONFIGS	V4.0.0	Displays information about the unit configs of all tenants.
DBA_OB_RESOURCE_POOL	V4.0.0	Displays information about resource pools of all tenants.
DBA_OB_SERVERS	V4.0.0	Displays information about all OBServer nodes.
DBA_OB_ZONES	V4.0.0	Displays 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 information about RootService jobs.
DBA_OB_LS_LOCATIONS	V4.0.0	Displays 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 tenants.
CDB_OBJECTS CDB_TABLES CDB_INDEXES CDB_IND_COLUMNS CDB_PART_TABLES CDB_TAB_PARTITIONS	V4.0.0	Displays information about schemas of all tenants in the `sys` tenant.
information_schema.tables information_schema.statistics	V4.0.0	Displays information about all tables and indexes in the current tenant.
SYS.DBA_TABLES SYS.DBA_INDEXES	V4.0.0	Displays information about tables and indexes in the current tenant.
SYS.DBA_PART_INDEXES SYS.DBA_PART_TABLES	V4.0.0	Displays information about partitioned tables in the current tenant.
oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES	V4.0.0	Displays information about partitioned tables in the current tenant.
SYS.DBA_OBJECTS	V4.0.0	Displays status information about indexes in the current tenant.
oceanbase.DBA_OBJECTS	V4.0.0	Displays status information about indexes in the current tenant.
oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES	V4.0.0	Displays associations between table groups and tables.
CDB_OB_SYS_VARIABLES	V4.0.0	Displays information about system variables of all tenants in the `sys` tenant.
information_schema.SESSION_VARIABLES information_schema.GLOBAL_VARIABLES	V4.0.0	Displays information about system variables of the current tenant.
SYS.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 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	V4.0.0	Displays 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 partition information and partition storage parameters.
DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL	V4.0.0	Displays 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 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 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 information about all OBServer nodes.
GV$OB_PARAMETERS	V4.0.0	Displays the parameters on all OBServer nodes of tenants.
GV$OB_PROCESSLIST	V4.0.0	Displays the session information about all OBServer nodes of tenants.
GV$OB_KVCACHE	V4.0.0	Displays 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 information about columns of all tenants in the `sys` tenant.
information_schema.COLUMNS	V4.0.0	Displays information about columns.
SYS.DBA_TAB_COLUMNS SYS.DBA_TAB_COLS	V4.0.0	Displays information about columns.
DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS	V4.0.0	Displays the list of all tablets and the log streams to which the tablets belong.
DBA_OB_TABLET_REPLICAS CDB_OB_TABLET_REPLICAS	V4.0.0	Displays information about all tablet replicas.
GV$OB_TRANSACTION_PARTICIPANTS V$OB_TRANSACTION_PARTICIPANTS	V4.0.0	Displays information about transaction participants on all OBServer nodes.
SYS.DBA_RECYCLEBIN oceanbase.DBA_RECYCLEBIN	V4.0.0	Displays 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.

Original view name	Description
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	This view is deprecated since OceanBase Database V4.2.0.
DBA_OB_TABLEGROUP_SUBPARTITIONS	This view is deprecated since OceanBase Database V4.2.0.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	This view is deprecated since OceanBase Database V4.2.0.
DBA_OB_TABLEGROUP_PARTITIONS	This view is deprecated since OceanBase Database V4.2.0.
gv$sql	This view is deprecated since OceanBase Database V4.0.0.
v$sql	This view is deprecated since OceanBase Database V4.0.0.
gv$server_memstore	The content of this view is duplicate with that of the `GV$OB_MEMSTORE` view. This view is deprecated since OceanBase Database V4.0.0.
gv$unit_load_balance_event_history	This view is deprecated since OceanBase Database V4.0.0.
gv$tenant	This view is deprecated since OceanBase Database V4.0.0.
gv$database	This view is deprecated since OceanBase Database V4.0.0.
gv$table	This view is deprecated since OceanBase Database V4.0.0.
gv$unit	This view is deprecated since OceanBase Database V4.0.0.
v$unit	This view is deprecated since OceanBase Database V4.0.0.
gv$partition	This view is deprecated since OceanBase Database V4.0.0.
v$partition	This view is deprecated since OceanBase Database V4.0.0.
gv$tenant_memstore_allocator_info	The information in this view is not displayed. This view is deprecated since OceanBase Database V4.0.0.
v$tenant_memstore_allocator_info	The information in this view is not displayed. This view is deprecated since OceanBase Database V4.0.0.
gv$minor_merge_info	This view is deprecated since OceanBase Database V4.0.0.
gv$partition_audit	This view is deprecated since OceanBase Database V4.0.0.
v$partition_audit	This view is deprecated since OceanBase Database V4.0.0.
gv$ob_trans_table_status	This view is deprecated since OceanBase Database V4.0.0.
v$ob_trans_table_status	This view is deprecated since OceanBase Database V4.0.0.
gv$merge_info	This view is deprecated since OceanBase Database V4.0.0.
v$merge_info	This view is deprecated since OceanBase Database V4.0.0.
v$restore_point	This view is deprecated since OceanBase Database V4.0.0. Features corresponding to this view are not supported in OceanBase Database V4.x.
GV$OUTLINE	This view is deprecated since OceanBase Database V4.0.0.
GV$MEMSTORE_INFO	This view is deprecated since OceanBase Database V4.0.0.
V$MEMSTORE_INFO	This view is deprecated since OceanBase Database V4.0.0.
GV$SERVER_MEMSTORE	This view is deprecated since OceanBase Database V4.0.0.
GV$TENANT_MEMSTORE_ALLOCATOR_INFO	The information in this view is not displayed. This view is deprecated since OceanBase Database V4.0.0.
V$TENANT_MEMSTORE_ALLOCATOR_INFO	The information in this view is not displayed. This view is deprecated since OceanBase Database V4.0.0.
V$RESTORE_POINT	This view is deprecated since OceanBase Database V4.0.0.
DBA_OUTLINES	This view is deprecated since OceanBase Database V4.0.0.
CDB_CKPT_HISTORY	This view is deprecated since OceanBase Database V4.0.0.