Overview
This view displays information about dynamic partitioned tables for the current tenant. It reads attributes related to dynamic partitioned tables from memory, which provides good read performance.
Note
Because 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 verify the version.
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 attribute 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 | Dynamically partitioned management precreate_time. |
| EXPIRE_TIME | varchar(1024) | NO | Dynamic partition 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: 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