Oracle: TAB$

select
-- tab.obj#,
   own.name      as tab_owner,
   obj.name      as tab_name,
   tab.dataobj#,
   tab.ts#,
   tab.file#      as segmeht_header_file_id,
   tab.block#     as segment_header_block_id,
   tab.bobj#      as base_obj,
   tab.tab#,      -- Table number in cluster (if not null)
   tab.cols       as nof_cols,
   tab.intcols    as nof_int_cols,      -- internal columns
   tab.kernelcols as nof_kernel_cols,   -- Real columns
   tab.clucols,
   tab.pctfree$,
   tab.pctused$,
   tab.initrans,
   tab.maxtrans,

   tab.flags,
   case when bitand(tab.flags, power(2,0)) > 0 then 'yes' end modif_since_last_backup,
   case when bitand(tab.flags, power(2,3)) > 0 then 'yes' end cache,

   tab.audit$,
   tab.rowcnt,
   tab.blkcnt,
   tab.empcnt,
   tab.avgspc,
   tab.chncnt,
   tab.avgrln,
   tab.avgspc_flb,
   tab.flbcnt,
   tab.analyzetime,
   tab.samplesize,
   tab.degree,
   tab.instances,
   tab.property,
   case when bitand(tab.property, power(2, 47)) > 0 then 'yes' end row_archival     , -- See Is my table marked for archive? and In-database archiving
   case when bitand(tab.property, power(2, 89)) > 0 then 'yes' end sensitive_columns, -- Table contains sensitive columns
   case when bitand(tab.spare7  , power(2, 11)) > 0 then 'yes' end immutable_table  , -- Table is immutable
   tab.trigflag,
   tab.spare1,   -- See also event 10058 (use table scan cost in tab$.spare1)
   tab.spare2,
   tab.spare3,   -- An SCN? See $ORACLE_HOME/rdbms/admin/catsnap.sql
   tab.spare4,
   tab.spare5,
   tab.spare6,
   tab.spare7,
   tab.spare8,
   tab.spare9,
   tab.spare10,
   tab.acdrflags,
   tab.acdrtsobj#
from
   sys.tab$  tab                           join
   sys.obj$  obj on tab.obj#   = obj.obj#  join
   sys.user$ own on obj.owner# = own.user#
;