Overview
This view displays the dynamic partitioned table information for all tenants. It reads the attributes of dynamic partitioned tables from memory, which provides good read performance.
Note
Since the dynamic performance view (V$OB_DYNAMIC_PARTITION_TABLES) retrieves information from the memory of the connection node, its data may not be up to date compared to the data dictionary view (DBA/CDB_OB_DYNAMIC_PARTITION_TABLES). You must use TENANT_SCHEMA_VERSION to confirm whether the information is current.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID of the dynamic partitioned table. |
| TENANT_SCHEMA_VERSION | bigint(20) | NO | The value on which the current property is based when retrieved from memory. schema_version. |
| DATABASE_NAME | varchar(128) | NO | The name of the database where the dynamic partitioned table is located. |
| 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 | Specifies whether to enable dynamic partition management. |
| TIME_UNIT | varchar(1024) | NO | Dynamically partitioned management time_unit. |
| PRECREATE_TIME | varchar(1024) | NO | Dynamic partition management precreate_time. |
| EXPIRE_TIME | varchar(1024) | NO | Dynamically partitioned management expire_time. |
| TIME_ZONE | varchar(1024) | NO | Dynamically partitioned management time_zone. |
| BIGINT_PRECISION | varchar(1024) | NO | Dynamically partitioned management bigint_precision. |
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