Note
This view is introduced in V4.3.5 BP2.
Purpose
This view displays information about the dynamic partitioning of the current tenant. The view reads the attributes of dynamic partitioned tables from the memory and has better read performance.
Note
The dynamic performance view (V$OB_DYNAMIC_PARTITION_TABLES) obtains information from the memory of the connected node. Compared with the data dictionary view (DBA/CDB_OB_DYNAMIC_PARTITION_TABLES), the information in the dynamic performance view may not be the latest. You need to use TENANT_SCHEMA_VERSION to confirm it.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant that contains the dynamic partitioned table. |
| TENANT_SCHEMA_VERSION | bigint(20) | NO | The schema_version based on which the memory retrieves the current attributes. |
| DATABASE_NAME | varchar(128) | NO | The name of the database that contains the dynamic partitioned table. |
| TABLE_NAME | varchar(256) | NO | The name of the dynamic partitioned table. |
| TABLE_ID | bigint(20) | NO | The ID of the dynamic partitioned table. |
| MAX_HIGH_BOUND_VAL | varchar(4096) | NO | The upper bound of the maximum range partition. |
| ENABLE | varchar(1024) | NO | Whether the management of dynamic partitions is enabled. |
| TIME_UNIT | varchar(1024) | NO | The time_unit of dynamic partition management. |
| PRECREATE_TIME | varchar(1024) | NO | The precreate_time of dynamic partition management. |
| EXPIRE_TIME | varchar(1024) | NO | The expire_time of dynamic partition management. |
| TIME_ZONE | varchar(1024) | NO | The time_zone of dynamic partition management. |
| BIGINT_PRECISION | varchar(1024) | NO | The bigint_precision of 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