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, 89)) > 0 then 'yes' end sensitive_columns, -- Table contains sensitive columns
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#
;