Note
This view is available starting with V4.3.5 BP2.
Purpose
This view displays information about dynamic partition tables for all tenants. The view reads dynamic partition table attributes from memory, which provides better read performance.
Note
Dynamic performance views (such as V$OB_DYNAMIC_PARTITION_TABLES) obtain information from the memory of the connected node. Therefore, the information in dynamic performance views may not be the latest compared to data dictionary views (such as DBA/CDB_OB_DYNAMIC_PARTITION_TABLES). You must use TENANT_SCHEMA_VERSION to further confirm the information.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the dynamic partition table belongs. |
| TENANT_SCHEMA_VERSION | bigint(20) | NO | The schema_version used to obtain the current attribute from memory. |
| DATABASE_NAME | varchar(128) | NO | The name of the database to which the dynamic partition table belongs. |
| TABLE_NAME | varchar(256) | NO | The name of the dynamic partition table. |
| TABLE_ID | bigint(20) | NO | The ID of the dynamic partition table. |
| MAX_HIGH_BOUND_VAL | varchar(4096) | NO | The upper bound of the maximum range partition. |
| ENABLE | varchar(1024) | NO | Indicates whether dynamic partition management is enabled. |
| TIME_UNIT | varchar(1024) | NO | The time_unit for dynamic partition management. |
| PRECREATE_TIME | varchar(1024) | NO | The precreate_time for dynamic partition management. |
| EXPIRE_TIME | varchar(1024) | NO | The expire_time for dynamic partition management. |
| TIME_ZONE | varchar(1024) | NO | The time_zone for dynamic partition management. |
| BIGINT_PRECISION | varchar(1024) | NO | The bigint_precision for dynamic partition management. |
Sample query
SELECT * FROM oceanbase.V$OB_DYNAMIC_PARTITION_TABLES LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
TENANT_SCHEMA_VERSION: 1744703613113648
DATABASE_NAME: db_test
TABLE_NAME: tbl2
TABLE_ID: 500003
MAX_HIGH_BOUND_VAL: '2024-11-11 13:30:00'
ENABLE: TRUE
TIME_UNIT: HOUR
PRECREATE_TIME: 3HOUR
EXPIRE_TIME: 1DAY
TIME_ZONE: +8:00
BIGINT_PRECISION: NONE
1 row in set