OceanBase Database V4.x has undergone significant changes to internal tables and virtual tables, providing numerous views to display system information. The most significant change in V4.x is the shift of querying internal information to views. These views are consistently defined across versions, making the information clearer.
For example, the previously used __all_tenant_meta_table for recording partition location information is no longer necessary 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 log stream's location. You can use the DBA_OB_LS_LOCATIONS view to view the log stream location information. Additionally, the __all_zone view for viewing the cluster compaction status has been modified. In V4.x, the system tenant only stores cluster zone and region information in the __all_zone table, while the compaction status is stored in dedicated internal tables. You can use 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, unlike previous versions where compaction was a cluster-wide status, in V4.x, each tenant independently performs compaction. Therefore, each tenant can use the DBA_OB_MAJOR_COMPACTION and DBA_OB_ZONE_MAJOR_COMPACTION views to view their own compaction status.
In addition, in V4.x, existing views have been modified according to the view definition specifications, including:
- Removed unnecessary views.
- Added the
OB_prefix to view names. - Changed view names and column names to uppercase.
- For tenant-level views, the user tenant only displays data for its own tenant, while the system tenant displays data for all tenants.
Correspondence between internal tables and views
OceanBase Database V4.x provides a large number of views. You can query the required information by using the following correspondence between internal tables and views.
| Entity/Virtual table | View/Command | Description |
|---|---|---|
| __all_collation | information_schema.COLLATIONS | This column displays comparison method information for each character set. |
| __all_tenant | oceanbase.DBA_OB_TENANTS | This view displays the basic information of a tenant. |
| gv$tenant (V4.x obsolete) | Run the following commands in a MySQL tenant or an Oracle tenant to obtain information about the current tenant:
|
This view displays the basic information about the users of the specified user tenant. |
| __all_unit_config | oceanbase.DBA_OB_UNIT_CONFIGS | Displays the Unit Config information |
| __all_resource_pool | oceanbase.DBA_OB_RESOURCE_POOLS | This view displays the information about resource pools. |
| __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 | This view displays event history of the Root service |
| __all_rootservice_job | oceanbase.DBA_OB_UNIT_JOBS oceanbase.DBA_OB_TENANT_JOBS oceanbase.DBA_OB_SERVER_JOBS |
The view separates RootService Job information into multiple views, which are differentiated based on the displayed types, facilitating structured queries. |
| __all_virtual_core_all_table | oceanbase.DBA_OB_LS_LOCATIONS | Displays information about the distribution of Log Service (LS) replicas across the current tenant. |
| gv$database(V4.x deprecated) __all_database |
oceanbase.CDB_OB_DATABASES oceanbase.DBA_OB_DATABASES information_schema.SCHEMATA oceanbase.DBA_USERS |
Database information. |
| gv$table(V4.x deprecated) __all_table __all_virtual_table |
oceanbase.CDB_OBJECTS oceanbase.CDB_TABLES oceanbase.CDB_INDEXES oceanbase.CDB_IND_COLUMNS oceanbase.CDB_PART_TABLES oceanbase.CDB_TAB_PARTITIONS |
Schema information for accessing schemas of all tenants under the system tenant. |
| information_schema.TABLES information_schema.STATISTICS |
Provides access to all tables and indexes in a MySQL tenant. | |
| SYS.DBA_TABLES SYS.DBA_INDEXES |
View information about tables and indexes in an Oracle tenant. | |
| SYS.DBA_PART_TABLES SYS.DBA_PART_INDEXES |
Obtain information about partitioned tables under an Oracle tenant. | |
| oceanbase.DBA_PART_TABLES oceanbase.DBA_PART_INDEXES |
Get the information about a partitioned table in a MySQL tenant. | |
| SYS.DBA_OBJECTS | Obtain partition table information under an Oracle tenant. | |
| oceanbase.DBA_OBJECTS | Obtain information about partitioned tables in a MySQL tenant. | |
| oceanbase.DBA_OB_TABLEGROUP_TABLES SYS.DBA_OB_TABLEGROUP_TABLES |
This column displays the tablegroup information of the retrieved table. | |
| __all_virtual_sys_variable __all_sys_variable |
oceanbase.CDB_OB_SYS_VARIABLES | System variables for accessing information about all tenants in the system tenant. |
Relevant views in a MySQL tenant:
|
Obtain the system variable information in a MySQL tenant. | |
Commands in Oracle mode are as follows:
|
Obtain information about system variables in an Oracle tenant. | |
| __tenant_virtual_table_index | information_schema.STATISTICS | Obtains the information about the index keys in a MySQL tenant. |
| SYS.DBA_CONS_COLUMNS | Obtains the information about the index keys 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 |
Obtains the partition information of all tenants under the sys tenant. |
| SYS.DBA_TAB_PARTITIONS SYS.DBA_TAB_SUBPARTITIONS SYS.DBA_IND_PARTITIONS SYS.DBA_IND_SUBPARTITIONS SYS.DBA_SUBPARTITION_TEMPLATES |
Obtains the partition information in an Oracle tenant. | |
| oceanbase.DBA_TAB_PARTITIONS oceanbase.DBA_TAB_SUBPARTITIONS oceanbase.DBA_IND_PARTITIONS oceanbase.DBA_IND_SUBPARTITIONS oceanbase.DBA_SUBPARTITION_TEMPLATES |
Obtains the partition information in a MySQL tenant. | |
| __all_virtual_outline __all_outline |
oceanbase.DBA_OB_OUTLINES oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL |
Displays the outline information. |
| __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 location information. |
| __all_virtual_server_stat __all_virtual_disk_stat |
GV$OB_SERVERS | Displays the 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 the configuration item information. |
| __all_virtual_processlist | GV$OB_PROCESSLIST | Displays the session information. |
| __all_virtual_kvcache_info | GV$OB_KVCACHE | Displays the KVCACHE information. |
| GV$MEMSTORE(V4.x deprecated) __all_virtual_tenant_memstore_info |
GV$OB_MEMSTORE | Displays the MemStore information. |
| __all_virtual_column | oceanbase.CDB_TAB_COLUMNS oceanbase.CDB_TAB_COLS |
Accesses the views of all tenants under the sys tenant. |
| information_schema.COLUMNS | Displays the column information. | |
| oceanbase.DBA_TAB_COLUMNS oceanbase.DBA_TAB_COLS |
Displays the column information. | |
| oceanbase.DBA_OB_TABLET_TO_LS oceanbase.CDB_OB_TABLET_TO_LS |
Displays the list of all tablets and the log stream to which each tablet belongs. | |
| 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 the transaction participants on all servers. |
| —— | References:
|
Displays the recyclebin information. |
| __all_zone | oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the overall major compaction status. |
| 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 for standardization and convenience in 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 asv$plan_cache_statandv$obrpc_outgoing. - In OceanBase Database V4.0 and later, the
OB_*prefix is added to all built-in views, such asV$OB_PLAN_CACHE_STATandV$OB_RPC_OUTGOING.
The following table lists the views whose names have been changed in V4.x.
| View | Version | New view |
|---|---|---|
| GV$ACTIVE_SESSION_HISTORY | V4.2.2 | GV$OB_ACTIVE_SESSION_HISTORY
NoteThe original view is not deleted but not recommended for use. |
| V$ACTIVE_SESSION_HISTORY | V4.2.2 | V$OB_ACTIVE_SESSION_HISTORY
NoteThe original view is not deleted but 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 | Introduced in | Description |
|---|---|---|
| V$OB_SS_SSTABLES | V4.4.0 | This view displays the information about SSTables in shared storage. |
|
V4.4.0/V4.3.5 BP2 | This view displays the cache information of tablets. |
|
V4.4.0/V4.3.5 BP2 | This view displays the information about the current cache tasks. |
|
V4.4.0/V4.3.5 1 BP1 | This view displays the progress of converting tablets in the log stream of C replicas on each OBServer node of a tenant. |
|
V4.3.4 | This view displays the relevant metrics of various cache data in the local cache of each OBServer node of a tenant. |
|
V4.3.4 | This view displays the IO operations of objects stored in the object storage and cloud disks of a tenant. |
|
V4.3.4 | This view displays the resource configuration parameters of a tenant in the Resource Manager. |
|
V4.3.4 | This view displays the IO access resource information of each OBServer node. |
|
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 tenants can access this view. This view displays the features that can be controlled for compatibility with the OceanBase Database release version. |
| DBA_OB_SPATIAL_COLUMNS | V4.3.2 | Only the Oracle tenant can access this view. This view displays the database name, table name, type, and SRS information of spatial index columns. |
| PROXY_USERS | V4.3.2 | Only the Oracle 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 users. |
| mysql.default_roles | V4.3.1 | This view displays the default roles enabled for users. |
| 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. |
|
V4.3.1 | This view displays the configurations of system variables of the current tenant. |
|
V4.3.1 | This view displays the NIC information of OBServer nodes, primarily the NIC speed. |
|
V4.3.1 | This view displays the basic information of PL-related cache objects in the server. |
|
V4.3.1 | This view displays the usage of logical resources, the upper limit, the effective restriction conditions, and the maximum increase after a restart on the OBServer node. |
|
V4.3.1 | This view displays the restrictions on logical resources on the OBServer node and the upper limits of each restriction. |
|
V4.3.0 | This view displays the index usage data. |
|
V4.3.0 | This view displays the information about materialized view logs. |
|
V4.3.0 | This view displays the information about materialized views. |
|
V4.3.0 | This view displays the statistics related to the refresh of materialized views. |
|
V4.3.0 | This view displays the information about each refresh of a materialized view, identified by a REFRESH_ID. |
|
V4.3.0 | This view displays the basic timing statistics of the refresh of materialized views. |
|
V4.3.0 | This view displays the refresh statistics attributes associated with each materialized view. |
|
V4.3.0 | This view displays the system-wide default values of the statistics attributes of the refresh history of materialized views. |
|
V4.3.0 | This view describes the information associated with the refresh statements. |
|
V4.3.0 | This view displays the auxiliary statistics of all tenants. |
| oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE | V4.3.0 | This view is accessible only to the sys tenant. It displays the list of trusted CA root certificates in the OBServer cluster and the expiration time of the certificates. |
|
V4.3.0 | This view displays the information about the log stream snapshots stored in the persistent storage of the Unit. |
|
V4.3.0 | This view records the session information created in the Server. |
| USER_USERS | V4.2.1 BP2 | This view displays the information about the current user. |
|
V4.2.1_CE_BP1 | This view displays the statistics about the OBKV connections held by the Server. |
|
V4.2.1 | This view displays the results of import tasks. |
|
V4.2.1 | This view displays the information about import tasks. |
|
V4.2.1 | This view displays the history records of cross-tenant table-level import tasks. |
|
V4.2.1 | This view displays the records of cross-tenant table-level import tasks. |
|
V4.2.1 | This view displays the results of table-level restore tasks. |
|
V4.2.1 | This view displays the information about table-level restore tasks. |
|
V4.2.1 | This view displays the partition transfer tasks currently being processed by all tenants. |
|
V4.2.1 | This view displays the history of partition transfer tasks executed by tenants. |
|
V4.2.1 | This view displays the ASH data after persistence on all nodes. |
|
V4.2.1 | This view displays the WR-related configuration information. |
|
V4.2.1 | This view displays the SNAPSHOT information of all tenants. |
|
V4.2.1 | This view displays the names of the system statistics of all tenants. |
|
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 full-link tracing. |
|
V4.2.1 | This view displays the information about the 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. |
|
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. |
|
V4.2.0 | This view queries the execution of historical collection tasks. |
|
V4.2.0 | This view queries the historical collection execution. |
|
V4.2.0 | This view displays the log restore sources of the primary tenant and standby tenant. |
|
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 outdated. |
|
V4.2.0 | This view displays the list of files corresponding to the external tables created by the tenant. |
|
V4.2.0 | This view displays the list of external tables that the current user has access permissions to. |
|
V4.2.0 | This view displays the load balancing tasks currently being executed by the tenant. |
|
V4.2.0 | This view displays the history of all load balancing tasks executed by the tenant. |
|
V4.2.0 | This view displays the load balancing tasks currently being executed by the tenant. |
|
V4.2.0 | This view displays the history of load balancing tasks executed in the tenant. |
|
V4.2.0 | This view displays the Transfer tasks currently being executed in the tenant. |
|
V4.2.0 | This view displays the history of Transfer tasks executed in the tenant. |
|
V4.2.0 | This view displays the server list of the tenant entry point. |
| oceanbase.DBA_DB_LINKS | V4.2.0 | This view displays all DBLINKs created in the current tenant. |
|
V4.2.0 | This view displays the log streams that existed in the tenant in the past. |
|
V4.2.0 | This view displays the historical operation records of all tenants in the cluster. Only the sys tenant can access this view. |
|
V4.2.0 | This view displays the status information of all threads in the observer process. |
|
V4.2.0 | This view displays the communication status between the cluster and the arbitration service. |
|
V4.2.0 | This view displays the arbitration member information of the cluster. |
|
V4.2.0 | This view queries the real-time status of statistics collection tasks. |
|
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 recovery status at the log stream level. |
| 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. |
|
V4.2.0 | This view displays the information of parallel execution data transfer operations. |
|
V4.2.0 | This view dynamically displays the execution information of Join Filters. |
|
V4.2.0 | This view displays the plan information collected by the user through the EXPLAIN PLAN tool. |
|
V4.1.0 | This view records the rules for rewriting SQL statements. |
|
V4.1.0 | This view displays the log stream archiving progress of the tenant. |
| oceanbase.DBA_OB_ARBITRATION_SERVICE | V4.1.0 | This view displays the arbitration service configuration information of the current cluster. Only the sys tenant can access this view. |
|
V4.1.0 | This view displays the arbitration service tasks currently being executed in the current tenant and corresponding user tenants. |
|
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 | This view displays important events at the cluster level. Only the sys tenant can access this view. Currently, this view only supports displaying cluster upgrade events. |
|
V4.1.0 | This view displays the IO resource configuration in the Resource Manager. |
| V$OB_ARCHIVE_DEST_STATUS | V4.1.0 | This view displays the status of each archive destination at the tenant level. |
|
V4.1.0 | This view displays the basic information of a tenant. |
|
V4.1.0 | This view displays the multiple policies that can be created on a table for access control. |
|
V4.1.0 | This view displays the information of a policy group, which, together with the policy context, allows different policies to take effect for different users. |
|
V4.1.0 | This view displays the corresponding policy group that takes effect based on the value of the context when accessing a view. |
|
V4.1.0 | This view associates a column with a column-level policy, which takes effect when the column is accessed. |
|
V4.1.0 | This view displays the sorting of all triggers in the current database. |
| ALL_DB_LINKS | V4.1.0 | This view displays all DBLINKs accessible to the current user. |
| 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 the DBLINKs created by the current user. |
|
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 Root Service event history. |
|
V4.0.0 | This view displays the Root Service job information. |
| DBA_OB_LS_LOCATIONS | V4.0.0 | This view displays the RS location information under the system tenant. |
|
V4.0.0 | This view displays the database metadata of a tenant. |
|
V4.0.0 | This view displays the schema information of all tenants under the system tenant. |
|
V4.0.0 | This view displays the table and index information of a tenant. |
|
V4.0.0 | This view displays the table and index information of a tenant. |
|
V4.0.0 | This view displays the partition information of all partitioned tables accessible to the current user. |
|
V4.0.0 | This view displays the partition information of all partitioned indexes. |
|
V4.0.0 | This view displays the index status of a tenant. |
|
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 under the system tenant. |
|
V4.0.0 | This view displays system variable information in the current tenant. |
| DBA_CONS_COLUMNS | V4.0.0 | This view displays column information in constraints of all tables. |
|
V4.0.0 | This view displays partition information of all tenants in the sys tenant. |
|
V4.0.0 | This view displays partition information of the current tenant. |
|
V4.0.0 | This view displays partition information, partition storage parameters, and other related information. |
|
V4.0.0 | This view displays outline information of the current tenant. |
|
V4.0.0 | This view displays compaction information. |
|
V4.0.0 | This view displays log stream information. You can obtain the data_object_id of a table or partition by querying 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 resides. |
| GV$OB_PROCESSLIST | V4.0.0 | This view displays session information on all OBServer nodes where the current tenant resides. |
| 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. |
|
V4.0.0 | This view displays column information. |
|
V4.0.0 | This view displays the list of all tablets and the corresponding log streams. |
|
V4.0.0 | This view displays information about all tablet replicas. |
|
V4.0.0 | This view displays transaction participant information on all servers. |
|
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 architectural changes. You can query the information about table groups from the oceanbase.CDB_OB_TABLEGROUPS view. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | V4.2.0 | This view is deprecated due to architectural changes. You can query the information about table groups from the oceanbase.DBA_OB_TABLEGROUPS or SYS.DBA_OB_TABLEGROUPS view. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | V4.2.0 | This view is deprecated due to architectural changes. You can query the information about table groups from the oceanbase.CDB_OB_TABLEGROUPS view. |
| DBA_OB_TABLEGROUP_PARTITIONS | V4.2.0 | This view is deprecated due to architectural changes. You can query the information about table groups from the oceanbase.DBA_OB_TABLEGROUPS or SYS.DBA_OB_TABLEGROUPS view. |
| GV$SQL | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about SQL requests from the GV$OB_SQL_AUDIT view. |
| V$SQL | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about SQL requests from the V$OB_SQL_AUDIT view. |
| GV$UNIT_LOAD_BALANCE_EVENT_HISTORY | V4.0.0 | This view is deprecated due to architectural changes. No replacement view is available. |
| GV$TENANT | V4.0.0 | This view is deprecated due to functional changes. You can query the information about tenants from the oceanbase.DBA_OB_TENANTS or SYS.DBA_OB_TENANTS view. |
| GV$DATABASE | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about databases of a tenant from the oceanbase.DBA_OB_DATABASES or SYS.DBA_OB_DATABASES view. |
| GV$TABLE | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about database objects and tables from the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view. |
| GV$UNIT | V4.0.0 | This view is deprecated due to functional changes. You can query the information about OBServer nodes in the cluster from the oceanbase.DBA_OB_UNITS or GV$OB_UNITS view. |
| V$UNIT | V4.0.0 | This view is deprecated due to functional changes. You can query the information about OBServer nodes in the cluster from the oceanbase.DBA_OB_UNITS or V$OB_UNITS view. |
| GV$PARTITION | V4.0.0 | This view is deprecated due to functional changes. You can query the information about database objects and tables from the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view. |
| V$PARTITION | V4.0.0 | This view is deprecated due to functional changes. You can query the information about database objects and tables from the oceanbase.DBA_OBJECTS or SYS.DBA_OBJECTS view and the oceanbase.DBA_OB_TABLE_LOCATIONS or SYS.DBA_OB_TABLE_LOCATIONS view. |
| GV$TENANT_MEMSTORE_ALLOCATOR_INFO | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about MemTables from the GV$OB_MEMSTORE and GV$OB_MEMSTORE_INFO views. |
| V$TENANT_MEMSTORE_ALLOCATOR_INFO | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about MemTables from the GV$OB_MEMSTORE and GV$OB_MEMSTORE_INFO views. |
| GV$MINOR_MERGE_INFO | V4.0.0 | This view is deprecated due to architectural changes. No replacement view is available. |
| GV$PARTITION_AUDIT | V4.0.0 | This view is deprecated due to architectural changes. No replacement view is available. |
| V$PARTITION_AUDIT | V4.0.0 | This view is deprecated due to architectural changes. No replacement view is available. |
| GV$OB_TRANS_TABLE_STATUS | V4.0.0 | This view is deprecated because the concept of dirty transactions does not exist in V4.x. No replacement view is available. |
| V$OB_TRANS_TABLE_STATUS | V4.0.0 | This view is deprecated because the concept of dirty transactions does not exist in V4.x. No replacement view is available. |
| V$RESTORE_POINT | V4.0.0 | This view is deprecated because the Restore Point feature is not supported in V4.x. No replacement view is available. |
| GV$OUTLINE | V4.0.0 | This view is deprecated due to architectural changes. You can query the information about execution plan outlines of the current tenant from the oceanbase.DBA_OB_OUTLINES or SYS.DBA_OB_OUTLINES view. |
| CDB_CKPT_HISTORY | V4.0.0 | This view is deprecated due to architectural changes. In V4.x, for Mini Compaction (dump), no clear start and end times exist, so you cannot query Checkpoint information. For Major Compaction (major compaction), the system tenant can query the Checkpoint information of each tenant from the oceanbase.CDB_OB_MAJOR_COMPACTION view. A user tenant can query the Checkpoint information of the current tenant from the oceanbase.DBA_OB_MAJOR_COMPACTION or SYS.DBA_OB_MAJOR_COMPACTION view. |