oracle 查看临时表空间 使用情况,Oracle 脚本-查看临时表空间使用率

```sql

SQL> SELECT TMP_TBS.TABLESPACE_NAME,

2 SUM(TMP_TBS.TOTAL_MB) TOTAL_MB,

3 SUM(USED_TOT.USED_MB) USED_MB,

4 SUM(USED_TOT.USED_MB) / SUM(TMP_TBS.TOTAL_MB) * 100 USED_PERSENT

5 FROM (SELECT TABLESPACE_NAME, SUM(BYTES) / 1024 / 1024 TOTAL_MB

6 FROM DBA_TEMP_FILES

7 GROUP BY TABLESPACE_NAME) TMP_TBS,

8 (SELECT TMP_USED.TABLESPACE,

9 SUM(TMP_USED.BLOCKS * PARA.DB_BLOCK_SIZE) / 1024 / 1024 USED_MB

10 FROM V$SORT_USAGE TMP_USED,

11 (SELECT VALUE DB_BLOCK_SIZE

12 FROM V$PARAMETER

13 WHERE NAME = 'db_block_size') PARA

14 GROUP BY TMP_USED.TABLESPACE) USED_TOT

15 where TMP_TBS.TABLESPACE_NAME = USED_TOT.TABLESPACE(+)

16 GROUP BY TMP_TBS.TABLESPACE_NAME;

TABLESPACE_NAME TOTAL_MB USED_MB USED_PERSENT

------------------------------ ---------- ---------- ------------

TEMP 1050 1 0.0952380952

```