SYS.ALL_TAB_SIZES

The ALL_TAB_SIZES view contains information about the size of tables that are accessible to the current user. This view also includes information on the size of materialized views and cache tables.

For more information, see ttComputeTabSizes in the Oracle TimesTen In-Memory Database Reference.

Related views

• SYS.DBA_TAB_SIZES contains the information about the size of tables and materialized views that are available in the database. It has the same columns as SYS.ALL_TAB_SIZES.

• SYS.USER_TAB_SIZES contains the information about the size of tables and materialized views that are owned by the current user. This view does not contain the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Owner of table or materialized view
TABLE_NAME	VARCHAR2(30) INLINE	Name of table or materialized view
INLINE_ALLOC_BYTES	TT_BIGINT NOT NULL	The amount of bytes allocated for row pages for the table (inline values)
NUM_USED_ROWS	TT_BIGINT NOT NULL	The number of rows that are active or unlinked (pending deletes or updates) This column has different semantics than column NUMTUPS in SYS.TABLES. For more information on SYS.TABLES, see SYS.TABLES.
NUM_FREE_ROWS	TT_BIGINT NOT NULL	The number of rows that can be inserted into the table without additional allocation cost This does not include the cost of inserted out-of-line values.
AVG_ROW_LEN	TT_BIGINT	The average amount of bytes used to store a row This value considers utilization of row pages, out-of-line buffers and system metadata.
OUT_OF_LINE_BYTES	TT_BIGINT	The sum of the sizes of out-of-line buffers that store varying character values for the table
METADATA_BYTES	TT_BIGINT NOT NULL	Size of internal data structures for system usage Compressed tables contain a dictionary that includes the distinct compressed values. These values are considered part of the metadata.
INDEX_BYTES	TT_BIGINT NOT NULL	Space usage by all indexes for table
TOTAL_BYTES	TT_BIGINT	The sum of INLINE_ALLOC_BYTES, OUT_OF_LINE_BYTES, and METADATA_BYTES If OUT_OF_LINE_BYTES is NULL then the value of this column is NULL.
LAST_UPDATED	TT_TIMESTAMP NOT NULL	Time of last update