查看数据库磁盘使用多少G:
select OWNER, t.segment_name, t.segment_type, sum(t.bytes / / / ) G
from dba_segments t
where t.owner = 'TPSC'
group by OWNER, t.segment_name, t.segment_type
order by G desc;
查看数据库磁盘使用多少G:
select OWNER, t.segment_name, t.segment_type, sum(t.bytes / / / ) G
from dba_segments t
where t.owner = 'TPSC'
group by OWNER, t.segment_name, t.segment_type
order by G desc;