统计业务用户,表名,表大小,表行数
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%');