Note
This view is available starting with V4.3.5 BP2.
Purpose
This view displays information about dynamic partition tables in the current tenant. 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. Compared with data dictionary views (such as DBA/CDB_OB_DYNAMIC_PARTITION_TABLES), the information in dynamic performance views may not be the most recent. You need to use TENANT_SCHEMA_VERSION to confirm the information.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant where the dynamic partition table resides. |
| 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 where the dynamic partition table resides. |
| 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 maximum upper bound of a 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: 1744704241045608
DATABASE_NAME: db_test
TABLE_NAME: tbl2
TABLE_ID: 500003
MAX_HIGH_BOUND_VAL: '2025-02-04 21:00:00'
ENABLE: TRUE
TIME_UNIT: HOUR
PRECREATE_TIME: 3HOUR
EXPIRE_TIME: 1DAY
TIME_ZONE: +8:00
BIGINT_PRECISION: NONE
1 row in set