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.
Starting from OceanBase Database V4.x, you cannot directly access entity tables and virtual tables. You can query views for corresponding information.
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 | Description |
|---|---|---|
| __all_collation | information_schema.COLLATIONS | Displays the collation for each character set. |
| __all_tenant | DBA_OB_TENANTS | Displays the basic information about tenants. |
| __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_meta_table | DBA_OB_LS_LOCATIONS | Displays information about locations of log streams. |
| __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. |
| information_schema.session_variables information_schema.global_variables |
Displays information about system variables in a MySQL 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. |
| 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. |
| __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. |
| oceanbase.DBA_RECYCLEBIN SYS.DBA_RECYCLEBIN |
Displays information about the recycle bin. | |
| __all_zone | DBA_OB_MAJOR_COMPACTION | Displays the overall major compaction status. |
| 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 asv$plan_cache_statandv$obrpc_outgoing. - In OceanBase Database V4.0 and later, all view names are prefixed with
OB_*, such asV$OB_PLAN_CACHE_STATandV$OB_RPC_OUTGOING.
The following table lists the views that are renamed in OceanBase Database V4.x.
| View name | New view name |
|---|---|
| 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 name | Description |
|---|---|
| DBA_OB_TENANTS | Displays basic information about tenants. This view is introduced since OceanBase Database V4.0.0. |
|
Display information about resource units of tenants. These views are introduced since OceanBase Database V4.0.0. |
| DBA_OB_UNIT_CONFIGS | Displays information about unit configs of all tenants. This view is introduced since OceanBase Database V4.0.0. |
| DBA_OB_RESOURCE_POOL | Displays information about resource pools of all tenants. This view is introduced since OceanBase Database V4.0.0. |
| DBA_OB_SERVERS | Displays information about all OBServer nodes. This view is introduced since OceanBase Database V4.0.0. |
| DBA_OB_ZONES | Displays information about all zones. This view is introduced since OceanBase Database V4.0.0. |
| DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the history of RootService events. This view is introduced since OceanBase Database V4.0.0. |
|
Display information about RootService jobs. These views are introduced since OceanBase Database V4.0.0. |
| DBA_OB_LS_LOCATIONS | Displays information about locations of log streams in the sys tenant. This view is introduced since OceanBase Database V4.0.0. |
|
Display the database metadata of the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about schemas of all tenants in the sys tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about all tables and indexes in the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about tables and indexes in the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about partitioned tables in the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about partitioned tables in the current tenant. These views are introduced since OceanBase Database V4.0.0. |
| SYS.DBA_OBJECTS | Displays status information about objects in the current tenant. This view is introduced since OceanBase Database V4.0.0. |
| oceanbase.DBA_OBJECTS | Displays status information about objects in the current tenant. This view is introduced since OceanBase Database V4.0.0. |
|
Display associations between table groups and tables. These views are introduced since OceanBase Database V4.0.0. |
| CDB_OB_SYS_VARIABLES | Displays information about system variables of all tenants in the sys tenant. This view is introduced since OceanBase Database V4.0.0. |
|
Display information about system variables of the current tenant. These views are introduced since OceanBase Database V4.0.0. |
| information_schema.STATISTICS | Displays information about indexes in the current tenant. This view is introduced since OceanBase Database V4.0.0. |
| SYS.DBA_CONS_COLUMNS | Displays information about constrained columns in all tables. This view is introduced since OceanBase Database V4.0.0. |
|
Display information about partitions of all tenants in the sys tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about partitions in the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display information such as partition information and partition storage parameters. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about outlines of the current tenant. These views are introduced since OceanBase Database V4.0.0. |
|
Display suggestions on major compactions. These views are introduced since OceanBase Database V4.0.0. |
|
Display 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. These views are introduced since OceanBase Database V4.0.0. |
| GV$OB_SERVERS | Displays information about all OBServer nodes. This view is introduced since OceanBase Database V4.0.0. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of the current tenant. This view is introduced since OceanBase Database V4.0.0. |
| GV$OB_PROCESSLIST | Displays the sessions on all OBServer nodes of the current tenant. This view is introduced since OceanBase Database V4.0.0. |
| GV$OB_KVCACHE | Displays information about the KVCache on each OBServer node. This view is introduced since OceanBase Database V4.0.0. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. This view is introduced since OceanBase Database V4.0.0. |
|
Display the columns of all tenants in the sys tenant. These views are introduced since OceanBase Database V4.0.0. |
| information_schema.COLUMNS | Displays information about columns. It is a standard view of MySQL tenants. This view is introduced since OceanBase Database V4.0.0. |
|
Display information about columns. They are standard views of Oracle tenants. These views are introduced since OceanBase Database V4.0.0. |
|
Display the list of all tablets and the log streams to which the tablets belong. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about all tablet replicas. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about transaction participants on all OBServer nodes. These views are introduced since OceanBase Database V4.0.0. |
|
Display information about all recycle bins. These views are introduced since OceanBase Database V4.0.0. |
Views deprecated in OceanBase Database V4.x
The following table lists the views that are deprecated in OceanBase Database V4.x.
| View name | Description |
|---|---|
| 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 externally disclosed. This view is deprecated since OceanBase Database V4.0.0. |
| v$tenant_memstore_allocator_info | The information in this view is not externally disclosed. 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 | The features corresponding to this view are not supported in OceanBase Database V4.x. This view is deprecated since OceanBase Database V4.0.0. |
| 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 externally disclosed. This view is deprecated since OceanBase Database V4.0.0. |
| V$TENANT_MEMSTORE_ALLOCATOR_INFO | The information in this view is not externally disclosed. 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. |