Note
This view is introduced in BP2 of V4.3.5.
Purpose
This view displays the information about the dynamic partitioned tables in the current tenant. The view reads the attributes of dynamic partitioned tables from the memory and thus delivers better read performance.
Note
The dynamic performance view (V$OB_DYNAMIC_PARTITION_TABLES) obtains information from the node memory. Therefore, the information in this view may not be the most current data compared with that in the data dictionary view (DBA/CDB_OB_DYNAMIC_PARTITION_TABLES). You can use the TENANT_SCHEMA_VERSION column to confirm the schema version.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant that contains the dynamic partitioned table. |
| TENANT_SCHEMA_VERSION | NUMBER(38) | NO | The schema_version based on which the current attributes are obtained from the memory. |
| DATABASE_NAME | VARCHAR2(128) | NO | The name of the database that contains the dynamic partitioned table. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the dynamic partitioned table. |
| TABLE_ID | NUMBER(38) | NO | The ID of the dynamic partitioned table. |
| MAX_HIGH_BOUND_VAL | VARCHAR2(4096) | NO | The upper bound of the maximum range partition. |
| ENABLE | VARCHAR2(1024) | NO | Indicates whether dynamic partition management is enabled. |
| TIME_UNIT | VARCHAR2(1024) | NO | The time_unit in dynamic partition management. |
| PRECREATE_TIME | VARCHAR2(1024) | NO | The precreate_time in dynamic partition management. |
| EXPIRE_TIME | VARCHAR2(1024) | NO | The expire_time in dynamic partition management. |
| TIME_ZONE | VARCHAR2(1024) | NO | The time_zone in dynamic partition management. |
| BIGINT_PRECISION | VARCHAR2(1024) | NO | The bigint_precision in dynamic partition management. |
Sample query
SELECT * FROM sys.V$OB_DYNAMIC_PARTITION_TABLES\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1004
TENANT_SCHEMA_VERSION: 1744704246384440
DATABASE_NAME: TEST_USER001
TABLE_NAME: TBL2
TABLE_ID: 500004
MAX_HIGH_BOUND_VAL: Timestamp '2025-02-04 21:00:00.000000'
ENABLE: TRUE
TIME_UNIT: HOUR
PRECREATE_TIME: 3HOUR
EXPIRE_TIME: 1DAY
TIME_ZONE: +8:00
BIGINT_PRECISION: NONE
1 row in set