Search notes:

Oracle: DBA_TABLES

select
   tab.owner,
   tab.table_name,
   --
   tab.num_rows,
   --
   tab.activity_tracking,
   tab.admit_null,
   tab.avg_row_len,
   tab.avg_space,
   tab.avg_space_freelist_blocks,
   tab.backed_up,
   tab.blocks,
   tab.buffer_pool,
   tab.cache,
   tab.cell_flash_cache,
   tab.cellmemory,
   tab.chain_cnt,
   tab.cluster_name,
   tab.cluster_owner,
   tab.clustering,
   tab.compress_for,
   tab.compression,
   tab.container_data,
   tab.container_map,
   tab.container_map_object,
   tab.containers_default,
   tab.data_link_dml_enabled,
   tab.default_collation,
   tab.degree,
   tab.dependencies,
   tab.dml_timestamp,
   tab.dropped,
   tab.duplicated,
   tab.duration,
   tab.empty_blocks,
   tab.extended_data_link,
   tab.extended_data_link_map,
   tab.external,
   tab.flash_cache,
   tab.freelist_groups,
   tab.freelists,
   tab.global_stats,
   tab.has_identity,
   tab.has_sensitive_column,
   tab.hybrid,
   tab.ini_trans,
   tab.initial_extent,
   tab.inmemory,
   tab.inmemory_compression,
   tab.inmemory_distribute,
   tab.inmemory_duplicate,
   tab.inmemory_priority,
   tab.inmemory_service,
   tab.inmemory_service_name,
   tab.instances,
   tab.iot_name,
   tab.iot_type,
   tab.last_analyzed,
   tab.logging,
   tab.logical_replication,
   tab.max_extents,
   tab.max_trans,
   tab.memoptimize_read,
   tab.memoptimize_write,
   tab.min_extents,
   tab.monitoring,
   tab.nested,
   tab.next_extent,
   tab.num_freelist_blocks,
   tab.partitioned,
   tab.pct_free,
   tab.pct_increase,
   tab.pct_used,
   tab.read_only,
   tab.result_cache,
   tab.row_movement,
   tab.sample_size,
   tab.secondary,
   tab.segment_created,
   tab.sharded,
   tab.skip_corrupt,
   tab.status,
   tab.table_lock,
   tab.tablespace_name,
   tab.temporary,
   tab.user_stats
from
   sys.dba_tables tab;

See also

dba_all_tables
tab is a special synonym for user_tables.
data dictionary

Index