DBA_NONVECTOR_OBJECTS View
DBA_NONVECTOR_OBJECTS lists the user-created objects that contribute to the non-vector storage quota calculation. The view reports each contributing object’s used bytes and its total bytes including dependent storage objects.
The specification defines the following columns for SYS.DBA_NONVECTOR_OBJECTS:
| Column | Description |
|---|---|
OWNER |
Owner of the contributing user-created object. |
OBJECT_NAME |
Name of the object that contributes to the user-created non-vector database storage calculation. |
OBJECT_TYPE |
Type of the contributing object. Independent objects such as user-created indexes are reported as separate INDEX rows. |
OBJECT_BYTES |
Used bytes attributed to the object. The size calculation is based on used-space information from DBMS_SPACE.UNUSED_SPACE. |
TOTAL_BYTES |
Used bytes for the object and its dependent storage objects. SUM(TOTAL_BYTES) should align with the main size API after conversion to gigabytes. |
REASON |
Reason the object is included in the user-created non-vector database storage calculation. |
Example: Query the DBA_NONVECTOR_OBJECTS View
Use the DBA_NONVECTOR_OBJECTS query to retrieve the user-created non-vector database objects included in the non-vector storage calculation.
SELECT owner, object_name, object_type, object_bytes, total_bytes, reason
FROM sys.dba_nonvector_objects;The query returns the object owner, name, type, used storage, total storage including dependent objects, and the reason the object is included in the calculation.