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 table 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 table 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
systenant.
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 | DBA_OB_TENANTS | Displays the basic information of tenants. |
| 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:
|
Displays the basic information of the current user tenant. |
| __all_unit_config | DBA_OB_UNIT_CONFIGS | Displays the information about unit configs. |
| __all_resource_pool | DBA_OB_RESOURCE_POOLS | Displays the information about resource pools. |
| __all_server | DBA_OB_SERVERS | Displays the information about OBServer nodes. |
| __all_zone | DBA_OB_ZONES | Displays the 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 |
Displays the information about RootService jobs. The information 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 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 the information about databases. |
| 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 the information about schemas of all tenants in the sys tenant. |
| information_schema.tables information_schema.statistics |
Displays the information about 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 |
CDB_OB_SYS_VARIABLES | Displays the information about system variables of all tenants in the sys tenant. |
Views in a MySQL tenant:
|
Displays the information about system variables in a MySQL tenant. | |
Execute the following SQL statements in an Oracle tenant:
|
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. |
| 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 |
CDB_TAB_PARTITIONS CDB_TAB_SUBPARTITIONS CDB_IND_PARTITIONS CDB_IND_SUBPARTITIONS 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. | |
| DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_SUBPARTITION_TEMPLATES |
Displays the information about partitions in a MySQL tenant. | |
| __all_virtual_outline __all_outline |
DBA_OB_OUTLINES DBA_OB_CONCURRENT_LIMIT_SQL |
Displays the 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 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 | CDB_TAB_COLUMNS CDB_TAB_COLS |
Displays the information about columns of all tenants in the sys tenant. |
| information_schema.COLUMNS | Displays the information about columns. | |
| SYS.DBA_TAB_COLUMNS SYS.DBA_TAB_COLS |
Displays the information about columns. | |
| DBA_OB_TABLET_TO_LS CDB_OB_TABLET_TO_LS |
Displays the information about all tablets and the log streams to which the tablets belong. | |
| DBA_OB_TABLET_REPLICAS 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:
|
Displays the information about recycle bins. |
| __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 between OceanBase Database V3.x and V4.x 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.
| 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 | V$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 |
|---|---|---|
|
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 of historical collection tasks. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | V4.2.0 | Displays the collection history of tables. |
| 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 that have been 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 list of files of all external tables created in the current tenant. |
| oceanbase.ALL_OB_EXTERNAL_TABLE_FILES | V4.2.0 | Displays the list of files of external tables accessible to the current user. |
| oceanbase.CDB_OB_EXTERNAL_TABLE_FILES | V4.2.0 | Displays the list of files of external tables created in all tenants. |
| oceanbase.DBA_OB_BALANCE_JOBS | V4.2.0 | Displays the ongoing load balancing job of the current tenant. |
| oceanbase.CDB_OB_BALANCE_JOBS | V4.2.0 | Displays the ongoing load balancing jobs of 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 tasks of the current tenant. |
| oceanbase.DBA_OB_BALANCE_TASK_HISTORY | V4.2.0 | Displays the history of all load balancing tasks executed in the current tenant. |
| oceanbase.CDB_OB_BALANCE_TASKS | V4.2.0 | Displays the ongoing load balancing tasks of all tenants. |
| oceanbase.CDB_OB_BALANCE_TASK_HISTORY | V4.2.0 | Displays the history of load balancing tasks executed in all tenants. |
| oceanbase.DBA_OB_TRANSFER_TASKS | V4.2.0 | Displays the ongoing transfer tasks of 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 of 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 of historical collection tasks. |
| DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | V4.2.0 | Displays the collection history of tables. |
| 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 that have been 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 list of files of all external tables created in the current tenant. |
| ALL_OB_EXTERNAL_TABLE_FILES | V4.2.0 | Displays the list of files of external tables accessible to the current user. |
| DBA_OB_BALANCE_JOBS | V4.2.0 | Displays the ongoing load balancing job of 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 tasks of the current tenant. |
| DBA_OB_BALANCE_TASK_HISTORY | V4.2.0 | Displays the history of all load balancing tasks executed in the current tenant. |
| DBA_OB_TRANSFER_TASKS | V4.2.0 | Displays the ongoing transfer tasks of 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. |
|
V4.2.0 | Displays the status information of all threads in the observer process. |
|
V4.2.0 | Displays the communication status between the cluster and the arbitration service. |
|
V4.2.0 | Displays the information about arbitration members in the current cluster. |
|
V4.2.0 | Displays the real-time status of statistics collection tasks. |
|
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. |
|
V4.2.0 | Displays the information about data transmission operations that are executed in parallel. |
|
V4.2.0 | Displays the real-time execution information of join filters. |
|
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 the 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 the 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 the 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 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 | 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_USER_DEFINED_RULES | V4.1.0 | Displays the rules for customizing SQL statements. |
| DBA_OB_TENANTS | V4.1.0 | Displays the basic information of tenants. |
| DBA_OB_LS_LOG_ARCHIVE_PROGRESS | V4.1.0 | Displays the log archiving progress of the current tenant. |
|
V4.1.0 | Displays the access control strategies that can be created on a table. |
|
V4.1.0 | Displays the information about the strategy group that takes effect for different users based on the strategy context. |
|
V4.1.0 | Displays the context based on which the corresponding strategy group takes effect. |
|
V4.1.0 | Displays the column-level strategies associated with a specified column. |
| 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. |
| 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. |
|
V4.1.0 | Sorts all triggers in the current database. |
| DBA_OB_RSRC_IO_DIRECTIVES | V4.1.0 | Displays the I/O resource configuration in Resource Manager. |
|
|
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 the basic information of tenants. |
|
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. |
|
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. |
|
V4.0.0 | Displays the database metadata of the current tenant. |
|
V4.0.0 | Displays the information about schemas of all tenants in the sys tenant. |
|
V4.0.0 | Displays the information about tables and indexes in the current tenant. |
|
V4.0.0 | Displays the information about tables and indexes in the current tenant. |
|
V4.0.0 | Displays the information about partitioned tables in the current tenant. |
|
V4.0.0 | Displays the information about partitioned tables in the current tenant. |
| SYS.DBA_OBJECTS | V4.0.0 | Displays the status information of indexes in the current tenant. |
| oceanbase.DBA_OBJECTS | V4.0.0 | Displays the status information of indexes in the current tenant. |
|
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. |
|
V4.0.0 | Displays the information about system variables of the current tenant. |
| information_schema.STATISTICS | V4.0.0 | Displays the information about indexes in 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. |
|
V4.0.0 | Displays the information about partitions of all tenants in the sys tenant. |
|
V4.0.0 | Displays the information about partitions in the current tenant. |
|
V4.0.0 | Displays the partition information and partition storage parameters. |
|
V4.0.0 | Displays the information about outlines of the current tenant. |
|
V4.0.0 | Displays the information about major compactions. |
|
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. |
|
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. |
|
V4.0.0 | Displays the information about columns. |
|
V4.0.0 | Displays the information about all tablets and the log streams to which the tablets belong. |
|
V4.0.0 | Displays the information about all tablet replicas. |
|
V4.0.0 | Displays the information about transaction participants on all OBServer nodes. |
|
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 | Description |
|---|---|
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | This view has been deprecated since OceanBase Database V4.2.0. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | This view has been deprecated since OceanBase Database V4.2.0. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | This view has been deprecated since OceanBase Database V4.2.0. |
| DBA_OB_TABLEGROUP_PARTITIONS | This view has been deprecated since OceanBase Database V4.2.0. |
| gv$sql | This view has been deprecated since OceanBase Database V4.0.0. |
| v$sql | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$server_memstore | This view has been deprecated since OceanBase Database V4.0.0 because its content is duplicate with that of the GV$OB_MEMSTORE view. |
| gv$unit_load_balance_event_history | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$tenant | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$database | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$table | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$unit | This view has been deprecated since OceanBase Database V4.0.0. |
| v$unit | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$partition | This view has been deprecated since OceanBase Database V4.0.0. |
| v$partition | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$tenant_memstore_allocator_info | This view has been deprecated since OceanBase Database V4.0.0. The information in this view is not displayed. |
| v$tenant_memstore_allocator_info | This view has been deprecated since OceanBase Database V4.0.0. The information in this view is not displayed. |
| gv$minor_merge_info | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$partition_audit | This view has been deprecated since OceanBase Database V4.0.0. |
| v$partition_audit | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$ob_trans_table_status | This view has been deprecated since OceanBase Database V4.0.0. |
| v$ob_trans_table_status | This view has been deprecated since OceanBase Database V4.0.0. |
| gv$merge_info | This view has been deprecated since OceanBase Database V4.0.0. |
| v$merge_info | This view has been deprecated since OceanBase Database V4.0.0. |
| v$restore_point | This view has been deprecated since OceanBase Database V4.0.0 because the corresponding feature is not supported in OceanBase Database V4.x. |
| GV$OUTLINE | This view has been deprecated since OceanBase Database V4.0.0. |
| GV$MEMSTORE_INFO | This view has been deprecated since OceanBase Database V4.0.0. |
| V$MEMSTORE_INFO | This view has been deprecated since OceanBase Database V4.0.0. |
| GV$SERVER_MEMSTORE | This view has been deprecated since OceanBase Database V4.0.0. |
| GV$TENANT_MEMSTORE_ALLOCATOR_INFO | This view has been deprecated since OceanBase Database V4.0.0. The information in this view is not displayed. |
| V$TENANT_MEMSTORE_ALLOCATOR_INFO | This view has been deprecated since OceanBase Database V4.0.0. The information in this view is not displayed. |
| V$RESTORE_POINT | This view has been deprecated since OceanBase Database V4.0.0. |
| DBA_OUTLINES | This view has been deprecated since OceanBase Database V4.0.0. |
| CDB_CKPT_HISTORY | This view has been deprecated since OceanBase Database V4.0.0. |