oracle查看用户所占用的表空间
时间：2021-07-01 10:21:17
帮助过：2人阅读
*
from (
select owner
|| ‘.‘ || tablespace_name name,
sum(b) g
from (
select owner,
t.segment_name,
t.partition_name,
round(bytes
/ 1024 / 1024 / 1024,
2) b,
tablespace_name
from dba_segments t)
where owner
not in
(‘SYS‘,
‘OUTLN‘,
‘SYSTEM‘,
‘TSMSYS‘,
‘DBSNMP‘,
‘WMSYS‘)
group by owner
|| ‘.‘ || tablespace_name)
order by name;
oracle查看用户所占用的表空间
标签：
