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 ...
原创
2019-09-05 13:49:13 ·
388 阅读 ·
0 评论