檢查每個用戶下的實際佔用數據尺寸
select owner,sum(bytes)/1024/1024 from dba_extents group by owner;
檢查所有狀態為OPEN的用戶下的實際佔用數據尺寸
select owner,sum(bytes)/1024/1024 from dba_extents where owner in(select username from dba_users where account_status='OPEN' and username not in ('SYS','SYSTEM')) group by owner;
檢查所有狀態為OPEN的用戶下的實際佔用數據尺寸
select owner,sum(bytes)/1024/1024 from dba_extents where owner in(select username from dba_users where account_status='OPEN' and username not in ('SYS','SYSTEM')) group by owner;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-704258/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
檢查session狀況
下一篇：
Oracle開機關機腳本
请登录后发表评论
登录
全部评论
