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.