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 ...

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial