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 ·
369 阅读 ·
0 评论