当前位置：首页 > 数据库 > Oracle教程 > 表空间使用量查询 > 正文

表空间使用量查询

来源：这里教程网 时间：2026-03-03 15:18:07 作者：
SET LINE 200
COL TABLESPACE_NAME FOR A30
WITH
F AS (SELECT TABLESPACE_NAME ,SUM(BYTES) FREE_SUM_BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME),
D AS (SELECT TABLESPACE_NAME ,SUM(BYTES) TOTAL_SUM_BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME)
SELECT
D.TABLESPACE_NAME
,ROUND(D.TOTAL_SUM_BYTES/1024/1024/1024, 2) TOTAL_GB
,ROUND((D.TOTAL_SUM_BYTES - F.FREE_SUM_BYTES)/1024/1024/1024, 2) USED_GB
,NVL(ROUND(F.FREE_SUM_BYTES/1024/1024/1024, 2), 0) FREE_GB
,NVL(ROUND((D.TOTAL_SUM_BYTES - F.FREE_SUM_BYTES)*100/D.TOTAL_SUM_BYTES, 2), 100) USED_PERCENT
,NVL(ROUND(F.FREE_SUM_BYTES*100/D.TOTAL_SUM_BYTES, 2), 0) FREE_PERCENT
FROM D, F
WHERE D.TABLESPACE_NAME=F.TABLESPACE_NAME(+)
ORDER BY FREE_PERCENT;
WITH
C AS (SELECT TABLESPACE_NAME,SUM(BYTES) BYTES FROM DBA_TEMP_FILES GROUP BY TABLESPACE_NAME),
D AS (SELECT TABLESPACE_NAME,SUM(BYTES_CACHED) BYTES_USED FROM V$TEMP_EXTENT_POOL GROUP BY TABLESPACE_NAME)
SELECT
C.TABLESPACE_NAME
, ROUND(C.BYTES/1024/1024/1024, 2) TOTAL_SIZE_GB
, ROUND((C.BYTES-D.BYTES_USED)/1024/1024/1024, 2) FREE_SIZE_GB
, ROUND(D.BYTES_USED/1024/1024/1024, 2) USED_SIZE_GB
, ROUND(D.BYTES_USED*100/C.BYTES, 2) USED_PCT
FROM C, D
WHERE C.TABLESPACE_NAME = D.TABLESPACE_NAME
;

编辑推荐：

相关推荐

最新软件资讯

周六直播充电：探究Oracle分区表创建和使用
周六直播充电：探究Oracle分区表创建和使用

热文推荐

天极热推