DBA_NONJSON_OBJECTS View

Displays the list of non-JSON objects on an Autonomous Database instance and includes a column with the space consumption in bytes of the object and dependent objects.

This view is only accessible to the ADMIN user. You cannot issue grant commands to make this view accessible to other users.

Note that querying this view on systems with a large amount of data may take some time and is not instantaneous.

Column	Datatype	NULL	Description
OWNER	VARCHAR(128)	Not NULL	Table owner
TABLE_NAME	VARCHAR(128)	Not NULL	Table name
TABLE_BYTES	NUMBER	Not NULL	Size, in bytes, of the table
REASON	VARCHAR(128)	Not NULL	Reason why the table is considered a non-JSON table. Reason can have one of the following values: NO JSON CONTENT: Table and dependent objects do not contain any JSON information. DATA TYPE VIOLATION: Table contains constrained datatypes. Columns that are not JSON can include only columns Oracle built-in types. Columns cannot be of type: LONG, LONG RAW, LOB related (CLOB/NCLOB/BLOB/BFILE), or VECTOR. MAXIMUM SIZE OF NON-JSON COLUMNS EXCEEDED: Table exceeds the allotted limit of non-JSON columns.
TABLE_AND_DEPENDENTS_BYTES	NUMBER	Not NULL	Size, in bytes, of the table, and all its dependent objects. For example, LOB segments, indexes, materialized views.