SYS.V$TABLE_SIZES

This view contains data about the space used by a table or materialized view, including indexes.

There must be the SELECT privilege on the specified table or materialized view in order for the table or materialized view to be included in the result set of the query.

Columns

Column name Type Description

TBLNAME

TT_CHAR (61)

Name of the table

SIZE

BINARY_DOUBLE NOT NULL

Size of the table

ELEMENTID

TT_INTEGER NOT NULL

Ignore this column. It is unused.