oracle统计用户下表的大小
Select username,default_tablespace,created from dba_users order by created desc;
select segment_name, bytes/1024/1024/1024 from dba_segments where owner in ("WLS816","WYJK","XCYS","PERFSTAT","TROUBLE","DLWH","OSSLOG","WEBLOGIC","TELECOM","TELECOMNEW") and SEGMENT_TYPE="TABLE" order by 2 desc;
select segment_name, bytes/1024/1024/1024 from dba_segments where owner in ("WLS816","WYJK","XCYS","PERFSTAT","TROUBLE","DLWH","OSSLOG","WEBLOGIC","TELECOM","TELECOMNEW") and SEGMENT_TYPE="TABLE" order by 2 desc;
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
- 上一篇： java修改session默认过期时间
- 下一篇： 学习之http缓存策略
