一時表領域の最大／使用サイズを確認するスクリプト(修正版)

よくよく考えたら V$TEMP_SPACE_HEADER だけで良かったでござる(´･ω･｀)

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';
COLUMN BYTES_MAX  FORMAT 999,999,999,999;
COLUMN BYTES_FREE FORMAT 999,999,999,999;
COLUMN BYTES_USED FORMAT 999,999,999,999;
SELECT SYSDATE
     , T.TABLESPACE_NAME
     , SUM(T.BYTES_USED + T.BYTES_FREE) AS BYTES_MAX
     , SUM(T.BYTES_FREE)                AS BYTES_FREE
     , SUM(T.BYTES_USED)                AS BYTES_USED
  FROM V$TEMP_SPACE_HEADER T
 GROUP BY TABLESPACE_NAME;

結果のサンプルは↓

SYSDATE             TABLESPACE_NAME     BYTES_MAX    BYTES_FREE    BYTES_USED
------------------- --------------- ------------- ------------- -------------
2011/11/20 11:24:26 TEMP            1,178,599,424   714,080,256   464,519,168