| |
글쓴이 : 좋은진호(truefeel, http://coffeenix.net/ )
글쓴날 : 1999.11(?)
현재 접속한 DB user가 사용한 테이블스페이스 용량과 남은 용량 확인.
SET LINESIZE 90
SELECT USE.TABLESPACE_NAME,
(USE.U_BYTES + FREE.F_BYTES) AS "할당 KB",
USE.U_BYTES AS "사용 KB", USE.U_BLOCKS AS "사용 BLOCKS",
FREE.F_BYTES AS "남은 KB", FREE.F_BLOCKS AS "남은 BLOCKS"
FROM
( SELECT TABLESPACE_NAME, SUM(bytes)/1024 AS U_BYTES, SUM(blocks) AS U_BLOCKS
FROM USER_TS_QUOTAS GROUP BY TABLESPACE_NAME) USE,
( SELECT TABLESPACE_NAME, SUM(bytes)/1024 AS F_BYTES, SUM(blocks) AS F_BLOCKS
FROM USER_FREE_SPACE GROUP BY TABLESPACE_NAME) FREE
WHERE USE.TABLESPACE_NAME = FREE.TABLESPACE_NAME;
|
