19c 和11g临时表空间使用率
19c临时表空间使用率(实际正在使用的)
select total_extents,free_extents,used_extents,added_extents from v$sort_segment;
select case when exists(select * from v$tempseg_usage) then round((select sum(a.blocks)*8192/sum(b.bytes) from v$tempseg_usage a,dba_temp_files b)*100,0) else 0 end "PTC" from dual;
11g临时表空间使用率(这个使用率是temp高水位)
select c.tablespace_name, to_char(c.bytes / 1024 / 1024 / 1024, '99,999.999') total_gb, to_char((c.bytes - d.bytes_used) / 1024 / 1024 / 1024, '99,999.999') free_gb, to_char(d.bytes_used / 1024 / 1024 / 1024, '99,999.999') use_gb, to_char(d.bytes_used * 100 / c.bytes, '99.99') || '%' use from (select tablespace_name, sum(bytes) bytes from dba_temp_files GROUP by tablespace_name) c, (select tablespace_name, sum(bytes_cached) bytes_used from v$temp_extent_pool GROUP by tablespace_name) d where c.tablespace_name = d.tablespace_name;
11g增强视图查看使用率(这个使用率是实际正在使用的)
select tablespace_name,tablespace_size/1024/1024/1024,allocated_space/1024/1024/1024,free_space/1024/1024/1024 from dba_temp_free_space;
本文来自博客园,作者:蚌壳里夜有多长,转载请注明原文链接:https://www.cnblogs.com/dbahrz/p/17283670.html