1:²éѯORACLEÊý¾Ý¿â
SELECT F.TABLESPACE_NAME ±í¿Õ¼ä,
(T.TOTAL_SPACE ¨C F.FREE_SPACE) ÒÑÓñí¿Õ¼ä,
F.FREE_SPACE Ê£Óà±í¿Õ¼ä,
T.TOTAL_SPACE ×ܱí¿Õ¼ä,
(ROUND((F.FREE_SPACE / T.TOTAL_SPACE) * 100)) || ¡®% ¡® Ê£Óà±í¿Õ¼ä°Ù·Ö±È
FROM (SELECT TABLESPACE_NAME,
ROUND(SUM(BLOCKS *
(SELECT VALUE / 1024
FROM V$PARAMETER
WHERE NAME = ¡®db_block_size¡¯) / 1024)) FREE_SPACE
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
(SELECT TABLESPACE_NAME, ROUND(SUM(BYTES / 1048576)) TOTAL_SPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
2£º²éѯDB2Êý¾Ý¿â
select * from table(snapshot_tbs_cfg(¡®STUDY¡¯,-1));
ÆäÖÐSTUDYÊÇÊý¾Ý¿âÃû
-1 ±íʾµ±Ç°»î¶¯µÄÊý¾Ý¿â·ÖÇø
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª-
Ö´ÐÐÃüÁ(¸ÃÃüÁîÖ»¼ì²éDMS¼´Êý¾Ý¿âÀàÐ͵ıí¿Õ¼ä)
select
substr(varchar(t.SNAPSHOT_TIMESTAMP),1,13) as time ,
t.TABLESPACE_ID,
substr(t.TABLESPACE_NAME,1,30) as TABLESPACE_NAME,
t.TOTAL_PAGES*t.PAGE_SIZE/1024/1024 as TOTAL_MB_SIZE ,
t.FREE_PAGES*t.PAGE_SIZE/1024/1024 as FREE_MB_SIZE ,
decimal(t.USED_PAGES,31,3)/t.TOTAL_PAGES*100 as USAGE_PERCENT
from table(snapshot_tbs_cfg(¡®TPAHIS¡¯,-2)) as t
where t.TABLESPACE_TYPE=0
order by t.TABLESPACE_ID;