Oracle: DBA_TABLES

select
   tab.owner,
   tab.table_name,
   --
   tab.num_rows,
   --
   tab.temporary,                          -- Determines if a table is a global temporary table (GTT)
   tab.duration,                           -- For GTTs, specifies if data is deleted when transaction ends (SYS$TRANSACTION) or remains during the session (SYS$SESSION)
   --
   tab.activity_tracking,
   tab.admit_null,                         -- Whether null is allowed in CON_ID
   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,                       -- If a table was created with ROWDEPENDENCIES or NOROWDEPENDENCES (see for example ora_rowscn)
   tab.dml_timestamp,                      -- Modification time, creation time, or both for Automatic Data Optimization
   tab.dropped,
   tab.duplicated,
   tab.empty_blocks,
   tab.extended_data_link,
   tab.extended_data_link_map,
   tab.external,
   tab.externally_duplicated,              -- Compare with SYNCHRONOUS_DUPLICATED
   tab.externally_sharded,
   tab.flash_cache,
   tab.freelist_groups,
   tab.freelists,
   tab.global_stats,
   tab.has_identity,
   tab.has_reservable_column,
   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,                          -- Flag if table is read only (YES / NO).
   tab.result_cache,
   tab.row_change_tracking,                -- Not documented
   tab.row_movement,
   tab.sample_size,
   tab.secondary,
   tab.segment_created,
   tab.sharded,
   tab.skip_corrupt,
   tab.staging,
   tab.status,
   tab.synchronous_duplicated,             -- Compare with EXTERNALLY_DUPLICATED
   tab.table_lock,
   tab.tablespace_name,
   tab.user_stats
from
   sys.dba_tables tab;

create table tq84_sample_size (txt varchar2(1000), num number);
 
insert into tq84_sample_size
select
   lpad('x', 1000, 'x'),
   rownum
from
   dual connect by level <= 101010;
 
select num_rows, sample_size, last_analyzed from user_tables where table_name = 'TQ84_SAMPLE_SIZE';  
 
begin
   dbms_stats.gather_table_stats(user, 'tq84_sample_size', estimate_percent => 13.3);
end;
/
 
select
   num_rows,
   sample_size,
   to_char(100/num_rows * sample_size, '90.0') || '%' sample_size_,
   last_analyzed
from
   user_tables where table_name = 'TQ84_SAMPLE_SIZE';  
   
drop table tq84_sample_size;