重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 统计 TEMP表空间使用情况 [打印本页]

作者: Inkcup 时间: 2025-11-23 17:07
标题: 统计 TEMP表空间使用情况
SELECT D.tablespace_name,
            SPACE                         total_mb,
            used_space    used_mb ,
            SPACE - used_space as free_mb,
            Round(Nvl(used_space, 0) / SPACE * 100, 2) "USED_RATE(%)",
            '['||DECODE(SPACE - used_space,0,'XXXXXXXXXXXXXXXXXXXX',
                  NVL(RPAD(LPAD('X',(TRUNC(Round(Nvl(used_space, 0) / SPACE * 100, 2)/5)),'X'),20,'-'),'--------------------'))||']'
      FROM (SELECT tablespace_name,
                     Round(sum(decode(autoextensible,'YES',maxbytes,bytes)) / ( 1024 * 1024 ), 2) SPACE,
                     SUM(blocks)                         BLOCKS
            FROM dba_temp_files
            GROUP  BY tablespace_name) D,
            (SELECT tablespace,
                     Round(SUM(blocks * 8192) / ( 1024 * 1024 ), 2) USED_SPACE
            FROM v$sort_usage
            GROUP  BY tablespace) F
      WHERE  D.tablespace_name = F.tablespace(+)
order by 5 Desc;

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)