Oracle - Table Information (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

table_info.sql

-- table info is only as up to date as last time stats were gathered (last_analyzed)
select t.owner, t.table_name, t.num_rows, t.avg_row_len,
    t.blocks as blocks_below_hwm, t.empty_blocks,
    s.blocks as segment_blocks,
    s.bytes / 1048576 as size_in_mb,
    to_char(t.last_analyzed, 'YYYY-MM-DD HH24:MI') as last_analyzed
from all_tables t, dba_segments s
where t.owner = s.owner and t.table_name = s.segment_name
and t.owner = 'SCHEMA_NAME';