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;