select 'max' as status,
tablespace_name,
sum(bytes_cached) / 1024 / 1024 as usage
from v$temp_extent_pool
group by tablespace_name
union all
select 'current' as status,
ss.tablespace_name,
sum((ss.used_blocks * ts.blocksize)) / 1024 / 1024 as usage
from gv$sort_segment ss, sys.ts$ ts
where ss.tablespace_name = ts.name
group by ss.tablespace_name;
查看临时表空间当前的占用情况，以及历史最大使用情况。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024