oracle 统计业务用户，表名，表大小，表行数

统计业务用户，表名，表大小，表行数

select owner,table_name,(BLOCKS*8/1024) sizes_m,NUM_ROWS from dba_tables where owner in (
SELECT d.username
  FROM dba_users d
 WHERE d.account_status = 'OPEN'
   and d.username not like '%SYS%')
order by 4 desc ;

统计业务用户，表名，表中的列

select owner,table_name,column_name from dba_col_comments where owner in (SELECT d.username
  FROM dba_users d
 WHERE d.account_status = 'OPEN'
   and d.username not like '%SYS%');