Note
- For V4.4.x, this view is available starting with V4.4.1.
- For V4.2.5, this view is available starting with V4.2.5 BP2.
Purpose
The DBA_OB_OBJECT_BALANCE_WEIGHT view displays all partitions with special weights in the current user tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLE_ID | NUMBER(38) | NO | The ID of the table. |
| PARTITION_ID | NUMBER | NO | The ID of the partition. If the partition weight is not set, the value is NULL |
| SUBPARTITION_ID | NUMBER | NO | The ID of the subpartition. If the partition weight is not set, the value is NULL. Currently, setting subpartition weights is not supported. |
| WEIGHT | NUMBER(38) | NO | The weight of the partition. |
| DATABASE_NAME | VARCHAR2(128) | NO | The name of the database to which the table belongs. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(64) | NO | The name of the partition. |
| SUBPARTITION_NAME | VARCHAR2(64) | NO | The name of the subpartition. |
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group to which the table belongs. |
| DATABASE_ID | NUMBER(38) | NO | The ID of the database to which the table belongs. |
| TABLEGROUP_ID | NUMBER(38) | NO | The ID of the table group to which the table belongs. |
| OBJECT_ID | NUMBER(38) | NO | The ID of the object to which the table belongs. |
Sample query
Query partitions with special weights in the current user tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_OBJECT_BALANCE_WEIGHT;
The query result is as follows:
+----------+--------------+-----------------+--------+---------------+------------+----------------+-------------------+-----------------+-------------+---------------+-----------+
| TABLE_ID | PARTITION_ID | SUBPARTITION_ID | WEIGHT | DATABASE_NAME | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | TABLEGROUP_NAME | DATABASE_ID | TABLEGROUP_ID | OBJECT_ID |
+----------+--------------+-----------------+--------+---------------+------------+----------------+-------------------+-----------------+-------------+---------------+-----------+
| 500002 | NULL | NULL | 1 | SYS | TBL1_H | NULL | NULL | NULL | 201006 | NULL | 500002 |
| 500002 | 500003 | NULL | 2 | SYS | TBL1_H | P0 | NULL | NULL | 201006 | NULL | 500003 |
+----------+--------------+-----------------+--------+---------------+------------+----------------+-------------------+-----------------+-------------+---------------+-----------+
2 rows in set