DBA_TABLES

This view lists all the tables in the database. There are the corresponding ALL_TABLES and USER_TABLES, showing, respectively, the tables which the current user can access and the tables the current user owns.

Fields

The most relevant view fields are as follows:

• OWNER: The owner of the table

• TABLE_NAME: The name of the table

• TABLESPACE_NAME: The name of the tablespace in which the table is stored

• STATUS: This can be VALID or UNUSABLE

• LOGGING: This indicates whether changes to the table are logged or not (YES/NO)

• NUM_ROWS: The number of rows in the table

• BLOCKS: The number of used database blocks in the table

• EMPTY_BLOCKS: The number of empty database blocks in the table

• AVG_SPACE: The average free space in bytes for allocated data blocks

• CHAIN_CNT: The number of chained rows in the table

• AVG_ROW_LEN: The average length of a row in the table

• AVG_SPACE_FREELIST_BLOCKS: The average free space of all blocks on a freelist

• NUM_FREELIST_BLOCKS: The number of blocks in a freelist

• SAMPLE_SIZE: The sample size used when analyzing the table

• GLOBAL_STATS: For partitioned tables, this indicates whether the statistics were made on all the partitions (YES) or estimated (NO)

• USER_STATS: This indicates whether the statistics were entered by the user (YES/NO)

• LAST_ANALYZED: The date on which the table was last analyzed