脚本：监控临时表空间使用率

最新推荐文章于 2024-12-15 08:40:05 发布

转载最新推荐文章于 2024-12-15 08:40:05 发布 · 71 阅读

本文提供了一种查询Oracle数据库中临时表空间使用率的方法，分别适用于字典管理和本地管理的临时表空间。通过SQL语句计算已用块数与总块数的比例，得出临时表空间的使用百分比。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

针对字典管理临时表空间:

select (s.tot_used_blocks/f.total_blocks)*100 as "percent used" from 
(select sum(used_blocks) tot_used_blocks from v$sort_segment where tablespace_name='TEMP') s, 
(select sum(blocks) total_blocks from dba_data_files where tablespace_name='TEMP') f;

针对本地管理表空间:

select (s.tot_used_blocks/f.total_blocks)*100 as "percent used" from 
(select sum(used_blocks) tot_used_blocks from v$sort_segment where tablespace_name='TEMP') s, 
(select sum(blocks) total_blocks from dba_temp_files where tablespace_name='TEMP') f;

示例输出:

 select (s.tot_used_blocks/f.total_blocks)*100 as "percent used"
  2  from (select sum(used_blocks) tot_used_blocks from 
v$sort_segment where tablespace_name='TEMP') s, 
(select sum(blocks) total_blocks from dba_temp_files where tablespace_name='TEMP') f;

percent used
------------
           0

关注博主即可阅读全文