segment_size
emcs
41次下载
473次浏览
2019-07-24
4.5

脚本内容

col SEGMENT_TYPE for a15 
col owner for a10
col tablespace_name for a10 
col segment_name for a30
select owner,segment_name,segment_type,tablespace_name,sum(bytes)/1024/1024 from dba_segments where segment_name=upper('&seg_name') group by owner,segment_name,segment_type,tablespace_name;

评论

贡献排行榜